Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answersA . MIN(< < column value>>)B . COPYC . SUM(<< column value >>)D . UPDATE View Answer Answer: B,C,D...
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.A . TrueB . False View Answer Answer: A...
The PUT command: (Choose two.)
The PUT command: (Choose two.)A . Automatically creates a File Format objectB . Automatically uses the last Stage createdC . Automatically compresses files using GzipD . Automatically encrypts files View Answer Answer: C,D Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html...
When can a Virtual Warehouse start running queries?
When can a Virtual Warehouse start running queries?A . 12am-5amB . Only during administrator defined time slotsC . When its provisioning is completeD . After replication View Answer Answer: B...
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:A . Scaling rhythmicallyB . Scaling maxC . Scaling outD . Scaling Up View Answer Answer: D...
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved: Select one.
When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved: Select one.A . ConcurrencyB . Performance View Answer Answer: B...
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.A . TrueB . False View Answer Answer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html...
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.A . TrueB . False View Answer Answer: B...
Which of the following are common use cases for zero-copy cloning? Choose 3 answers
Which of the following are common use cases for zero-copy cloning? Choose 3 answersA . Quick provisioning of Dev and Test/QA environmentsB . Data backupsC . Point in time snapshotsD . Performance optimization View Answer Answer: A,B,C...
A Virtual Warehouse’s auto-suspend and auto-resume settings apply to:
A Virtual Warehouse’s auto-suspend and auto-resume settings apply to:A . The primary duster in the virtual warehouseB . The entire Virtual WarehouseC . The database the Virtual Warehouse resides inD . The queries currently being run by the Virtual Warehouse View Answer Answer: B...