- All Exams Instant Download
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...
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...
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)A . Bytes scannedB . Bytes sent over the networkC . Number of partitions scannedD . Percentage scanned from cacheE . External bytes scannedView AnswerAnswer: A, C
