Question 6 of 152

A user has the appropriate privilege to see unmasked data in a column.
If the user loads this column data into another column that does not have a masking policy, what will occur?
Answer

Suggested Answer

The suggested answer is A.

When a user with the appropriate privileges to see unmasked data loads data from a column with a masking policy into another column that does not have a masking policy, the unmasked data will be loaded into the new column. This is because the user's privileges allow them to access the data without the masking applied, and since the new column lacks a masking policy, it will store the data in its unmasked form.

Community Votes8 votes
ASuggested
75%
C
25%
Question 7 of 152

How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?
Answer

Suggested Answer

The suggested answer is B.

Creating multiple materialized views with different cluster keys is an effective way to optimize clustering for various access paths. Materialized views reorganize data during their creation based on the specified clustering key, thereby enhancing query performance for specific access patterns.

Community Votes3 votes
BSuggested
67%
D
33%
Question 8 of 152

Company A would like to share data in Snowflake with Company B. Company B is not on the same cloud platform as Company A.
What is required to allow data sharing between these two companies?
Answer

Suggested Answer

The suggested answer is C.

To share data between companies that are on different cloud platforms, setting up data replication to the region and cloud platform where the consumer resides is required. This ensures that the data is available in an accessible location for Company B, despite the differing cloud platforms.

Community Votes3 votes
CSuggested
67%
D
33%
Question 9 of 152

What are some of the characteristics of result set caches? (Choose three.)
Answer

Suggested Answer

The suggested answer is B, C, F.

Result set caches have several important characteristics. Snowflake persists the data results for 24 hours. Each time persisted results for a query are used, a 24-hour retention period is reset. Additionally, the result set cache is not shared between warehouses. These characteristics ensure efficient query performance and storage management while maintaining data isolation for different warehouses.

Community Votes6 votes
BCEMost voted
100%
Question 10 of 152

Which organization-related tasks can be performed by the ORGADMIN role? (Choose three.)
Answer

Suggested Answer

The suggested answer is B, C, F.

The ORGADMIN role can perform several organization-related tasks within Snowflake. Firstly, it can create an account, which falls under administrating and managing organizational structure. Secondly, it can view a list of organization accounts, providing oversight and management capabilities. Lastly, it can enable the replication of a database, which is crucial for ensuring data consistency and recovery strategies across different accounts or regions. Changing the name of an account or deleting an account either falls under account-specific roles or is subject to other limitations and conditions, making these less reliable as organization-wide admin tasks.

Community Votes21 votes
BCFSuggested
43%
BCE
29%
BCD
29%