- All Exams Instant Download
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).A . Load files that are approximately 25 MB or smaller.B . Remove all dates and timestamps.C . Load files that are approximately 100-250 MB (or larger)D . Avoid using embedded characters...
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake. Which application will the Snowflake users need to install on their devices in order to connect with MFA?A . Okta VerifyB . Duo MobileC...
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?A . PipesB . StreamsC . TasksD . ProceduresView AnswerAnswer: B Explanation: In Snowflake, Streams are the objects that track Data Manipulation Language (DML) changes made to tables, such as inserts, updates, and deletes. Streams record these...
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...
What are ways to create and manage data shares in Snowflake? (Select TWO)
What are ways to create and manage data shares in Snowflake? (Select TWO)A . Through the Snowflake web interface (Ul)B . Through the DATA_SHARE=TRUE parameterC . Through SQL commandsD . Through the enable__share=true parameterE . Using the CREATE SHARE AS SELECT * TABLE commandView AnswerAnswer: A, C Explanation: Data shares...
Will data cached in a warehouse be lost when the warehouse is resized?
Will data cached in a warehouse be lost when the warehouse is resized?A . Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.B . Yes. because the compute resource is replaced in its entirety with a new compute resource.C . No. because the...
How often are encryption keys automatically rotated by Snowflake?
How often are encryption keys automatically rotated by Snowflake?A . 30 DaysB . 60 DaysC . 90 DaysD . 365 DaysView AnswerAnswer: A Explanation: Snowflake automatically rotates encryption keys when they are more than 30 days old. Active keys are retired, and new keys are created. This process is part...
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
Which of the following compute resources or features are managed by Snowflake? (Select TWO).A . Execute a COPY commandB . Updating dataC . SnowpipeD . AUTOMATIC__CLUSTERINGE . Scaling up a warehouseView AnswerAnswer: C, E Explanation: Snowflake manages various compute resources and features, including Snowpipe and the ability to scale up...
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?A . Each Snowflake account can be hosted in a different cloud vendor and region.B . Each Snowflake account must be hosted in a different cloud vendor and regionC . All Snowflake accounts...
Which command is used to unload data from a Snowflake table into a file in a stage?
Which command is used to unload data from a Snowflake table into a file in a stage?A . COPY INTOB . GETC . WRITED . EXTRACT INTOView AnswerAnswer: A Explanation: The COPY INTO command is used in Snowflake to unload data from a table into a file in a stage....
