Topic 2: Exam pool B
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
A.
Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
B.
All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
C.
The ACCOUNTADMIN role must be granted to only one user.
D.
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
E.
All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
In the Snowflake access control model, which entity owns an object by default?
A.
The user who created the object
B.
The SYSADMIN role
C.
Ownership depends on the type of object
D.
The role used to create the object
The role used to create the object
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
A.
Local disk caching
B.
Authentication and access control
C.
Metadata management
D.
Query processing
E.
Database storage
Metadata management
Query processing
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
A.
4
B.
8
C.
16
D.
32
8
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. Which SQL command should be used to delete the files?
A.
PURGE
B.
MODIFY
C.
REMOVE
D.
DELETE
DELETE
Reference: https://www.simplilearn.com/tutorials/sql-tutorial/delete-insql#:~:
text=The-Delete-command-in-SQL,the-records-from-a-table
Assume there is a table consisting of five micro-partitions with values ranging from A to Z. Which diagram indicates a well-clustered table?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Option A
What type of query benefits the MOST from search optimization?
A.
A query that uses only disjunction (i.e., OR) predicates
B.
A query that includes analytical expressions
C.
A query that uses equality predicates or predicates that use IN
D.
A query that filters on semi-structured data types
A query that uses equality predicates or predicates that use IN
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
A.
External Tokenization
B.
External Tables
C.
Materialized Views
D.
User-Defined Table Functions (UDTF)
External Tokenization
Users are responsible for data storage costs until what occurs?
A.
Data expires from Time Travel
B.
Data expires from Fail-safe
C.
Data is deleted from a table
D.
Data is truncated from a table
Data expires from Fail-safe
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
A.
VARIANT
B.
VARRAY
C.
STRUCT
D.
ARRAY
E.
QUEUE
VARIANT
ARRAY
| Page 17 out of 50 Pages |
| Previous |
Copyright © - All Rights Reserved