- All Exams Instant Download
Which of the following are benefits of micro-partitioning? (Select TWO)
Which of the following are benefits of micro-partitioning? (Select TWO)A . Micro-partitions cannot overlap in their range of valuesB . Micro-partitions are immutable objects that support the use of Time Travel.C . Micro-partitions can reduce the amount of I/O from object storage to virtual warehousesD . Rows are automatically stored...
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...
What SQL command would be used to view all roles that were granted to user.1?
What SQL command would be used to view all roles that were granted to user.1?A . show grants to user USER1;B . show grants of user USER1;C . describe user USER1;D . show grants on user USER1;View AnswerAnswer: A
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)A . The ability to scale up warehousesB . The use of warehouse auto scalingC . The ability to resize warehousesD . Use of multi-clustered warehousesE . The use of warehouse indexingView AnswerAnswer: A, D
What would be the MOST efficient way to get the files into Snowflake?
A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?A . Create a task that runs a copy into operation from an external stage every 5 minutesB . Create...
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: Characteristics of a VARIANT A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT...
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: Query result cache is all about fetching the data from cloud services layer and saving the cost by not running...
What happens when a virtual warehouse is resized?
What happens when a virtual warehouse is resized?A . When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affectedB . When reducing the size of a warehouse the compute resources are removed only when they are no longer...
What is a responsibility of Snowflake's virtual warehouses?
What is a responsibility of Snowflake's virtual warehouses?A . Infrastructure managementB . Metadata managementC . Query executionD . Query parsing and optimizationE . Management of the storage layerView AnswerAnswer: C
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)A . Customer-managed encryption keys through Tri-Secret SecureB . Automatic encryption of all dataC . Up to 90 days of data recovery through Time TravelD . Object-level access controlE . Column-level security to apply data masking policies...
