試験SOL-C01 トピック1 問題261 スレッド
Snowflake SOL-C01のリアル試験問題集
問題 #: 261
トピック #: 1
問題 #: 261
トピック #: 1
You have a Snowflake table named 'products' with columns 'product id', 'product_name', and
'price'. You need to create a view called 'expensive_products' that only shows products with a price greater than $100. However, you also want to ensure that only users with the 'PRODUCT VIEWER' role can access this view. What SQL statements are required to achieve this?
'price'. You need to create a view called 'expensive_products' that only shows products with a price greater than $100. However, you also want to ensure that only users with the 'PRODUCT VIEWER' role can access this view. What SQL statements are required to achieve this?
おすすめの解答：A 解答を投票する
Option A correctly creates the view with the required filtering and grants 'SELECT privilege to the
'PRODUCT VIEWER role. Option B includes 'WITH GRANT OPTION' which allows the to grant SELECT privileges to other roles, which is not a requirement here. Option C includes granting USAGE on Database, this might be required in your enviroment, so its not wrong, but not directly answering the question, so not ideal. Option D incorrectly uses 'ALTER VIEW expensive_products SET SECURE;' a Secure View, this is used to prevent the view definition from being visible. Option E grants 'ALL' privileges, this is not required, only `SELECT privilege is requested
'PRODUCT VIEWER role. Option B includes 'WITH GRANT OPTION' which allows the to grant SELECT privileges to other roles, which is not a requirement here. Option C includes granting USAGE on Database, this might be required in your enviroment, so its not wrong, but not directly answering the question, so not ideal. Option D incorrectly uses 'ALTER VIEW expensive_products SET SECURE;' a Secure View, this is used to prevent the view definition from being visible. Option E grants 'ALL' privileges, this is not required, only `SELECT privilege is requested
黒*瞳 2025-10-18 05:05:11
コメント
他人の解答コメントを賛成するのも、その解答に一票を入れることになります。したがって、すでに同じ意見の投票コメントが存在する場合、新規コメントをする代わりに賛成することもできます。
コメントを通報する
コメント中
今すぐ 新規登録 / ログイン （無料です）。