Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 71:

  A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

  1.

  Created a user called "CONSUMER"

  2.

  Created a database to hold the share and an extra-small warehouse to query the data

  3.

  Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

  Based on this configuration what is true of the reader account?

  A. The reader account will automatically use the Standard edition of Snowflake.

  B. The reader account compute will be billed to the provider account.

  C. The reader account can clone data the provider has shared, but cannot re-share it.

  D. The reader account can create a copy of the shared data using CREATE TABLE AS...

  Correct Answer: B

• Question 72:

  Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

  A. VARIANT

  B. VARRAY

  C. STRUCT

  D. ARRAY

  E. QUEUE

  Correct Answer: AD

• Question 73:

  A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.

  How can this requirement be met?

  A. Use data encryption.

  B. Use dynamic data masking.

  C. Use secure materialized views.

  D. Revoke all roles for functional managers and end users.

  Correct Answer: B

• Question 74:

  What file formats does Snowflake support for loading semi-structured data? (Choose three.)

  A. TSV

  B. JSON

  C. PDF

  D. Avro

  E. Parquet

  F. JPEG

  Correct Answer: BDE

• Question 75:

  The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

  A. In the metadata of the target table for 14 days

  B. In the metadata of the pipe for 14 days

  C. In the metadata of the target table for 64 days

  D. In the metadata of the pipe for 64 days

  Correct Answer: C

• Question 76:

  What is true about sharing data in Snowflake? (Choose two.)

  A. The Data Consumer pays for data storage as well as for data computing.

  B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

  C. A Snowflake account can both provide and consume shared data.

  D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.

  E. The Data Consumer pays only for compute resources to query the shared data.

  Correct Answer: CE

• Question 77:

  Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

  A. SHOW GRANTS OF ROLE MY_ROLE

  B. SHOW GRANTS TO ROLE MY_ROLE

  C. SHOW GRANTS FOR ROLE MY_ROLE

  D. SHOW GRANTS ON ROLE MY_ROLE

  Correct Answer: A

• Question 78:

  Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. Which SQL command should be used to delete the files?

  A. PURGE

  B. MODIFY

  C. REMOVE

  D. DELETE

  Correct Answer: C

  Reference: https://www.simplilearn.com/tutorials/sql-tutorial/delete-in-sql#:~:text=The%20Delete%20command%20in%20SQL,the%20records%20from%20a%20table

• Question 79:

  If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

  A. 4

  B. 8

  C. 16

  D. 32

  Correct Answer: B

  Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:

  

  https://docs.snowflake.com/en/user-guide/warehouses-overview.html

• Question 80:

  A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table. How can this be accomplished?

  A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

  B. The transient table version cannot be retrieved after 24 hours.

  C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.

  D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

  Correct Answer: B