Snowflake Snowflake Certifications SNOWPRO-CORE Questions & Answers

• Question 631:

  Which interfaces can be used to create and/or manage Virtual Warehouses?

  A. The Snowflake Web Interface (UI)

  B. SQL commands

  C. Data integration tools

  D. All of the above

  Correct Answer: D

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

• Question 632:

  Which of the following statements are true about Schemas in Snowflake? (Choose two.)

  A. A Schema may contain one or more Databases

  B. A Database may contain one or more Schemas

  C. A Schema is a logical grouping of Database Objects

  D. Each Schema is contained within a Warehouse

  Correct Answer: BC

  Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

• Question 633:

  As a best practice, clustering keys should only be defined on tables of which minimum size?

  A. Multi-Kilobyte (KB) Range

  B. Multi-Megabyte (MB) Range

  C. Multi-Gigabyte (GB) Range

  D. Multi-Terabyte (TB) Range

  Correct Answer: D

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

• Question 634:

  Which type of table corresponds to a single Snowflake session?

  A. Temporary

  B. Translent

  C. Provisional

  D. Permanent

  Correct Answer: A

  Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.

  https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session.

• Question 635:

  What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement? Select one.

  A. INITTIALLY_SUSPENDED = TRUE/FALSE

  B. START_AFTCR_CREATE = TRUE/FALSE

  C. START_TTIME = 60 // (seconds from now)

  D. START.TIME = CURRENT.DATE()

  Correct Answer: A

• Question 636:

  Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

  Select one.

  A. More micro-partitions

  B. Better query scheduling

  C. Double the numbers of servers In the compute duster

  D. Higher storage costs

  Correct Answer: C

• Question 637:

  Which of the following commands are not blocking operations? Choose 2 answers

  A. UPDATE

  B. INSERT

  C. MERGE

  D. COPY

  Correct Answer: BD

• Question 638:

  True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

  A. True

  B. False

  Correct Answer: B

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

• Question 639:

  Which are true of Snowflake roles?

  A. All grants to objects are given to roles, and never to users

  B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation

  C. The public role controls at other roles

  D. Roles are a subset of users and users own objects In Snowflake

  Correct Answer: AB

• Question 640:

  Which item in the Data Warehouse migration process does not apply in Snowflake? (Select two)

  A. Migrate Users

  B. Migrate Schemas

  C. Migrate Indexes

  D. Build the Data pipeline

  Correct Answer: CD