Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 91:

  Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

  A. grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

  B. grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

  C. grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

  D. grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

  E. grant SELECT on all tables in database DB1 to role MYROLE;

  F. grant SELECT on future tables in database DB1 to role MYROLE;

  Correct Answer: CD

• Question 92:

  A user has unloaded data from a Snowflake table to an external stage.

  Which command can be used to verify if data has been uploaded to the external stage named my_stage?

  A. view @my_stage

  B. list @my_stage

  C. show @my_stage

  D. display @my_stage

  Correct Answer: B

• Question 93:

  Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

  A. USAGE

  B. OPERATE

  C. MONITOR

  D. MODIFY

  Correct Answer: B

  Reference: https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privilege

• Question 94:

  Which of the following is a data tokenization integration partner?

  A. Protegrity

  B. Tableau

  C. DBeaver

  D. SAP

  Correct Answer: A

• Question 95:

  Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

  A. Cloud services layer

  B. Compute layer

  C. Storage layer

  D. Cloud agnostic layer

  Correct Answer: B

  Reference: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556

• Question 96:

  How long is the Fail-safe period for temporary and transient tables?

  A. There is no Fail-safe period for these tables.

  B. 1 day

  C. 7 days

  D. 31 days

  E. 90 days

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

• Question 97:

  What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

  A. The shared objects are transferred.

  B. The shared objects are copied.

  C. The shared objects become accessible.

  D. The shared objects can be re-shared.

  Correct Answer: C

• Question 98:

  Which cache type is used to cache data output from SQL queries?

  A. Metadata cache

  B. Result cache

  C. Remote cache

  D. Local file cache

  Correct Answer: B

  https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

• Question 99:

  Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

  A. The number of queries executed

  B. The number of active users assigned to the warehouse

  C. The size of the virtual warehouse

  D. The length of time the warehouse is running

  E. The duration of the queries that are executed

  Correct Answer: CD

• Question 100:

  Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

  A. CONTENT

  B. PATH

  C. BYTE_SIZE

  D. INDEX

  E. DATATYPE

  Correct Answer: BD