True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

A. True

B. False

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

A. Number of users

B. Warehouse size

C. Amount of data processed

D. # of clusters for the Warehouse

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

A. SCIM

B. Federated authentication

C. TLS 1.2

D. Key-pair authentication

E. OAuth

F. OCSP authentication

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

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

A. Customer-managed encryption keys through Tri-Secret Secure

B. Automatic encryption of all data

C. Up to 90 days of data recovery through Time Travel

D. Object-level access control

E. Column-level security to apply data masking policies to tables and views

How long is Snowpipe data load history retained?

A. As configured in the create pipe settings

B. Until the pipe is dropped

C. 64 days

D. 14 days

Which stage type can be altered and dropped?

A. Database stage

B. External stage

C. Table stage

D. User stage

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A. Whether or not it is also a secure view

B. How often the underlying base table is queried

C. How often the base table changes

D. Whether the materialized view has a cluster key defined

E. How often the materialized view is queried

What happens to historical data when the retention period for an object ends?

A. The data is cloned into a historical object.

B. The data moves to Fail-safe

C. Time Travel on the historical data is dropped.

D. The object containing the historical data is dropped.

What is a responsibility of Snowflake's virtual warehouses?

A. Infrastructure management

B. Metadata management

C. Query execution

D. Query parsing and optimization

E. Permanent storage of micro-partitions

How long is the Fail-safe period for temporary and transient tables?

A. There is no Fail-safe period for these tables.

B. 1 day

C. 7 days

D. 31 days

E. 90 days

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1.

Created a user called "CONSUMER"

2.

Created a database to hold the share and an extra-small warehouse to query the data

3.

Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

A. The reader account will automatically use the Standard edition of Snowflake.

B. The reader account compute will be billed to the provider account.

C. The reader account can clone data the provider has shared, but cannot re-share it.

D. The reader account can create a copy of the shared data using CREATE TABLE AS...

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

A. Removing a column from the query SELECT list

B. Stopping the virtual warehouse that the query is running against

C. Clustering of the data used by the query

D. Executing the RESULTS_SCAN() table function

E. Changing a column that is not in the cached query

What affects whether the query results cache can be used?

A. If the query contains a deterministic function

B. If the virtual warehouse has been suspended

C. If the referenced data in the table has changed

D. If multiple users are using the same virtual warehouse

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.