Topic 1: Exam pool A
What are the default Time Travel and Fail-safe retention periods for transient tables?
A.
Time Travel - 1 day. Fail-safe - 1 day
B.
Time Travel - 0 days. Fail-safe - 1 day
C.
Time Travel - 1 day. Fail-safe - 0 days
D.
Transient tables are retained in neither Fail-safe nor Time Travel
Time Travel - 1 day. Fail-safe - 0 days
https://docs.snowflake.com/en/user-guide/data-cdp-storagecosts.html#:~:text=Temporary-and-Transient-Tables,-To-help-manage&text=Temporary-tables-can-also-have,have-no-Fail%2Dsafe-period.
Which of the following are benefits of micro-partitioning? (Select TWO)
A.
Micro-partitions cannot overlap in their range of values
B.
Micro-partitions are immutable objects that support the use of Time Travel.
C.
Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
D.
Rows are automatically stored in sorted order within micro-partitions
E.
Micro-partitions can be defined on a schema-by-schema basis
Micro-partitions cannot overlap in their range of values
Rows are automatically stored in sorted order within micro-partitions
https://docs.snowflake.com/en/user-guide/tables-clusteringmicropartitions.
html
Which Snowflake technique can be used to improve the performance of a query?
A.
Clustering
B.
Indexing
C.
Fragmenting
D.
Using INDEX__HINTS
Clustering
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
A.
Via the Snowflake Web Interface (Ul)
B.
Via the data_share=true parameter
C.
Via SQL commands
D.
Via Virtual Warehouses
Via the Snowflake Web Interface (Ul)
Via SQL commands
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
What is a key feature of Snowflake architecture?
A.
Zero-copy cloning creates a mirror copy of a database that updates with the original
B.
Software updates are automatically applied on a quarterly basis
C.
Snowflake eliminates resource contention with its virtual warehouse implementation
D.
Multi-cluster warehouses allow users to run a query that spans across multiple clusters
E.
Snowflake automatically sorts DATE columns during ingest for fast retrieval by date
Multi-cluster warehouses allow users to run a query that spans across multiple clusters
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
A.
Standard
B.
Premium
C.
Enterprise
D.
Business Critical
Business Critical
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
A.
Each Snowflake account can be hosted in a different cloud vendor and region.
B.
Each Snowflake account must be hosted in a different cloud vendor and region
C.
All Snowflake accounts must be hosted in the same cloud vendor and region
D.
Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
Each Snowflake account must be hosted in a different cloud vendor and region
What is the default character set used when loading CSV files into Snowflake?
A.
UTF-8
B.
UTF-16
C.
ISO S859-1
D.
ANSI_X3.A
UTF-8
https://docs.snowflake.com/en/user-guide/intro-summaryloading.html#:~:text=For-delimited-files-(CSV%2C-TSV,encoding-to-use-for-loading.
For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).
When unloading to a stage, which of the following is a recommended practice or approach?
A.
Set SINGLE: = true for larger files
B.
Use OBJECT_CONSTRUCT ( * ) when using Parquet
C.
Avoid the use of the CAST function
D.
Define an individual file format
Avoid the use of the CAST function
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
A.
The ability to scale up warehouses
B.
The use of warehouse auto scaling
C.
The ability to resize warehouses
D.
Use of multi-clustered warehouses
E.
The use of warehouse indexing
The use of warehouse auto scaling
Use of multi-clustered warehouses
Page 6 out of 50 Pages |
Previous |