- All Exams Instant Download
Who can provide permission to EXECUTE TASK?
Who can provide permission to EXECUTE TASK?A . ACCOUNTADMIN B. THE TASK OWNER C. SYSADMINView AnswerAnswer: A Explanation: If the role does not have the EXECUTE TASK privilege, assign the privilege as an account administrator (user with the ACCOUNTADMIN role), e.g.: use role accountadmin; grant execute task on account to...
Assigning ACCOUNTADMIN as the default role for the account administrators is a best practice
Assigning ACCOUNTADMIN as the default role for the account administrators is a best practiceA . TRUE B. FALSEView AnswerAnswer: B Explanation: To help prevent account administrators from inadvertently using the ACCOUNTADMIN role to create objects, assign these users additional roles and designate one of these roles as their default (i.e....
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL
What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULLA . An error is returned and no changes are applied to the column B. Snowflake automatically assigns a default value and let the change happen C. Snowflake drops the row and...
What is the most optimal solution that you will suggest to the business team?
You have a very large table which is already clustered on columns that are used to retrieve data from the table by a business group. The base table data does not change much. Another business group came to you and requested for a relatively small subset of data from the...
Which of the below objects cannot be replicated?
Which of the below objects cannot be replicated?A . Resource Monitors B. Warehouses C. Users D. Databases E. Shares F. RolesView AnswerAnswer: A,B,C,E,F Explanation: As of today(28-Nov-2020), only database replication is supported for an account. Other objects in the account cannot be replicated
What conditions should be true for a table to consider search optimization
What conditions should be true for a table to consider search optimizationA . The table size is at least 100 GB B. The table is not clustered OR The table is frequently queried on columns other than the primary cluster key C. The table can be of any sizeView AnswerAnswer:...
Who can view account-level Credit and Storage Usage?
Who can view account-level Credit and Storage Usage?A . ACCOUNTADMIN B. A role which has been granted the MONITOR USAGE global privilege C. STORAGEADMIN D. STORAGEMONITORView AnswerAnswer: A,B Explanation: If you have the necessary administrator privileges, you can use the Snowflake web interface to view details about the number of...
What does Percentage scanned from cache in the query profile signify?
What does Percentage scanned from cache in the query profile signify?A . The percentage of data scanned from the local disk cache B. The percentage of data scanned from the METADATA cache C. The percentage of data scanned from the QUERY cacheView AnswerAnswer: A Explanation: Understanding caching in snowflake is...
Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.
Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.A . After the ETL run, execute the identical queries so that they remain in the result cache B. After...
If a multi-cluster warehouse is resized, the new size applies to
If a multi-cluster warehouse is resized, the new size applies toA . Clusters that are currently running B. Clusters that are started after the warehouse is resized C. All of the aboveView AnswerAnswer: C Explanation: Multi-cluster Size and Credit Usage The number of servers in each cluster is determined by...
