Snowflake COF-R02 Practice Test - Questions Answers, Page 5
Question list
List of questions
Related questions
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
A.
4
B.
16
C.
32
D.
128
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)
A.
Is available to all Snowflake Editions
B.
Is only available to customers with Business Critical Edition
C.
Restricts or enables access to specific IP addresses
D.
Is activated using an “ALTER DATABASE” command
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?
A.
The tables are now orphaned
B.
The user that deleted the role
C.
SYSADMIN
D.
The assumed role that dropped the role
The Query History in the Snowflake Web Interface (UI) is kept for approximately:
A.
60 minutes
B.
24 hours
C.
14 days
D.
30 days
E.
1 year
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
A.
Configure the Maximum Clusters setting to “Auto-Scale”
B.
Set the Warehouse type to “Auto”
C.
Set the Minimum Clusters and Maximum Clusters settings to the same value
D.
Set the Minimum Clusters and Maximum Clusters settings to the different values
Which of the following terms best describes Snowflake’s database architecture?
A.
Columnar shared nothing
B.
Shared disk
C.
Multi-cluster, shared data
D.
Cloud-native shared memory
Which of the following objects is not covered by Time Travel?
A.
Tables
B.
Schemas
C.
Databases
D.
Stages
When can a Virtual Warehouse start running queries?
A.
12am-5am
B.
Only during administrator defined time slots
C.
When its provisioning is complete
D.
After replication
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
A.
The validation_mode option is used when creating an Internal Stage
B.
validation_mode=return_all_errors is a parameter of the copy command
C.
The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
D.
The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
Question