Snowflake snowpro-core practice test

SnowPro Core Certification Exam Exam

page 1 out of 11

Viewing questions 1-15 out of 161


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.

Discussions
0 / 1000

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 .

Discussions
0 / 1000

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

Discussions
0 / 1000

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

Discussions
0 / 1000

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

Discussions
0 / 1000

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.

Discussions
0 / 1000

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.

Discussions
0 / 1000

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

Discussions
0 / 1000

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

Discussions
0 / 1000

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

Discussions
0 / 1000

Question 11

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small
Warehouse.

  • A. True
  • B. False
Answer:

A

Explanation:
You can experiment the same with snowflake UI.

Discussions
0 / 1000

Question 12

The fail-safe retention period is how many days?

  • A. 1 day
  • B. 7 days
  • C. 45 days
  • D. 90 days
Answer:

B

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

Discussions
0 / 1000

Question 13

True or False: Data Providers can share data with only the Data Consumer.

  • A. True
  • B. False
Answer:

B

Discussions
0 / 1000

Question 14

True or False: During data unloading, only JSON and CSV files can be compressed.

  • A. True
  • B. False
Answer:

B

Explanation:
Reference:
https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

Discussions
0 / 1000

Question 15

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

  • A. True
  • B. False
Answer:

B

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

Discussions
0 / 1000
To page 2