Q1. The following SQL command was executed: Use role SECURITYADMIN; Grant ownership On future tables In schema PROD. WORKING To role PROD_WORKING_OWNER; Grant role PROD_WORKING_OWNER to role SYSADMIN; Use role ACCOUNTADMIN; Create table PROD.WORKING.XYZ (value number) ; Which role(s) can alter or drop table XYZ?
A.Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
B. SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
C. PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
D. Only the PROD_WORKING_OWNER role can alter or drop table XYZ.
Correct Answer: C
Q2. An Administrator has a table named SALES_DATA which needs some edits, but the Administrator does not want to change the main table data. The Administrator decides to make a transient copy of this table and wants the transient table to have all the same permissions as the original table. How can the Administrator create the transient table so it inherits the same permissions as the original table, and what considerations need to be made concerning the requirements? (Select TWO).
A.Use the following SQL command: create transient table TRANSIENT_SALES_DATA as select * from SALES_DATA;
B. Use the following SQL command: create transient table TRANSIENT SALES DATA as select * from SALES_DATA copy grants;
C. Use the following SQL commands: create transient table TRANSIENT_SALES_DATA like SALES_DATA copy grants; insert into TRANSIENT_SALES_DATA select * from SALES_DATA;
D. Transient tables will persist until explicitly dropped and contribute to overall storage costs.
E. Transient tables will be purged at the end of the user session and do not have any Fail-safe period.
Correct Answer: B, D
Q3. What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).
A.SYSADMIN
B. SECURITYADMIN
C. ACCOUNTADMIN
D. IMPORT SHARE and CREATE DATABASE
E. IMPORT PRIVILEGES and SHARED DATABASE
Correct Answer: C, D
Q4. DatabaseA has a single schema called Schema1. This schema contains many tables and views. The ANALYST role has privileges to select from all objects in DatabaseA. Schema1. The SYSADMIN role clones DatabaseA to DatabaseA_clone. What privileges does the ANALYST role have on tables and views in DatabaseA_clone? (Select TWO).
A.USAGE on the schema DatabaseA clone
B. USAGE on the database DatabaseA_clone. Schemal
C. SELECT on all tables, and only non-secure views in DatabaseA_clone. Schemal
D. SELECT on all tables, and only secure views in DatabaseA_clone. Schemal
E. SELECT on all tables and views in DatabaseA_clone. Schema1
Correct Answer: C, E
Q5. Which type of listing in the Snowflake Marketplace can be added and queried immediately?
A.Monetized listing
B. Standard listing
C. Regional listing
D. Personalized listing
Correct Answer: B
$ 39
Reviews
There are no reviews yet.