Snowflake SnowPro Core Certification SNOWPRO-CORE Questions & Answers

• Question 31:

  What are the three layers that make up Snowflake's architecture? Choose 3 answer

  A. Compute

  B. Tri-Secret Secure

  C. Storage

  D. Cloud Services

  Correct Answer: ACD

  Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

• Question 32:

  True or False: You can query the files in an External Stage directly without having to load the data into a table.

  A. True

  B. False

  Correct Answer: A

  Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html

  External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

• Question 33:

  Which of the following is true of Snowpipe via REST API? Choose 2 answers

  A. you can only use it on internal Stages

  B. All COPY INTO options are available fluting pipe creation

  C. Snowflake automatically manages the compute required to execute the Pipe's copy into commands

  D. Snowpipe keeps track of which files it has loaded

  Correct Answer: CD

  https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#usage-notes

• Question 34:

  True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

  A. True

  B. False

  Correct Answer: A

  Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

• Question 35:

  Which of the following are options when creating a virtual Warehouse? Choose 2 answers

  A. Auto-drop

  B. Auto resize

  C. Auto-resume

  D. Auto-suspend

  Correct Answer: CD

  https://help.pentaho.com/Documentation/9.1/Products/Create_Snowflake_warehouse https://www.analytics.today/blog/what-is-a-snowflake-virtual-warehouse

• Question 36:

  Which of the following objects can be cloned? (Choose four.)

  A. Tables

  B. Named File Formats

  C. Schemas

  D. Shares

  E. Databases

  F. Users

  Correct Answer: ABCE

  Which Objects Can Be Cloned?

  Data Containment Objects. Databases. Schemas. Tables. Streams. Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks

• Question 37:

  What is a responsibility of Snowflake's virtual warehouses?

  A. Infrastructure management

  B. Metadata management

  C. Query execution

  D. Query parsing and optimization

  E. Permanent storage of micro-partitions

  Correct Answer: C

  Reference: https://docs.snowflake.com/en/user-guide/warehouses.html#:~:text=A%20warehouse%20provides%20the%20required,rows%20from%20tables%20and%20views)

• Question 38:

  Select the different types of Internal Stages: (Choose three.)

  A. Named Stage

  B. User Stage

  C. Table Stage

  D. Schema Stage

  Correct Answer: ABC

  Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#Snowflake-Internal-Named-Stage

• Question 39:

  Which Snowflake architectural layer is responsible for a query execution plan?

  A. Compute

  B. Data storage

  C. Cloud services

  D. Cloud provider

  Correct Answer: C

• Question 40:

  What is the purpose of multi-cluster virtual warehouses?

  A. To create separate data warehouses to increase query optimization

  B. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

  C. To eliminate or reduce Queuing of concurrent queries

  D. To allow the warehouse to resize automatically

  Correct Answer: C

  https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and%20off%20hours.