- 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...
Will the developer be able to modify the table to read the masked data?
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?A . Yes, because a table owner has full control and can unset...
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...
