- All Exams Instant Download
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: In Snowflake, a Pipe is the object designed to enable the continuous, near-real-time loading of data from files as...
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?A . Data is hashed by the cluster key to facilitate fast searches for common data valuesB . Larger micro-partitions are created for common data values to reduce the number of partitions that...
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.A . TrueB . FalseView AnswerAnswer: A Explanation: Snowflake’s architecture allows for the use of a query result cache that stores the results of queries for a period...
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...
Which command can be used to view the list of files that has been uploaded to the staged?
A user unloaded a Snowflake table called mytable to an internal stage called mystage. Which command can be used to view the list of files that has been uploaded to the staged?A . list @mytable;B . list @%raytable;C . list @ %m.ystage;D . list @mystage;View AnswerAnswer: D Explanation: The command...
Which of the following commands cannot be used within a reader account?
Which of the following commands cannot be used within a reader account?A . CREATE SHAREB . ALTER WAREHOUSEC . DROP ROLED . SHOW SCHEMASE . DESCRBE TABLEView AnswerAnswer: A Explanation: In Snowflake, a reader account is a type of account that is intended for consuming shared data rather than performing...
Which Snowflake partner specializes in data catalog solutions?
Which Snowflake partner specializes in data catalog solutions?A . AlationB . DataRobotC . dbtD . TableauView AnswerAnswer: A Explanation: Alation is known for specializing in data catalog solutions and is a partner of Snowflake. Data catalog solutions are essential for organizations to effectively manage their metadata and make it easily...
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 . StandardB . PremiumC . EnterpriseD . Business CriticalView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/admin-security-privatelink.html
What is the default character set used when loading CSV files into Snowflake?
What is the default character set used when loading CSV files into Snowflake?A . UTF-8B . UTF-16C . ISO S859-1D . ANSI_X3.AView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for% 20loading. For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the...
Which of the following are benefits of micro-partitioning? (Select TWO)
Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of valuesB . Micro-partitions are immutable objects that support the use of Time Travel.C . Micro-partitions can reduce the amount of I/O from object storage to virtual warehousesD . Rows are automatically stored...
