A Review Of Approved SnowPro-Core Practice Exam

NEW QUESTION 1

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

• A. Query execution
• B. Data loading
• C. Time Travel data
• D. Security
• E. Authentication and access control

Answer: BD

NEW QUESTION 2

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
* 1. Created a user called "CONSUMER"
* 2. Created a database to hold the share and an extra-small warehouse to query the data
* 3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share
Based on this configuration what is true of the reader account?

• A. The reader account will automatically use the Standard edition of Snowflake.
• B. The reader account compute will be billed to the provider account.
• C. The reader account can clone data the provider has shared, but cannot re-share it.
• D. The reader account can create a copy of the shared data using CREATE TABLE AS...

Answer: C

NEW QUESTION 3

True or False: Snowflake charges a premium for storing semi-structured data.

• A. True
• B. False

Answer: B

Explanation:
Reference:
https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges- premium-for-storing-semi-structured-data

NEW QUESTION 4

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

• A. Business Critical Edition
• B. Standard Edition
• C. Virtual Private Snowflake (VPS)
• D. Enterprise Edition

Answer: D

NEW QUESTION 5

Which statement best describes '' clustering''?

• A. Clustering represents the way data is grouped together and stored within snowflake's micro-partitions
• B. The database administrator must define the clustering methodology for each Snowflake table.
• C. The clustering key must be included on the COPV command when loading data into Snowflake.
• D. Clustering can be disabled within a Snowflake account.

Answer: A

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

NEW QUESTION 6

Which of the following are options when creating a Virtual Warehouse?

• A. Auto-suspend
• B. Auto-resume
• C. Local SSD size
• D. User count

Answer: AB

NEW QUESTION 7

What is the minimum Snowflake edition that provides data sharing?

• A. Standard
• B. Premier
• C. Enterprise
• D. Business Critical Edition

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing

NEW QUESTION 8

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

Answer: D

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

NEW QUESTION 9

Which Snowflake tool would be BEST to troubleshoot network connectivity?

• A. SnowCLI
• B. SnowUI
• C. SnowSQL
• D. SnowCD

Answer: D

Explanation:
https://docs.snowflake.com/en/user-guide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivi

NEW QUESTION 10

True or False: It is possible to load data into Snowflake without creating a named File Format object.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

NEW QUESTION 11

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

• A. UPDATE
• B. INSERT
• C. MERGE
• D. COPY

Answer: BD

NEW QUESTION 12

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

Answer: CD

NEW QUESTION 13

Which of the following objects is not covered by Time Travel?

• A. Tables
• B. Schemas
• C. Databases
• D. Stages

Answer: D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

NEW QUESTION 14

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

• A. Compute
• B. Data storage
• C. Cloud services
• D. Cloud provider

Answer: D

NEW QUESTION 15

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

• A. True
• B. False

Answer: B

NEW QUESTION 16

When loading data into Snowflake, how should the data be organized?

• A. Into single files with 100-250 MB of compressed data per file
• B. Into single files with 1-100 MB of compressed data per file
• C. Into files of maximum size of 1 GB of compressed data per file
• D. Into files of maximum size of 4 GB of compressed data per file

Answer: A

NEW QUESTION 17

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

• A. True
• B. False

Answer: B

NEW QUESTION 18

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

• A. Pipe
• B. External stage
• C. Task
• D. Stream

Answer: A

Explanation:
Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

NEW QUESTION 19

When unloading to a stage, which of the following is a recommended practice or approach?

• A. Set SINGLE: = true for larger files
• B. Use OBJECT_CONSTRUCT ( * ) when using Parquet
• C. Avoid the use of the CAST function
• D. Define an individual file format

Answer: C

NEW QUESTION 20
......