Snowflake snowpro-core practice test

Question 1

True or False: It is possible for a user to run a query against the query result cache without requiring
an active Warehouse.

• A. True
• B. False

Answer:

A

Explanation:
Query result cache is all about fetching the data from cloud services layer and saving the cost by not
running the virtual warehouse.

Question 2

True or False: Fail-safe can be disabled within a Snowflake account.

• A. True
• B. False

Answer:

B

Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/data-failsafe.html
Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a
system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature
cannot be enabled or disabled from the user end .

Question 3

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

• A. Via the Snowflake Web Interface (Ul)
• B. Via the data_share=true parameter
• C. Via SQL commands
• D. Via Virtual Warehouses

Answer:

AC

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

Question 4

True or False: When you create a custom role, it is a best practice to immediately grant that role to
ACCOUNTADMIN.

• A. True
• B. False

Answer:

B

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

Question 5

True or False: A Virtual Warehouse can be resized while suspended.

• A. True
• B. False

Answer:

A

Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-
suspended-warehouse

Question 6

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

• A. True
• B. False

Answer:

B

Explanation:
By default, COPY INTO location statements separate table data into a set of output files to take
advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy
option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The
maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure
stages. To unload data to a single output file (at the potential cost of decreased performance), specify
the SINGLE = true copy option in your statement. You can optionally specify a name for the file in the
path.

Question 7

True or False: Reader Accounts are able to extract data from shared data objects for use outside of
Snowflake.

• A. True
• B. False

Answer:

B

Explanation:
A reader account can only consume data from the provider account that created it.

Question 8

What is the default File Format used in the COPY command if one is not specified?

• A. CSV
• B. JSON
• C. Parquet
• D. XML

Answer:

A

Explanation:
Reference:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

Question 9

The Information Schema and Account Usage Share provide storage information for which of the
following objects? (Choose three.)

• A. Users
• B. Tables
• C. Databases
• D. Internal Stages

Answer:

ABC

Question 10

How would you determine the size of the virtual warehouse used for a task?

• A. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
• B. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
• C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
• D. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Answer:

C