- All Exams Instant Download
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
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?A . An FTP server with TLS encryptionB . An HTTPS server with WebDAVC . A Google Cloud storage bucketD . A Windows server file share on AzureView AnswerAnswer: D
What is the purpose of an External Function?
What is the purpose of an External Function?A . To call code that executes outside of SnowflakeB . To run a function in another Snowflake databaseC . To share data in Snowflake with external partiesD . To ingest data from on-premises data sourcesView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/sql-reference/external-functions.html
