Snowflake SnowPro® Core Certification (COF-C03) - COF-C03 Exam Practice Test

A. select src.dealership from car_sales; B. select dealership from car_sales; C. select src:dealership from car_sales; D. select src:Dealership from car_sales;

A. Clustered partitions B. Micro-partitions C. Key partitions D. Clustering keys

A. Identifies columns with personal information and tags them so masking policies can be applied to protect sensitive data B. Shows how the accessed data was moved from the source lo the target objects C. Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy D. Protects sensitive data from unauthorized access while allowing authorized users to access it at query runtime E. Provides a unified picture of what data was accessed and when it was accessed

A. True B. False

A. 7 days B. 1 day C. 90 days D. 0 days

A. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role. B. The ACCOUNTADMIN role must be granted to only one user. C. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role. D. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA). E. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

A. SSO is an integrated Snowflake feature powered by the Duo Security service which is managed completely by Snowflake. B. SSO is an authentication method that allows a user to sign into multiple applications with a single set of credentials. C. SSO is an authentication method which uses a pair of keys, a public key and a private key. to verify the identity of a user. D. SSO is an authentication method that uses a username and password in the API request header.

A. Snowpipe B. COPY_INTO <location> command C. Data replication D. Direct share

A. Use SECONDARY ROLES RESUME B. USE SECONDARY ROLES SUSPEND C. USE SECONDARY ROLES ADD <Role Name> D. USE SECONDARY RLES ALL E. Use SECONDARY ROLES NONE

A. LISTING TELEMETRY DAILY B. WAREHOUSE_METERING_HISTORY C. MONETIZED_USAGE_DAILY D. ACCESS_HISTORY E. DATA_TRANSFER_HISTORY