Package deal
Snowflake SnowPro Certification Tests Bundle Set
Snowflake SnowPro Certification Tests Bundle Set
[Show more]Snowflake SnowPro Certification Tests Bundle Set
[Show more]True or False: Data Storage is independent from compute? - Answer True 
 
True or False: All virtual warehouses have access to all data? - Answer True 
 
True or False: Al interactions with data are initialized through the services layer? - Answer True 
 
True or False: Multi-Cluster Warehouse...
Preview 4 out of 44 pages
Add to cartTrue or False: Data Storage is independent from compute? - Answer True 
 
True or False: All virtual warehouses have access to all data? - Answer True 
 
True or False: Al interactions with data are initialized through the services layer? - Answer True 
 
True or False: Multi-Cluster Warehouse...
When unloading (or extracting) data using a Query, you can extract data from - Answer Multiple tables joined together 
 
a view 
 
a single table 
 
What are some of the ways to improve performance of an external table? - Answer Partition the external table (if the logical folder structure permi...
Preview 3 out of 25 pages
Add to cartWhen unloading (or extracting) data using a Query, you can extract data from - Answer Multiple tables joined together 
 
a view 
 
a single table 
 
What are some of the ways to improve performance of an external table? - Answer Partition the external table (if the logical folder structure permi...
Which of the following are true of Multi-cluster warehouses? Select all that apply. 
1) Adds clusters automatically based on query activity 
2) Sizes each cluster optimally based on the queries 
3) Scales down when query activity slows 
4) Multi-cluster warehouses will never auto-suspend - Answer ...
Preview 4 out of 33 pages
Add to cartWhich of the following are true of Multi-cluster warehouses? Select all that apply. 
1) Adds clusters automatically based on query activity 
2) Sizes each cluster optimally based on the queries 
3) Scales down when query activity slows 
4) Multi-cluster warehouses will never auto-suspend - Answer ...
True or False: Data Storage is independent from compute? - Answer True 
 
True or False: All virtual warehouses have access to all data? - Answer True 
 
True or False: Al interactions with data are initialized through the services layer? - Answer True 
 
True or False: Multi-Cluster Warehouse...
Preview 4 out of 44 pages
Add to cartTrue or False: Data Storage is independent from compute? - Answer True 
 
True or False: All virtual warehouses have access to all data? - Answer True 
 
True or False: Al interactions with data are initialized through the services layer? - Answer True 
 
True or False: Multi-Cluster Warehouse...
How are VARIANT columns stored? 
As a separate physical columns 
 
 
Are common and/or frequent fields/paths in VARIANT columns stored as separate physical columns? 
Yes 
 
 
For data that is mostly regular and uses only native JSON types (strings and numbers, not timestamps), are both storage and q...
Preview 3 out of 21 pages
Add to cartHow are VARIANT columns stored? 
As a separate physical columns 
 
 
Are common and/or frequent fields/paths in VARIANT columns stored as separate physical columns? 
Yes 
 
 
For data that is mostly regular and uses only native JSON types (strings and numbers, not timestamps), are both storage and q...
What are the 4 Snowflake table types? - Answer Permanent 
External 
Temporary 
Transient 
 
Which of the following are Snowflake view types? 
Secure 
Permanent 
External 
Standard 
Materialized 
Transient - Answer Secure 
Standard 
Materialized 
 
What are the three Snowflake Stage types? 
Secure ...
Preview 2 out of 5 pages
Add to cartWhat are the 4 Snowflake table types? - Answer Permanent 
External 
Temporary 
Transient 
 
Which of the following are Snowflake view types? 
Secure 
Permanent 
External 
Standard 
Materialized 
Transient - Answer Secure 
Standard 
Materialized 
 
What are the three Snowflake Stage types? 
Secure ...
Which of the following terms are associated with the Cloud Services Layer? 
Query Processing 
Query Planning 
Query Optimization 
Query Design 
Query Compilation - Answer Query Planning 
Query Optimization 
Query Compilation 
 
Which of the following terms are associated with the Compute/Warehouse...
Preview 2 out of 7 pages
Add to cartWhich of the following terms are associated with the Cloud Services Layer? 
Query Processing 
Query Planning 
Query Optimization 
Query Design 
Query Compilation - Answer Query Planning 
Query Optimization 
Query Compilation 
 
Which of the following terms are associated with the Compute/Warehouse...
Snowflake Editions - Answer 1. Standard 
2. Enterprise 
3. Business Critical Edition 
4. Virtual Private Snowflake (VPS) 
 
