- All Exams Instant Download
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...
What happens when a cloned table is replicated to a secondary database? (Select TWO)
What happens when a cloned table is replicated to a secondary database? (Select TWO)A . A read-only copy of the cloned tables is stored.B . The replication will not be successful.C . The physical data is replicatedD . Additional costs for storage are charged to a secondary accountE . Metadata...
What data is stored in the Snowflake storage layer? (Select TWO).
What data is stored in the Snowflake storage layer? (Select TWO).A . Snowflake parametersB . Micro-partitionsC . Query historyD . Persisted query resultsE . Standard and secure view resultsView AnswerAnswer: B, D Explanation: The Snowflake storage layer is responsible for storing data in an optimized, compressed, columnar format. This includes...
Which command can be used to load data into an internal stage?
Which command can be used to load data into an internal stage?A . LOADB . copyC . GETD . PUTView AnswerAnswer: D Explanation: The PUT command is used to load data into an internal stage in Snowflake. This command uploads data files from a local file system to a named...
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).A . Materialized viewsB . SequencesC . ProceduresD . TablesE . Secure User Defined Functions (UDFs)View AnswerAnswer: D, E Explanation: Secure sharing in Snowflake allows users to share specific objects with other Snowflake accounts without physically...
How would you determine the size of the virtual warehouse used for a task?
How would you determine the size of the virtual warehouse used for a task?A . Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of executionB . Querying (select) the size of the stream content...
What features does Snowflake Time Travel enable?
What features does Snowflake Time Travel enable?A . Querying data-related objects that were created within the past 365 daysB . Restoring data-related objects that have been deleted within the past 90 daysC . Conducting point-in-time analysis for Bl reportingD . Analyzing data usage/manipulation over all periods of timeView AnswerAnswer: B,...
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...
When is the result set cache no longer available? (Select TWO)
When is the result set cache no longer available? (Select TWO)A . When another warehouse is used to execute the queryB . When another user executes the queryC . When the underlying data has changedD . When the warehouse used to execute the query is suspendedE . When it has...
What is the recommended file sizing for data loading using Snowpipe?
What is the recommended file sizing for data loading using Snowpipe?A . A compressed file size greater than 100 MB, and up to 250 MBB . A compressed file size greater than 100 GB, and up to 250 GBC . A compressed file size greater than 10 MB, and up...
