SnowPro Core Certification Exam (COF-C02) Free Questions - Part 11

Question No : 151) Network policies can be applied to which of the following Snowflake objects? (Choose two.)

A. Roles

B. Databases

C. Warehouses

D. Users

E. Accounts


Question No : 152) Which minimum Snowflake edition allows for a dedicated metadata store?

A. Standard

B. Enterprise

C. Business Critical

D. Virtual Private Snowflake


Question No : 153) Which of the following describes the Snowflake Cloud Services layer?

A. Coordinates activities in the Snowflake account

B. Executes queries submitted by the Snowflake account users

C. Manages quotas on the Snowflake account storage

D. Manages the virtual warehouse cache to speed up queries


Question No : 154) What is the default file size when unloading data from Snowflake using the COPY command?

A. 5 MB

B. 8 GB

C. 16 MB

D. 32 MB


Question No : 155) What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

B. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

C. The ACCOUNTADMIN role must be granted to only one user.

D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

E. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.


Question No : 156) A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used.
The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?

A. Compress the file and load the compressed file.

B. Split the file into multiple files in the recommended size range (100 MB - 250 MB).

C. Use a larger-sized warehouse.

D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.


Question No : 157) Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

A. Tri-Secret Secure

B. Time Travel

C. Fail-safe

D. Data encryption

E. External stages

 

Question No : 158) A user has a standard multi-cluster warehouse auto-scaling policy in place. Which condition will trigger a cluster to shut-down?

A. When after 2-3 consecutive checks the system determines that the load on the mostloaded cluster could be redistributed.

B. When after 5-6 consecutive checks the system determines that the load on the mostloaded cluster could be redistributed.

C. When after 5-6 consecutive checks the system determines that the load on the leastloaded cluster could be redistributed. 

D. When after 2-3 consecutive checks the system determines that the load on the leastloaded cluster could be redistributed.

 

Question No : 159) What actions will prevent leveraging of the ResultSet cache? (Choose two.)

A. Removing a column from the query SELECT list

B. Stopping the virtual warehouse that the query is running against

C. Clustering of the data used by the query

D. Executing the RESULTS_SCAN() table function

E. Changing a column that is not in the cached query


Question No : 160) When loading data into Snowflake, how should the data be organized?

A. Into single files with 100-250 MB of compressed data per file

B. Into single files with 1-100 MB of compressed data per file

C. Into files of maximum size of 1 GB of compressed data per file

D. Into files of maximum size of 4 GB of compressed data per file


Question No : 161) Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A. A directory table is a separate database object.

B. Directory tables store data file metadata.

C. A directory table will be automatically added to a stage.

D. Directory tables do not have their own grantable privileges.

E. Directory table data can not be refreshed manually.


Question No : 162) How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

A. Configure the warehouse to a size larger than generally required

B. Set the minimum and maximum clusters to autoscale

C. Use the standard warehouse scaling policy

D. Use the economy warehouse scaling policy

 

Question No : 163) Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

A. Management of metadata

B. Computing the data

C. Maintaining Availability Zones

D. Infrastructure security

E. Parsing and optimizing queries


Question No : 164) Assume there is a table consisting of five micro-partitions with values ranging from A to Z. Which diagram indicates a well-clustered table?

A.

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

B.

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

C. 

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

D.

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

 

Question No : 165) Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

A. Amazon Web Services

B. Docker

C. IBM Cloud

D. Microsoft Azure Cloud

E. Google Cloud Platform

F. Oracle Cloud

 

COF-C02 Answers

 

Part 1

Part 2

Part 3

Part 4

Part 5

Part 6

Part 7

Part 8

Part 9

Part 10

Part 11

Part 12

Part 13

Part 14

Part 15

Part 16

Part 17

Part 18