NEW QUESTION 1

True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

• A. True
• B. False

Answer: A

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

NEW QUESTION 2

What is the recommended compressed file size range for continuous data loads using Snowpipe?

• A. 8-16 MB
• B. 16-24 MB
• C. 10-99 MB
• D. 100-250 MB

Answer: B

NEW QUESTION 3

A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?

• A. list @file__stage
• B. show @file__stage
• C. view @file__stage
• D. verify @file__stage

Answer: A

NEW QUESTION 4

How would a user run a multi-cluster warehouse in maximized mode?

• A. Configure the maximum clusters setting to "Maximum."
• B. Turn on the additional clusters manually after starting the warehouse.
• C. Set the minimum Clusters and maximum Clusters settings to the same value.
• D. Set the minimum clusters and maximum clusters settings to different values.

Answer: D

NEW QUESTION 5

Which data type can be used to store geospatial data in Snowflake?

• A. Variant
• B. Object
• C. Geometry
• D. Geography

Answer: D

Explanation:
https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geos

NEW QUESTION 6

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

• A. The Pipe load history is reset to empty
• B. The REFRESH parameter is set to TRUE
• C. Previously loaded files will be ignored
• D. All of the above

Answer: A

Explanation:
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history "When a pipe is recreated, the load history is dropped."

NEW QUESTION 7

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?

• A. No virtual warehouse will be used, data will be read from the result cache.
• B. No virtual warehouse will be used, data will be read from the local disk cache.
• C. The default virtual warehouse will be used to read all data.
• D. The virtual warehouse that is defined at the session level will be used to read all data.

Answer: A

NEW QUESTION 8

Which of the following can be executed/called with Snowpipe?

• A. A User Defined Function (UDF)
• B. A stored procedure
• C. A single copy_into statement
• D. A single insert__into statement

Answer: C

NEW QUESTION 9

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

• A. To accommodate more queries
• B. To accommodate more users
• C. To accommodate fluctuations in workload
• D. To accommodate a more complex workload

Answer: D

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

NEW QUESTION 10

Which of the following accurately describes shares?

• A. Tables, secure views, and secure UDFs can be shared
• B. Shares can be shared
• C. Data consumers can clone a new table from a share
• D. Access to a share cannot be revoked once granted

Answer: A

NEW QUESTION 11

How often are the Account and Table master keys automatically rotated by Snowflake?

• A. 30 Days
• B. 60 Days
• C. 90 Days
• D. 365 Days.

Answer: D

NEW QUESTION 12

What is true about sharing data in Snowflake? (Choose two.)

• A. The Data Consumer pays for data storage as well as for data computing.
• B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
• C. A Snowflake account can both provide and consume shared data.
• D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
• E. The Data Consumer pays only for compute resources to query the shared data.

Answer: BC

NEW QUESTION 13

How many resource monitors can be assigned at the account level?

• A. 1
• B. 2
• C. 3
• D. 4

Answer: A

NEW QUESTION 14

Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)?
Choose 2 answers

• A. SnowSQL
• B. ODBC
• C. R
• D. HIVE

Answer: AB

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

NEW QUESTION 15

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

• A. Configure the user to be initially disabled.
• B. Force an immediate password change.
• C. Set a default role for the user.
• D. Set the number of minutes to unlock to 15 minutes.
• E. Set the user's access to expire within a specified timeframe.

Answer: AE

NEW QUESTION 16

Which formats are supported for unloading data from Snowflake? Choose 2 answers

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

Answer: AC

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

NEW QUESTION 17

Which statement describes how Snowflake supports reader accounts?

• A. A reader account can consume data from the provider account that created it and combine it with its own data.
• B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
• C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
• D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

Answer: C

NEW QUESTION 18

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 19

Which data type can store more than one type of data structure?

• A. JSON
• B. BINARY
• C. VARCHAR
• D. VARIANT

Answer: D

NEW QUESTION 20
......