In a managed access schema, who can grant privileges on objects in the schema to other roles? (Choose two.)
A. The schema owner role
B. The ORGADMIN system role
C. The USERADMIN system role
D. The role with the MANAGE GRANTS privilege
E. The role that owns the object in the schema
What activities can a user with the ORGADMIN role perform? (Choose two.)
A. Create INFORMATION_SCHEMA in a database.
B. View usage information for all accounts in the organization.
C. Enable database cloning for an account in the organization.
D. Enable database replication for an account in the organization.
E. View micro-partition information for all accounts in the organization.
Which objects will incur storage costs associated with Fail-safe?
A. External tables
B. Permanent tables
C. Data files available in internal stages
D. Data files available in external stages
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
A. B-tree
B. Indexing
C. Map reduce
D. Pruning
Which commands can only be executed using SnowSQL? (Choose two.)
A. COPY INTO
B. GET
C. LIST
D. PUT
E. REMOVE
A user has enabled the STRIP_OUTER_ARRAY file format option for the COPY INTO {table} command to remove the outer array structure.
What else will this format option and command do?
A. Load the records into separate table rows.
B. Unload the records from separate table rows.
C. Export data files in smaller chunks.
D. Ensure each unique element stores values of a single native data type.
What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology that is not listed in Snowflake's partner ecosystem?
A. Use Snowflake's native API.
B. Use a custom-built connector.
C. Contact Snowflake Support for a new driver.
D. Connect through Snowflake's JDBC or ODBC drivers.
What is the expiration period for a file URL used to access unstructured data in cloud storage?
A. The remainder of the session
B. An unlimited amount of time
C. The length of time specified in the expiration_time argument D. The same length of time as the expiration period for the query results cache
How does the Access_History view enhance overall data governance pertaining to read and write operations? (Choose two.)
A. Shows how the accessed data was moved from the source to the target objects
B. Provides a unified picture of what data was accessed and when it was accessed
C. Protects sensitive data from unauthorized access while allowing authorized users to access it at query runtime
D. Identifies columns with personal information and tags them so masking policies can be applied to protect sensitive data
E. Determines whether a given row in a table can be accessed by the user by filtering the data based on a given policy
How can network and private connectivity security be managed in Snowflake?
A. By setting up network policies with IPv4 IP addresses
B. By putting the Snowflake URL on the allowed list for get method responses
C. By manually setting up vulnerability patch management policies
D. By manually setting up an Intrusion Prevention System (IPS) on each account
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.