- All Exams Instant Download
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 INTOB . GETC . WRITED . 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.
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?A . A single join node uses more than 50% of the query timeB . Partitions scanned is equal to partitions totalC . An Aggregate Operacor node is presentD . The...
What is the minimum Snowflake edition required to create a materialized view?
What is the minimum Snowflake edition required to create a materialized view?A . Standard EditionB . Enterprise EditionC . Business Critical EditionD . Virtual Private Snowflake EditionView AnswerAnswer: B Explanation: Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support.
What tasks can be completed using the copy command? (Select TWO)
What tasks can be completed using the copy command? (Select TWO)A . Columns can be aggregatedB . Columns can be joined with an existing tableC . Columns can be reorderedD . Columns can be omittedE . Data can be loaded without the need to spin up a virtual warehouseView AnswerAnswer:...
What is the MOST performant file format for loading data in Snowflake?
What is the MOST performant file format for loading data in Snowflake?A . CSV (Unzipped)B . ParquetC . CSV (Gzipped)D . ORCView AnswerAnswer: B
What is a limitation of a Materialized View?
What is a limitation of a Materialized View?A . A Materialized View cannot support any aggregate functionsB . A Materialized View can only reference up to two tablesC . A Materialized View cannot be joined with other tablesD . A Materialized View cannot be defined with a JOINView AnswerAnswer: D...
According to recommended best practice, what should be done to reduce the Queue volume?
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse. According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).A . Use multi-clustered warehousing to scale out...
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).A . Internal stagesB . Incremental backupsC . Time TravelD . Zero-copy clonesE . Fail-safeView AnswerAnswer: CE Explanation: Time travel and fail safe are the two continuous data protection features support the recovery of data automatically. Snowflake provides...
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?A . PipeB . External stageC . TaskD . StreamView AnswerAnswer: A Explanation: Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load...
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)A . UsersB . TablesC . DatabasesD . Internal StagesView AnswerAnswer: BCD
