SNOWPRO CERTIFICATION EXAM,
PRACTICE EXAM AND STUDYGUIDE
NEWEST ACTUAL EXAM QUESTIONS
AND DETAILED CORRECT ANSWERS |
A+ GRADE ALREADY PASSED
Which type of data integration tools leverage SF's scalable
compute for data transformation?
A. Data Replication
B. ELT
C. ETL
D. Streaming Correct Answer B
Select all of the answers that describe SF micro-partitions. Micro-
partitions
A. Are the physical data files that comprise SF's logical tables
B. Are written to a customer configured cloud storage location
C. Will be updated as their row & column values are updated
D. Enable horizontal and vertical query pruning Correct Answer A
&D
Which of the following are TRUE about SF data sharing?
A. Consumers can query shared tables in the same query as their
own tables
B. Producers can share data to other databases such as Postgres
and MySQL
C. You don't need a SF virtual WH to query shared data
,D. Data sharing is integrated with role-based access control
Correct Answer A & D
True or False: When data is staged to a SF internal staging area
using the PUT command, the data is encrypted on the client's
machine. Correct Answer True
Which of the following are types of caching used by SF?
A. Warehouse Caching
B. Index Caching
C. Metadata Caching
D. Query result Caching Correct Answer A, C, & D
Which of the following is not a layer in SF's Architecture?
Storage
Cloud Services
Data Catalog
Virtual Warehouses Correct Answer Data Catalog
Which of the following techniques can be in SF to improve query
performance?
A. Index Definition
B. Cluster Keys/Reclustering
C. Distribution Keys
D. Query Hints Correct Answer B
True or False: SF offers tools to extract data from source
systems. Correct Answer False
Which of the following are options when creating a Virtual
Warehouse?
,A. Auto-suspend
B. Storage size
C. Auto-resume
D. Server Count Correct Answer A & C
True or False: The warehouse cache may be reset if a running
warehouse is suspended and then resumed. Correct Answer A
Which of the following best describes SF's processing engine?
Leverages Apache Spark
Based on Map Reduce
A derivative of Presto
Native SQL Correct Answer Native SQL
Which role in Snowflake allows a user to administer users and
manage all database objects?
SYSADMIN
SECURITYADMIN
ACCOUNTADMIN
ROOT Correct Answer ACCOUNTADMIN
Which transformations are available when using the COPY INTO
command to load data files into Snowflake from a stage?
Filters
Aggregates
Column data type conversion
Column concatention Correct Answer Column data type
conversion
Column concatention
The following factors affect data load rates:
, A. Physical location of the stage
B. RAM on the virtual warehouse
C. Gzip compression efficiency
D. Thread size Correct Answer Physical location of the stage
Gzip compression efficiency
True or False: Virtual Warehouses cannot be resized while
queries are running. Correct Answer False
True or False: A table in Snowflake can only be queried using the
Virtual Warehouse used to load the data. Correct Answer False
Which of the following statements apply to Snowflake in terms of
security?
A. Snowflake leverages a role-based access control model
B. Snowflake requires you to configure an IAM user in order to
connect to the database
C. All data in Snowflake is encrypte
D. Snowflake can run within a customer's VPC Correct Answer A
&C
True or False: Snowflake caches are automatically invalidated if
the underlying data changes. Correct Answer True
True or False: The query profiler view is only available for
completed queries. Correct Answer False
Which of the following are true about the variant data type in
Snowflake?
A. Optimized storage based on repeated elements
B. Stored in a separate file format from structured data
C. Can be queried using JSON path notation
PRACTICE EXAM AND STUDYGUIDE
NEWEST ACTUAL EXAM QUESTIONS
AND DETAILED CORRECT ANSWERS |
A+ GRADE ALREADY PASSED
Which type of data integration tools leverage SF's scalable
compute for data transformation?
A. Data Replication
B. ELT
C. ETL
D. Streaming Correct Answer B
Select all of the answers that describe SF micro-partitions. Micro-
partitions
A. Are the physical data files that comprise SF's logical tables
B. Are written to a customer configured cloud storage location
C. Will be updated as their row & column values are updated
D. Enable horizontal and vertical query pruning Correct Answer A
&D
Which of the following are TRUE about SF data sharing?
A. Consumers can query shared tables in the same query as their
own tables
B. Producers can share data to other databases such as Postgres
and MySQL
C. You don't need a SF virtual WH to query shared data
,D. Data sharing is integrated with role-based access control
Correct Answer A & D
True or False: When data is staged to a SF internal staging area
using the PUT command, the data is encrypted on the client's
machine. Correct Answer True
Which of the following are types of caching used by SF?
A. Warehouse Caching
B. Index Caching
C. Metadata Caching
D. Query result Caching Correct Answer A, C, & D
Which of the following is not a layer in SF's Architecture?
Storage
Cloud Services
Data Catalog
Virtual Warehouses Correct Answer Data Catalog
Which of the following techniques can be in SF to improve query
performance?
A. Index Definition
B. Cluster Keys/Reclustering
C. Distribution Keys
D. Query Hints Correct Answer B
True or False: SF offers tools to extract data from source
systems. Correct Answer False
Which of the following are options when creating a Virtual
Warehouse?
,A. Auto-suspend
B. Storage size
C. Auto-resume
D. Server Count Correct Answer A & C
True or False: The warehouse cache may be reset if a running
warehouse is suspended and then resumed. Correct Answer A
Which of the following best describes SF's processing engine?
Leverages Apache Spark
Based on Map Reduce
A derivative of Presto
Native SQL Correct Answer Native SQL
Which role in Snowflake allows a user to administer users and
manage all database objects?
SYSADMIN
SECURITYADMIN
ACCOUNTADMIN
ROOT Correct Answer ACCOUNTADMIN
Which transformations are available when using the COPY INTO
command to load data files into Snowflake from a stage?
Filters
Aggregates
Column data type conversion
Column concatention Correct Answer Column data type
conversion
Column concatention
The following factors affect data load rates:
, A. Physical location of the stage
B. RAM on the virtual warehouse
C. Gzip compression efficiency
D. Thread size Correct Answer Physical location of the stage
Gzip compression efficiency
True or False: Virtual Warehouses cannot be resized while
queries are running. Correct Answer False
True or False: A table in Snowflake can only be queried using the
Virtual Warehouse used to load the data. Correct Answer False
Which of the following statements apply to Snowflake in terms of
security?
A. Snowflake leverages a role-based access control model
B. Snowflake requires you to configure an IAM user in order to
connect to the database
C. All data in Snowflake is encrypte
D. Snowflake can run within a customer's VPC Correct Answer A
&C
True or False: Snowflake caches are automatically invalidated if
the underlying data changes. Correct Answer True
True or False: The query profiler view is only available for
completed queries. Correct Answer False
Which of the following are true about the variant data type in
Snowflake?
A. Optimized storage based on repeated elements
B. Stored in a separate file format from structured data
C. Can be queried using JSON path notation
