Topic 1: Exam pool A
What data is stored in the Snowflake storage layer? (Select TWO).
A.
Snowflake parameters
B.
Micro-partitions
C.
Query history
D.
Persisted query results
E.
Standard and secure view results
Micro-partitions
Persisted query results
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
A.
Users
B.
Tables
C.
Databases
D.
Internal Stages
Users
Tables
Databases
Which stage type can be altered and dropped?
A.
Database stage
B.
External stage
C.
Table stage
D.
User stage
Table stage
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-createstage.html#table-stages
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
A.
Data is hashed by the cluster key to facilitate fast searches for common data values
B.
Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
C.
Smaller micro-partitions are created for common data values to allow for more
parallelism
D.
Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
A.
The table contains a column that has very low cardinality
B.
DML statements that are being issued against the table are blocked
C.
The table has a small number of micro-partitions
D.
Queries on the table are running slower than expected
E.
The clustering depth for the table is large
The table contains a column that has very low cardinality
The clustering depth for the table is large
The fail-safe retention period is how many days?
A.
1 day
B.
7 days
C.
45 days
D.
90 days
7 days
https://docs.snowflake.com/en/user-guide/data-failsafe.html
Which of the following objects can be shared through secure data sharing?
A.
Masking policy
B.
Stored procedure
C.
Task
D.
External table
External table
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Snowflake enables the sharing of databases through shares, which are created by data providers and “imported” by data consumers.
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
A.
Compute Credits = 50 Credits Cloud Services = 10
B.
Compute Credits = 80 Credits Cloud Services = 5
C.
Compute Credits = 10 Credits Cloud Services = 9
D.
Compute Credits = 120 Credits Cloud Services = 10
E.
Compute Credits = 200 Credits Cloud Services = 26
Compute Credits = 80 Credits Cloud Services = 5
Compute Credits = 120 Credits Cloud Services = 10
What happens when a cloned table is replicated to a secondary database? (Select TWO)
A.
A read-only copy of the cloned tables is stored.
B.
The replication will not be successful.
C.
The physical data is replicated
D.
Additional costs for storage are charged to a secondary account
E.
Metadata pointers to cloned tables are replicated
The physical data is replicated
Additional costs for storage are charged to a secondary account
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.
https://docs.snowflake.com/en/user-guide/database-replicationconsiderations.
html#:~:text=Replication-and-Cloning,-Cloned-objects-are&text=However%2C-when-a-cloned-table,storage-usage-for-your-account.
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
A.
SCIM
B.
Federated authentication
C.
TLS 1.2
D.
Key-pair authentication
E.
OAuth
F.
OCSP authentication
Federated authentication
Key-pair authentication
OAuth
True or False: Fail-safe can be disabled within a Snowflake account.
A.
True
B.
True
True
https://docs.snowflake.com/en/user-guide/data-failsafe.html
Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach. Fail safe feature cannot be enabled or disabled from the user end .
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
A.
Customer-managed encryption keys through Tri-Secret Secure
B.
Automatic encryption of all data
C.
Up to 90 days of data recovery through Time Travel
D.
Object-level access control
E.
Column-level security to apply data masking policies to tables and views
Automatic encryption of all data
Object-level access control
| Page 3 out of 42 Pages |
| Previous |