- All Exams Instant Download
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?
During a database cloning, if a SNOWPIPE is cloned with a fully qualified table in the COPY statement in the pipe definition (in the form of db_name.schema_name.table_name or schema_name.table_name), then what will happen?A . Snowpipe loads duplicate data into the source table B. Data loading will fail when the snowpipe...
EXECUTE TASK privilege can be granted by whom
EXECUTE TASK privilege can be granted by whomA . ACCOUNTADMIN B. SECURITYADMIN C. ROLE WHO OWNS THE TASKView AnswerAnswer: A Explanation: -- set the active role to ACCOUNTADMIN before granting the EXECUTE TASK privilege to the new role use role accountadmin; grant execute task on account to role taskadmin; https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-a-task-administrator-role
Snowflake recommends starting slowly with SEARCH OPTIMIZATION(i.e. adding search optimization to only a few tables at first) and closely monitoring the costs and benefits.
Snowflake recommends starting slowly with SEARCH OPTIMIZATION(i.e. adding search optimization to only a few tables at first) and closely monitoring the costs and benefits.A . TRUE B. FALSEView AnswerAnswer: A
Multi-cluster warehouses are best utilized for
Multi-cluster warehouses are best utilized forA . Scaling resources to improve concurrency for users/queries B. Improving the performance of slow-running queries C. Improving the performance of data loadingView AnswerAnswer: A Explanation: Multi-cluster warehouses are best utilized for scaling resources to improve concurrency for users/queries. They are not as beneficial for...
Please select the correct hierarchy from below
Please select the correct hierarchy from below A . B. C. D.View AnswerAnswer: C Explanation: Always remember this, account is the top most container. user, role, database, warehouse objects are contained within account. Schema is within a database. All other objects table, function, views, stored procedure, file format, stage, sequence...
How will you drop a cluster key?
How will you drop a cluster key?A . ALTER TABLE <name> DROP CLUSTERING KEY B. ALTER TABLE <name> DELETE CLUSTERING KEY C. ALTER TABLE <name> REMOVE CLUSTERING KEYView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html#dropping-the-clustering-keys-for-a -table
What will happen to the query?
You have a large warehouse with auto suspend configured for 10 minutes. You submitted a query and it is going to run for more than 10 minutes. What will happen to the query?A . The query will automatically cancelled after 10 minutes B. The query will go on a hold...
Running EXPLAIN on a query does not require a running warehouse
Running EXPLAIN on a query does not require a running warehouseA . TRUE B. FALSEView AnswerAnswer: A Explanation: EXPLAIN compiles the SQL statement, but does not execute it, so EXPLAIN does not require a running warehouse. Although EXPLAIN does not consume any compute credits, the compilation of the query does...
Search optimization does not support Materialized views and External Tables
Search optimization does not support Materialized views and External TablesA . TRUE B. FALSEView AnswerAnswer: A Explanation: Current Limitations of the Search Optimization Service The search optimization service does not support the following:
Select the true statements about TASKS
Select the true statements about TASKSA . TASKS cannot be triggered manually B. TASKS can be scheduled for SQL execution C. TASKS can be used for change data capture D. TASKS can be used with STREAMSView AnswerAnswer: A,B,D