Standard Edition - Answer -Complete SQL data warehouse 
-Secure data sharing 
-Premier support 24x365 
-1 day of time travel 
-Enterprise-grade encryption 
-Dedicated virtu...
Preview 4 out of 33 pages
Add to cartSnowflake Editions - Answer 1. Standard 
2. Enterprise 
3. Business Critical Edition 
4. Virtual Private Snowflake (VPS) 
 
Standard Edition - Answer -Complete SQL data warehouse 
-Secure data sharing 
-Premier support 24x365 
-1 day of time travel 
-Enterprise-grade encryption 
-Dedicated virtu...
Multi-Cluster warehouses are which Snowflake edition's feature? - Answer Enterprise 
 
When the Warehouse is resumed, what is the amount of Snowflake credit charged? - Answer 1 Minute 
After 1 minute, per second 
 
What are the security and authentication features offered by Snowflake? - Answer...
Preview 2 out of 6 pages
Add to cartMulti-Cluster warehouses are which Snowflake edition's feature? - Answer Enterprise 
 
When the Warehouse is resumed, what is the amount of Snowflake credit charged? - Answer 1 Minute 
After 1 minute, per second 
 
What are the security and authentication features offered by Snowflake? - Answer...
Snowflake supports which of the following file formats for data loading? Select all that apply. 
 
Parquet 
ORC 
CSV 
PDF Answer Parquet 
ORC 
CSV 
 
Which type of Data Integration tools leverage Snowflake's scalable compute for data transformation? Select the best answer. 
 
Database Replication 
...
Preview 2 out of 9 pages
Add to cartSnowflake supports which of the following file formats for data loading? Select all that apply. 
 
Parquet 
ORC 
CSV 
PDF Answer Parquet 
ORC 
CSV 
 
Which type of Data Integration tools leverage Snowflake's scalable compute for data transformation? Select the best answer. 
 
Database Replication 
...
Database Storage(Layer 3) Answer Responsible 
- Data loaded into snowflake is reorganized into internal optimized/compressed/columnar format 
- Data objects stored by Snowflake are not directly visible nor accessible by customers 
- Manages all aspects of data(size,compression etc) 
 
Query Processi...
Preview 2 out of 11 pages
Add to cartDatabase Storage(Layer 3) Answer Responsible 
- Data loaded into snowflake is reorganized into internal optimized/compressed/columnar format 
- Data objects stored by Snowflake are not directly visible nor accessible by customers 
- Manages all aspects of data(size,compression etc) 
 
Query Processi...
Answer 
 
True or False: Network policies for granting or restricting users access to the site based on their IP address (i.e. IP whitelisting). Answer True 
 
True or False: Snowflake does NOT provide Verification/authentication required for any users accessing your account (includes support for M...
Preview 2 out of 7 pages
Add to cartAnswer 
 
True or False: Network policies for granting or restricting users access to the site based on their IP address (i.e. IP whitelisting). Answer True 
 
True or False: Snowflake does NOT provide Verification/authentication required for any users accessing your account (includes support for M...
What is the best way to store semi-structured data? Answer Data should be loaded and stored in a VARIANT type column 
 
What is the best practice for handling semi-structured data with 3rd party BI tools? Answer Create a Snowflake view that parse the semi-structured column into structure columns for...
Preview 4 out of 233 pages
Add to cartWhat is the best way to store semi-structured data? Answer Data should be loaded and stored in a VARIANT type column 
 
What is the best practice for handling semi-structured data with 3rd party BI tools? Answer Create a Snowflake view that parse the semi-structured column into structure columns for...
True or False? Metadata is created when you load data from a file in an internal stage to a Snowflake table. Answer True 
 
True or False? Are Snowpipe charges calculated per second and per core? Answer True 
 
What types of views are available in Snowflake? Answer Regular, secure and materialized 
...
Preview 2 out of 13 pages
Add to cartTrue or False? Metadata is created when you load data from a file in an internal stage to a Snowflake table. Answer True 
 
True or False? Are Snowpipe charges calculated per second and per core? Answer True 
 
What types of views are available in Snowflake? Answer Regular, secure and materialized 
...
What is the best way to store semi-structured data? Answer Data should be loaded and stored in a VARIANT type column 
 
What is the best practice for handling semi-structured data with 3rd party BI tools? Answer Create a Snowflake view that parse the semi-structured column into structure columns for...
Preview 4 out of 242 pages
Add to cartWhat is the best way to store semi-structured data? Answer Data should be loaded and stored in a VARIANT type column 
 
What is the best practice for handling semi-structured data with 3rd party BI tools? Answer Create a Snowflake view that parse the semi-structured column into structure columns for...
Account Level Credit Budget Answer Defined number of credits you expect to consume 
 
Priority Warehouse is important Resource Monitoring because? Answer Ensures a specific warehouse has the most credits available based on importance 
 
Credit Quota for Resource Monitor cannot be resumed until? Answ...
Preview 2 out of 8 pages
Add to cartAccount Level Credit Budget Answer Defined number of credits you expect to consume 
 
Priority Warehouse is important Resource Monitoring because? Answer Ensures a specific warehouse has the most credits available based on importance 
 
Credit Quota for Resource Monitor cannot be resumed until? Answ...
You own table T1 in schema S1. The schema lives in database D1. In order to grant read-only permissions to this table to a newly created role, R1, you need to... 
 
A) Grant USAGE on D1 
B) Grant SELECT on D1 
C) Grant USAGE on S1 
D) Grant SELECT on S1 
E) Grant USAGE on T1 
F) Grant SELECT on T1 A...
Preview 3 out of 23 pages
Add to cartYou own table T1 in schema S1. The schema lives in database D1. In order to grant read-only permissions to this table to a newly created role, R1, you need to... 
 
