- All Exams Instant Download
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....
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.A . TrueB . FalseView AnswerAnswer: B Explanation: Reader accounts in Snowflake are designed to allow users to read data shared with them but do not have the capability to extract data...
What are value types that a VARIANT column can store? (Select TWO)
What are value types that a VARIANT column can store? (Select TWO)A . STRUCTB . OBJECTC . BINARYD . ARRAYE . CLOBView AnswerAnswer: B, D Explanation: A VARIANT column in Snowflake can store semi-structured data types. This includes: B. OBJECT: An object is a collection of key-value pairs in JSON,...
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 Snowflake role must be granted for a user to create and manage accounts?
What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMINB . ORGADMINC . SECURITYADMIND . SYSADMINView AnswerAnswer: A Explanation: The ACCOUNTADMIN role is required for a user to create and manage accounts in Snowflake. This role has the highest level of privileges and is...
