Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 681:

  True or False: Users are able to see the result sets of queries executed by other users that share their same role.

  A. True

  B. False

  Correct Answer: B

  Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

• Question 682:

  In which layer of its architecture does Snowflake store its metadata statistics? Select one.

  A. Storage Layer

  B. Compute Layer

  C. Database Layer

  D. Cloud Service Layer

  Correct Answer: D

  Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

• Question 683:

  True or False the longer the data retention period, the higher the resulting storage costs.

  A. True

  B. False

  Correct Answer: A

• Question 684:

  True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

  A. True

  B. False

  Correct Answer: A

• Question 685:

  Which of the following statements is true of Snowflake micro-partitioning?

  A. Micro-partitioning has been known to introduce data skew

  B. Micro-partitioning: requires a partitioning schema to be defined up front

  C. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

  D. Micro-partitioning can be disabled within a Snowflake account

  Correct Answer: C

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

• Question 686:

  True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

  A. True

  B. False

  Correct Answer: B

• Question 687:

  Which of the following statements would be used to export/unload data from Snowflake?

  A. COPY INTO @stage

  B. EXPORT TO @stage

  C. INSERT INTO @stage

  D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

• Question 688:

  True or False: An active warehouse is required to run a COPY INTO statement.

  A. True

  B. False

  Correct Answer: A

• Question 689:

  What privileges are required to execute a task?

  A. To execute a task, you need the EXECUTE TASK.

  B. A task is an account-level object and can only be executed by the Account Admin role.

  C. Tasks run automatically and do run under any rote.

  D. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

  Correct Answer: A

• Question 690:

  When can a Virtual Warehouse start running queries?

  A. 12am-5am

  B. Only during administrator defined time slots

  C. When its provisioning is complete

  D. After replication

  Correct Answer: C

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