A) Grant USAGE on D1 
B) Grant SELECT on D1 
C) Grant USAGE on S1 
D) Grant SELECT on S1 
E) Grant USAGE on T1 
F) Grant SELECT on T1 A...
Which of the following terms are associated with the Cloud Services Layer? 
Select all that apply. 
Query Processing 
Query Planning 
Query Optimization 
Query Design 
Query Compilation Answer Query Planning 
Query Optimization 
Query Compilation 
 
Which of the following are performed by the Cloud ...
Preview 4 out of 33 pages
Add to cartWhich of the following terms are associated with the Cloud Services Layer? 
Select all that apply. 
Query Processing 
Query Planning 
Query Optimization 
Query Design 
Query Compilation Answer Query Planning 
Query Optimization 
Query Compilation 
 
Which of the following are performed by the Cloud ...
A year old database has DATA_RETENTION_TIME_IN_DAYS set to 90 days. The DATA_RETENTION_TIME_IN_DAYS is reset to 30 days. What happens to the data stored in time travel older than 30 days for this database? 
 
All data in time travel for this database will be deleted and new changes to the database w...
Preview 2 out of 9 pages
Add to cartA year old database has DATA_RETENTION_TIME_IN_DAYS set to 90 days. The DATA_RETENTION_TIME_IN_DAYS is reset to 30 days. What happens to the data stored in time travel older than 30 days for this database? 
 
All data in time travel for this database will be deleted and new changes to the database w...
What is a SF virtual warehouse? Answer Virtual warehouse is the name given to the compute clusters used by SF for query processing. 
 
Which options can be used to bring semi structured data into SF? Answer Load semi structured data into a VARIANT column; Transform the data while using the COPY comm...
Preview 2 out of 10 pages
Add to cartWhat is a SF virtual warehouse? Answer Virtual warehouse is the name given to the compute clusters used by SF for query processing. 
 
Which options can be used to bring semi structured data into SF? Answer Load semi structured data into a VARIANT column; Transform the data while using the COPY comm...
Which of the following semi-structured file formats are supported by Snowflake? Answer - XML 
- Parquret 
- JSON 
 
The load metadata for a table expires after how many days? Answer 64 
 
t/f Is snowpipe serverless? Answer True 
 
Which of the following statements are true for Snowpipe? Answer - Sno...
Preview 1 out of 4 pages
Add to cartWhich of the following semi-structured file formats are supported by Snowflake? Answer - XML 
- Parquret 
- JSON 
 
The load metadata for a table expires after how many days? Answer 64 
 
t/f Is snowpipe serverless? Answer True 
 
Which of the following statements are true for Snowpipe? Answer - Sno...
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Stuvia is a marketplace, so you are not buying this document from us, but from seller cracker. Stuvia facilitates payment to the seller.
No, you only buy these notes for $45.99. You're not tied to anything after your purchase.
4.6 stars on Google & Trustpilot (+1000 reviews)
91401 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now