- All Exams Instant Download
When does a multi-cluster warehouse shuts down with default scaling policy
When does a multi-cluster warehouse shuts down with default scaling policyA . Immediately after the query is run B. After 2 to 3 consecutive successful checks (performed at 1 minute intervals), which determine whether the load on the least-loaded cluster could be redistributed to the other clusters without spinning up...
Which of the below privileges are required for search optimization?
Which of the below privileges are required for search optimization?A . OWNERSHIP privilege on the table B. ADD SEARCH OPTIMIZATION privilege on the schema that contains the table C. ADD SEARCH OPTIMIZATION privilege on the table.View AnswerAnswer: A,B Explanation: What Access Control Privileges Are Needed For the Search Optimization Service?
Data loading transformation as part of copying data to a table from stage supports selecting data from user stage and named stages(internal and external) only
Data loading transformation as part of copying data to a table from stage supports selecting data from user stage and named stages(internal and external) onlyA . TRUE B. FALSEView AnswerAnswer: A Explanation: The SELECT statement used for transformations does not support all functions. For a complete list of the supported...
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:
Privileges granted on database objects are not replicated to a secondary database.
Privileges granted on database objects are not replicated to a secondary database.A . TRUE B. FALSEView AnswerAnswer: A Explanation: Access Control Privileges granted on database objects are not replicated to a secondary database. https://docs.snowflake.com/en/user-guide/database-replication-intro.html#access-control
Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.
Files stored in snowflake internal stage are automatically encrypted using either AES 128 or 256 strong encryption.A . TRUE B. FALSEView AnswerAnswer: A Explanation: All files stored in internal stages (for data loading/unloading) automatically encrypted (using either AES 128 standard or 256 strong encryption). https://docs.snowflake.com/en/user-guide/admin-security.html Please note if using external...
Removing files from a stage after you are done loading the files improves performance when subsequently loading data
Removing files from a stage after you are done loading the files improves performance when subsequently loading dataA . TRUE B. FALSEView AnswerAnswer: A Explanation: Managing Unloaded Data Files Staged files can be deleted from a Snowflake stage using the REMOVE command to remove the files in the stage after...
How will you list all the object references of the view?
You have a view. How will you list all the object references of the view?A . GET_OBJECT_REFERENCES B. GET_VIEW_REFERENCES C. GET_VIEW_METADATAView AnswerAnswer: A Explanation: GET_OBJECT_REFERENCES Returns a list of objects that a specified object references. Input is currently limited to the name of a view. https://docs.snowflake.com/en/sql-reference/functions/get_object_references.html#get-object-references ------------------------------------------------------------------------------------------------------------- Please do the...
The query profile looks as below. If you would like to further tune the query, what is the best thing to do?
You ran a query and the query SELECT * FROM inventory WHERE BIBNUMBER = 2805127; The query profile looks as below. If you would like to further tune the query, what is the best thing to do? A . Execute the below query to enable auto clustering B. alter table...
If you run the below commands in your worksheet, what will happen?
If you run the below commands in your worksheet, what will happen? CREATE TEMP TABLE STUDENT_TABLE(STUID NUMBER, COURSE VARCHAR); CREATE TABLE STUDENT_TABLE_CLONE CLONE STUDENT_TABLE;A . A temporary table will be created with name as STUDENT_TABLE. The clone will create a clone of the STUDENT_TABLE B. Only the STUDENT_TABLE_CLONE will be...
