Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 701:

  Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:

  Choose 2 answers

  A. Temporary Tables

  B. Transient Tables

  C. Provisional Tables

  D. Permanent Tables

  Correct Answer: AB

  Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

• Question 702:

  Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

  A. Custom

  B. Economy

  C. Optimized

  D. Standard

  Correct Answer: BD

  Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

• Question 703:

  What privileges are required to create a task?

  A. The global privilege create task is required to create a new task.

  B. Tasks are created at the Application level and can only be created by the Account Admin role.

  C. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

  D. The role must have access to the target schema and the create task privilege on the schema itself.

  Correct Answer: D

  All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.

  https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

• Question 704:

  Which of the following items does the Cloud services Layer manage? Choose 4 answers

  A. user authentication

  B. Metadata

  C. Query compilation and optimization

  D. external blob storage

  E. Data security

  Correct Answer: ABCE

• Question 705:

  True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/connecting.html

• Question 706:

  A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

  COPY INTO my__table FROM @my__stage;

  The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

  If the user runs the same copy into command what will happen?

  A. All data from all of the files on the stage will be appended to the table

  B. Only data about new customers from the new files will be appended to the table

  C. The operation will fail with the error uncertain files in stage.

  D. All data from only the newly-added files will be appended to the table.

  Correct Answer: D

  https://docs.snowflake.com/en/user-guide/data-load-considerations-load.html#executing-parallel-copy-statements-that-reference-the-same-data-files

• Question 707:

  Which copy INTO command outputs the data into one file?

  A. SINGLE=TRUE

  B. MAX_FILE_NUMBER=1

  C. FILE_NUMBER=1

  D. MULTIPLE=FAISE

  Correct Answer: A

• Question 708:

  A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?

  A. Okta Verify

  B. Duo Mobile

  C. Microsoft Authenticator

  D. Google Authenticator

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/security-mfa.html

• Question 709:

  What Snowflake role must be granted for a user to create and manage accounts?

  A. ACCOUNTADMIN

  B. ORGADMIN

  C. SECURITYADMIN

  D. SYSADMIN

  Correct Answer: B

• Question 710:

  What feature can be used to reorganize a very large table on one or more columns?

  A. Micro-partitions

  B. Clustering keys

  C. Key partitions

  D. Clustered partitions

  Correct Answer: B

  https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html