- All Exams Instant Download
What happens when an external or an internal stage is dropped? (Select TWO).
What happens when an external or an internal stage is dropped? (Select TWO).A . When dropping an external stage, the files are not removed and only the stage is droppedB . When dropping an external stage, both the stage and the files within the stage are removedC . When dropping...
In which use cases does Snowflake apply egress charges?
In which use cases does Snowflake apply egress charges?A . Data sharing within a specific regionB . Query result retrievalC . Database replicationD . Loading data into SnowflakeView AnswerAnswer: C Explanation: Snowflake applies egress charges in the case of database replication when data is transferred out of a Snowflake region...
Which statements will provide this access?
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access? A. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE; B. GRANT ROLE MYROLE TO USER USER1; CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;...
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,...
