- (Topic 4)
Which views are included in the DATA SHARING USAGE schema? (Select TWO).

1. A. ACCESS_HISTORY
2. B. DATA_TRANSFER_HISTORY
3. C. WAREHOUSE_METERING_HISTORY
4. D. MONETIZED_USAGE_DAILY
5. E. LISTING TELEMETRY DAILY

Correct Answer: DE
The DATA_SHARING_USAGE schema includes views that display information about listings published in the Snowflake Marketplace or a data exchange, which includes DATA_TRANSFER_HISTORY and LISTING_TELEMETRY_DAILY2.

- (Topic 3)
How can a data provider ensure that a data consumer is going to have access to the required objects?

1. A. Enable the data sharing feature in the account and validate the view.
2. B. Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
3. C. Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.
4. D. Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

Correct Answer: A
To ensure a data consumer has access to the required objects, a data provider can enable the data sharing feature and validate that the consumer can access the views or tables shared with them. References: Based on general data sharing practices in cloud services as of 2021.

- (Topic 3)
Which statement describes how Snowflake supports reader accounts?

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

Correct Answer: B
Snowflake supports reader accounts, which are a type of account that allows data providers to share data with consumers who are not Snowflake customers. However, for data sharing to occur, the consumer needs to become a licensed Snowflake customer because data sharing is only supported between Snowflake accounts. References: Introduction to Secure Data Sharing | Snowflake Documentation2.

- (Topic 5)
Which function is used to convert rows in a relational table to a single VARIANT column?

1. A. ARRAY_AGG
2. B. OBJECT_AGG
3. C. ARRAY_CONSTRUCT
4. D. OBJECT_CONSTRUCT

Correct Answer: D
TheOBJECT_CONSTRUCTfunction in Snowflake is used to convert rows in a relational table into a single VARIANT column that represents each row as a JSON object. This function dynamically creates a JSON object from a list of key-value pairs, where each key is a column name and each value is the corresponding column value for a row. This is particularly useful for aggregating and transforming structured data into semi- structured JSON format for further processing or analysis.
References:
✑ Snowflake Documentation: Semi-structured Data Functions

- (Topic 3)
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

1. A. CREATE_SHARE on the account
2. B. SHARE on databases and schemas
3. C. SELECT on tables used by the secure view
4. D. REFERENCE_USAGE on databases

Correct Answer: D
To allow secure views the ability to reference data in multiple databases, the REFERENCE_USAGE privilege must be granted on each database that contains objects referenced by the secure view2. This privilege is necessary before granting the SELECT privilege on a secure view to a share.