Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 41:

  Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

  A. Use the DROP [file] command after the load completes.

  B. Specify the TEMPORARY option when creating the file format.

  C. Specify the PURGE copy option in the COPY INTO [table] command.

  D. Use the REMOVE command after the load completes.

  E. Use the DELETE LOAD HISTORY command after the load completes.

  Correct Answer: CD

• Question 42:

  When cloning a database, what is cloned with the database? (Choose two.)

  A. Privileges on the database

  B. Existing child objects within the database

  C. Future child objects within the database

  D. Privileges on the schemas within the database

  E. Only schemas and tables within the database

  Correct Answer: BD

• Question 43:

  Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

  A. SHOW STORAGE BY TABLE;

  B. SHOW TABLES;

  C. Information Schema-> TABLE_HISTORY

  D. Information Schema-> TABLE_FUNCTION

  E. Information Schema-> TABLE_STORAGE_METRICS

  Correct Answer: BE

• Question 44:

  Which data type can store more than one type of data structure?

  A. JSON

  B. BINARY

  C. VARCHAR

  D. VARIANT

  Correct Answer: D

• Question 45:

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

  A. Roles

  B. Databases

  C. Warehouses

  D. Users

  E. Accounts

  Correct Answer: DE

  https://docs.snowflake.com/en/user-guide/network-policies.html#label-verify-network-policy-activation

• Question 46:

  Which file formats are supported for unloading data from Snowflake? (Choose two.)

  A. Avro

  B. JSON

  C. ORC

  D. XML

  E. Delimited (CSV, TSV, etc.)

  Correct Answer: BE

• Question 47:

  By default, which Snowflake role is required to create a share?

  A. ORGADMIN

  B. SECURITYADMIN

  C. SHAREADMIN

  D. ACCOUNTADMIN

  Correct Answer: D

• Question 48:

  Where can a user find and review the failed logins of a specific user for the past 30 days?

  A. The USERS view in ACCOUNT_USAGE

  B. The LOGIN_HISTORY view in ACCOUNT_USAGE

  C. The ACCESS_HISTORY view in ACCOUNT_USAGE

  D. The SESSIONS view in ACCOUNT_USAGE

  Correct Answer: B

• Question 49:

  What internal stages are available in Snowflake? (Choose three.)

  A. Schema stage

  B. Named stage

  C. User stage

  D. Stream stage

  E. Table stage

  F. Database stage

  Correct Answer: BCE

• Question 50:

  Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

  A. PUT

  B. GET

  C. COPY

  D. SELECT

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html