During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?A . STATEMENT_TIMEOUT__IN__SECONDS B. STATEMENT_QUEUED_TIMEOUT_IN_SECONDS C. MAX_CONCURRENCY__LEVEL D. QUERY_TIMEOUT_IN_SECONDSView AnswerAnswer: B Explanation: The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get...

August 20, 2023 No Comments READ MORE +

Which command can be used to stage local files from which Snowflake interface?

Which command can be used to stage local files from which Snowflake interface?A . SnowSQL B. Snowflake classic web interface (Ul) C. Snowsight D. .NET driverView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/snowsql-use.html

August 20, 2023 No Comments READ MORE +

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?A . Standard B. Premium C. Enterprise D. Business CriticalView AnswerAnswer: C

August 20, 2023 No Comments READ MORE +

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-partitions B. Clustering keys C. Key partitions D. Clustered partitionsView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

August 20, 2023 No Comments READ MORE +

Which Snowflake technique can be used to improve the performance of a query?

Which Snowflake technique can be used to improve the performance of a query?A . Clustering B. Indexing C. Fragmenting D. Using INDEX__HINTSView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

August 20, 2023 No Comments READ MORE +

What does the STRIP_OUTER_ARRAY file format do?

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option. What does the STRIP_OUTER_ARRAY file format do?A . It removes the last element of the outer array. B. It removes the outer array structure and loads...

August 20, 2023 No Comments READ MORE +

Which command is used to unload data from a Snowflake table into a file in a stage?

Which command is used to unload data from a Snowflake table into a file in a stage?A . COPY INTO B. GET C. WRITE D. EXTRACT INTOView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/data-unload-snowflake.html#:~:text=Your%20User%20Stage-,Use%20the%20COPY%20INTO%20command%20to%20unload%20all%20the,more%20files%20in%20your%20stage.

August 20, 2023 No Comments READ MORE +

What would be the MOST efficient way to get the files into Snowflake?

A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?A . Create a task that runs a copy into operation from an external stage every 5 minutes B. Create...

August 20, 2023 No Comments READ MORE +

Which Snowflake partner specializes in data catalog solutions?

Which Snowflake partner specializes in data catalog solutions?A . Alation B. DataRobot C. dbt D. TableauView AnswerAnswer: A Explanation: Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise. https://docs.snowflake.com/en/user-guide/ecosystem-all.html

August 19, 2023 No Comments READ MORE +

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 role C. Assign the custom role to the PUBLIC role D. Add__CUSTOM to all custom role namesView AnswerAnswer: B Explanation: When creating roles...

August 19, 2023 No Comments READ MORE +