Topic 2: Exam pool B
Which Snowflake layer is always leveraged when accessing a query from the result cache?
A.
Metadata
B.
Data Storage
C.
Compute
D.
Cloud Services
Cloud Services
What is the maximum Time Travel retention period for a temporary Snowflake table?
A.
90 days
B.
1 day
C.
7 days
D.
45 days
1 day
When should a multi-cluster warehouse be used in auto-scaling mode?
A.
When it is unknown how much compute power is needed
B.
If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
C.
If the runtime of the executed query is very slow
D.
When a large number of concurrent queries are run on the same warehouse
When a large number of concurrent queries are run on the same warehouse
What COPY INTO SQL command should be used to unload data into multiple files?
A.
SINGLE=TRUE
B.
MULTIPLE=TRUE
C.
MULTIPLE=FALSE
D.
SINGLE=FALSE
MULTIPLE=FALSE
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates. How can this worksheet be shared?
A.
Create a zero-copy clone of the worksheet and grant permissions to teammates
B.
Create a private Data Exchange so that any teammate can use the worksheet
C.
Share the worksheet with teammates within Snowsight
D.
Create a database and grant all permissions to teammates
Share the worksheet with teammates within Snowsight
Which minimum Snowflake edition allows for a dedicated metadata store?
A.
Standard
B.
Enterprise
C.
Business Critical
D.
Virtual Private Snowflake
Virtual Private Snowflake
Which file formats are supported for unloading data from Snowflake? (Choose two.)
A.
Avro
B.
JSON
C.
ORC
D.
XML
E.
Delimited (CSV, TSV, etc.)
ORC
Delimited (CSV, TSV, etc.)
Reference: https://docs.snowflake.com/en/user-guide/data-unloadprepare.
html#:~:text=Supported-File-Formats,-
The-following-file&text=Delimited-(CSV%2C-TSV%2C-etc,is-comma-(i.e.-CSV).&text=File-format-options-specify-the,the-format-of-the-data
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers. How can this requirement be met?
A.
Use data encryption.
B.
Use dynamic data masking.
C.
Use secure materialized views.
D.
Revoke all roles for functional managers and end users.
Use dynamic data masking.
Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)
A.
Management of metadata
B.
Computing the data
C.
Maintaining Availability Zones
D.
Infrastructure security
E.
Parsing and optimizing queries
Management of metadata
Parsing and optimizing queries
What are supported file formats for unloading data from Snowflake? (Choose three.)
A.
XML
B.
JSON
C.
Parquet
D.
ORC
E.
AVRO
F.
CSV
JSON
Parquet
CSV
| Page 18 out of 50 Pages |
| Previous |
Copyright © - All Rights Reserved