Topic 2: Exam pool B
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
A.
PUT
B.
GET
C.
COPY
D.
SELECT
GET
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
A.
Reader
B.
Consumer
C.
Vendor
D.
Standard
E.
Personalized
Standard
Personalized
Which command can be used to load data files into a Snowflake stage?
A.
JOIN
B.
COPY INTO
C.
PUT
D.
GET
PUT
How long is the Fail-safe period for temporary and transient tables?
A.
There is no Fail-safe period for these tables.
B.
1 day
C.
7 days
D.
31 days
E.
90 days
There is no Fail-safe period for these tables.
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
| Page 14 out of 42 Pages |
| Previous |