- All Exams Instant Download
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)A . ROLESB . POLICY_REFERENCESC . QUERY_HISTORYD . RESOURCE_MONIT ORSE . ACCESS_HISTORYView AnswerAnswer: B, E Explanation: To evaluate the details of dynamic data masking, the POLICY_REFERENCES and ACCESS_HISTORY views in the account_usage schema are used. The...
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.A . TrueB . FalseView AnswerAnswer: B Explanation: The ACCOUNTADMIN role is the most powerful role in Snowflake and should be limited to a select number of users within an...
What is a best practice after creating a custom role?
What is a best practice after creating a custom role?A . Create the custom role using the SYSADMIN role.B . Assign the custom role to the SYSADMIN roleC . Assign the custom role to the PUBLIC roleD . Add__CUSTOM to all custom role namesView AnswerAnswer: B Explanation: Assigning the custom...
When unloading to a stage, which of the following is a recommended practice or approach?
When unloading to a stage, which of the following is a recommended practice or approach?A . Set SINGLE: = true for larger filesB . Use OBJECT_CONSTRUCT ( * ) when using ParquetC . Avoid the use of the CAST functionD . Define an individual file formatView AnswerAnswer: D Explanation: When...
Which of the following are benefits of micro-partitioning? (Select TWO)
Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of valuesB . Micro-partitions are immutable objects that support the use of Time Travel.C . Micro-partitions can reduce the amount of I/O from object storage to virtual warehousesD . Rows are automatically stored...
What feature can be used to reorganize a very large table on one or more columns?
What feature can be used to reorganize a very large table on one or more columns?A . Micro-partitionsB . Clustering keysC . Key partitionsD . Clustered partitionsView AnswerAnswer: B Explanation: Clustering keys in Snowflake are used to reorganize large tables based on one or more columns. This feature optimizes the...
Which of the following describes how clustering keys work in Snowflake?
Which of the following describes how clustering keys work in Snowflake?A . Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.B . Clustering keys sort the designated columns over time, without blocking DML operationsC . Clustering keys create a distributed, parallel data structure...
Which Snowflake feature is used for both querying and restoring data?
Which Snowflake feature is used for both querying and restoring data?A . Cluster keysB . Time TravelC . Fail-safeD . CloningView AnswerAnswer: B Explanation: Snowflake’s Time Travel feature is used for both querying historical data in tables and restoring and cloning historical data in databases, schemas, and tables3. It allows...
What SQL command would be used to view all roles that were granted to user.1?
What SQL command would be used to view all roles that were granted to user.1?A . show grants to user USER1;B . show grants of user USER1;C . describe user USER1;D . show grants on user USER1;View AnswerAnswer: A Explanation: The correct command to view all roles granted to a...
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.A . TrueB . FalseView AnswerAnswer: A Explanation: Snowflake’s architecture allows for the use of a query result cache that stores the results of queries for a period...
