NEW QUESTION 1

What are supported file formats for unloading data from Snowflake? (Choose three.)

• A. XML
• B. JSON
• C. Parquet
• D. ORC
• E. AVRO
• F. CSV

Answer: BCF

NEW QUESTION 2

True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

• A. True
• B. False

Answer: A

NEW QUESTION 3

What privilege should a user be granted to change permissions for new objects in a managed access schema?

• A. Grant the OWNERSHIP privilege on the schema.
• B. Grant the OWNERSHIP privilege on the database.
• C. Grant the MANAGE GRANTS global privilege.
• D. Grant ALL privileges on the schema.

Answer: C

NEW QUESTION 4

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

• A. In the metadata of the target table for 14 days
• B. In the metadata of the pipe for 14 days
• C. In the metadata of the target table for 64 days
• D. In the metadata of the pipe for 64 days

Answer: A

NEW QUESTION 5

True or False: Pipes can be suspended and resumed.

• A. True
• B. False

Answer: A

Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:

NEW QUESTION 6

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

• A. Standard
• B. Premium
• C. Enterprise
• D. Business Critical

Answer: D

Explanation:
https://docs.snowflake.com/en/user-guide/privatelink-azure.html

NEW QUESTION 7

True or False: You can query the files in an External Stage directly without having to load the data into a table.

• A. True
• B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html
External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

NEW QUESTION 8

Which statement describes pruning?

• A. The filtering or disregarding of micro-partitions that are not needed to return a query.
• B. The return of micro-partitions values that overlap with each other to reduce a query's runtime.
• C. A service that is handled by the Snowflake Cloud Services layer to optimize caching.
• D. The ability to allow the result of a query to be accessed as if it were a table.

Answer: A

NEW QUESTION 9

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

• A. Data can be filtered by an optional where clause
• B. Incoming data can be joined with other tables
• C. Columns can be reordered
• D. Columns can be omitted
• E. Row level access can be defined

Answer: CD

NEW QUESTION 10

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

• A. True
• B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

NEW QUESTION 11

Which of the following statements is true of Snowflake micro-partitioning?

• A. Micro-partitioning has been known to introduce data skew
• B. Micro-partitioning: requires a partitioning schema to be defined up front
• C. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
• D. Micro-partitioning can be disabled within a Snowflake account

Answer: C

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

NEW QUESTION 12

What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));

• A. To validate external table files in table t1 across all sessions
• B. To validate task SQL statements against table t1 in the last 14 days
• C. To validate a file for errors before it gets executed using a COPY command
• D. To return errors from the last executed COPY command into table t1 in the current session

Answer: D

NEW QUESTION 13

Which of the following describes the Snowflake Cloud Services layer?

• A. Coordinates activities in the Snowflake account
• B. Executes queries submitted by the Snowflake account users
• C. Manages quotas on the Snowflake account storage
• D. Manages the virtual warehouse cache to speed up queries

Answer: A

NEW QUESTION 14

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

• A. The tables are now orphaned
• B. The user that deleted the role
• C. SYSADMIN
• D. The assumed role that dropped the role

Answer: D

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html

NEW QUESTION 15

What are value types that a VARIANT column can store? (Select TWO)

• A. STRUCT
• B. OBJECT
• C. BINARY
• D. ARRAY
• E. CLOB

Answer: BD

Explanation:
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics

NEW QUESTION 16

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

• A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
• B. An error will occur, as views with qualified references cannot be cloned.
• C. An error will occur, as stored objects cannot be cloned.
• D. The stored procedures and views will refer to tables in the source database.

Answer: D

NEW QUESTION 17

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

• A. True
• B. False

Answer: A

Explanation:
Snowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.

NEW QUESTION 18

Which file formats are supported for unloading data from Snowflake? (Choose two.)

• A. Avro
• B. JSON
• C. ORC
• D. XML
• E. Delimited (CSV, TSV, etc.)

Answer: CE

Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-Th
%20comma%20(i.e.%20CSV).&text=File%20format%20options%20specify%20the,the%20format%20of%20th

NEW QUESTION 19

When cloning a database, what is cloned with the database? (Choose two.)

• A. Privileges on the database
• B. Existing child objects within the database
• C. Future child objects within the database
• D. Privileges on the schemas within the database
• E. Only schemas and tables within the database

Answer: BE

NEW QUESTION 20
......