NEW QUESTION 1

What Snowflake role must be granted for a user to create and manage accounts?

• A. ACCOUNTADMIN
• B. ORGADMIN
• C. SECURITYADMIN
• D. SYSADMIN

Answer: A

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

NEW QUESTION 2

What is the minimum Snowflake edition required to use Dynamic Data Masking?

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

Answer: D

NEW QUESTION 3

True or False: An active warehouse is required to run a COPY INTO statement.

• A. True
• B. False

Answer: A

NEW QUESTION 4

What can be used to view warehouse usage over time? (Select Two).

• A. The load HISTORY view
• B. The Query history view
• C. The show warehouses command
• D. The WAREHOUSE_METERING HISTORY View
• E. The billing and usage tab in the Snowflake web Ul

Answer: DE

NEW QUESTION 5

Which of the following items does the Cloud services Layer manage? Choose 4 answers

• A. user authentication
• B. Metadata
• C. Query compilation and optimization
• D. external blob storage
• E. Data security

Answer: ABCE

NEW QUESTION 6

What are common issues found by using the Query Profile? (Choose two.)

• A. Identifying queries that will likely run very slowly before executing them
• B. Locating queries that consume a high amount of credits
• C. Identifying logical issues with the queries
• D. Identifying inefficient micro-partition pruning
• E. Data spilling to a local or remote disk

Answer: AD

NEW QUESTION 7

What tasks can be completed using the copy command? (Select TWO)

• A. Columns can be aggregated
• B. Columns can be joined with an existing table
• C. Columns can be reordered
• D. Columns can be omitted
• E. Data can be loaded without the need to spin up a virtual warehouse

Answer: CD

NEW QUESTION 8

Which of the following statement is true of Snowflake? Select one.

• A. It was built specifically for the cloud
• B. it was built as an on-premises solution and then potted to the cloud
• C. It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
• D. It was built for Hadoop architecture
• E. It's based on an Oracle Architecture

Answer: A

NEW QUESTION 9

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

• A. An FTP server with TLS encryption
• B. An HTTPS server with WebDAV
• C. A Google Cloud storage bucket
• D. A Windows server file share on Azure

Answer: C

NEW QUESTION 10

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

• A. The explain plan output is available graphically.
• B. An explain plan can be used to conduct performance analysis without executing a query.
• C. An explain plan will handle queries with temporary tables and the query profiler will not.
• D. An explain plan's output will display automatic data skew optimization information.

Answer: B

NEW QUESTION 11

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

• A. VARIANT
• B. VARRAY
• C. STRUCT
• D. ARRAY
• E. QUEUE

Answer: AD

NEW QUESTION 12

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 13

Which statement about billing applies to Snowflake credits?

• A. Credits are billed per-minute with a 60-minute minimum
• B. Credits are used to pay for cloud data storage usage
• C. Credits are consumed based on the number of credits billed for each hour that a warehouse runs
• D. Credits are consumed based on the warehouse size and the time the warehouse is running

Answer: D

Explanation:
Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used.
https://docs.snowflake.com/en/user-guide/what-are-credits.html

NEW QUESTION 14

Which command is used to unload data from a Snowflake table into a file in a stage?

• A. COPY INTO
• B. GET
• C. WRITE
• D. EXTRACT INTO

Answer: A

Explanation:
https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%2

NEW QUESTION 15

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

• A. A multi-cluster Warehouse can add clusters automatically based on query activity
• B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
• C. A multi-cluster Warehouse can scale down when query activity slows
• D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

Answer: ABCD

NEW QUESTION 16

What is the recommended file sizing for data loading using Snowpipe?

• A. A compressed file size greater than 100 MB, and up to 250 MB
• B. A compressed file size greater than 100 GB, and up to 250 GB
• C. A compressed file size greater than 10 MB, and up to 100 MB
• D. A compressed file size greater than 1 GB, and up to 2 GB

Answer: A

Explanation:
https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20use

NEW QUESTION 17

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

• A. A directory table is a separate database object.
• B. Directory tables store data file metadata.
• C. A directory table will be automatically added to a stage.
• D. Directory tables do not have their own grantable privileges.
• E. Directory table data can not be refreshed manually.

Answer: BD

NEW QUESTION 18

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

• A. The table contains a column that has very low cardinality
• B. DML statements that are being issued against the table are blocked
• C. The table has a small number of micro-partitions
• D. Queries on the table are running slower than expected
• E. The clustering depth for the table is large

Answer: AE

NEW QUESTION 19

What happens when an external or an internal stage is dropped? (Select TWO).

• A. When dropping an external stage, the files are not removed and only the stage is dropped
• B. When dropping an external stage, both the stage and the files within the stage are removed
• C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
• D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
• E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Answer: AC

NEW QUESTION 20
......