試験SOL-C01 トピック2 問題69 スレッド
Snowflake SOL-C01のリアル試験問題集
問題 #: 69
トピック #: 2
問題 #: 69
トピック #: 2
You are tasked with creating a share to provide access to a database named `CUSTOMER DB'.
This database contains a table 'CUSTOMER INFO and a secure UDF `MASK EMAIL'. You need to grant the necessary privileges on the share such that consumers can use both the table and the UDF. Which of the following SQL statements are required to properly configure the share named 'CUSTOMER SHARE? (Select all that apply)
This database contains a table 'CUSTOMER INFO and a secure UDF `MASK EMAIL'. You need to grant the necessary privileges on the share such that consumers can use both the table and the UDF. Which of the following SQL statements are required to properly configure the share named 'CUSTOMER SHARE? (Select all that apply)
おすすめの解答:A,B,C,D 解答を投票する
To properly configure the share, you need to grant USAGE on the database, SELECT on the table, USAGE on the schema containing the table and UDF, and EXECUTE on the UDF.
Granting ALL PRIVILEGES on the database is generally not recommended for security reasons and is not necessary in this case.
Granting ALL PRIVILEGES on the database is generally not recommended for security reasons and is not necessary in this case.
玉置** 2026-05-26 06:10:48
コメント
他人の解答コメントを賛成するのも、その解答に一票を入れることになります。したがって、すでに同じ意見の投票コメントが存在する場合、新規コメントをする代わりに賛成することもできます。
コメントを通報する
コメント中
今すぐ 新規登録 / ログイン (無料です)。