Snowflake SnowPro Core Practice Exam 1
UPDATED ACTUAL QUESTIONS AND
CORRECT ANSWERS
Which of the following APIs are NOT Snowpipe REST APIs? - CORRECT
ANSWER insertHistoryScan and loadFiles - check documentation for further
explanation
How can a Snowflake user configure a virtual warehouse to support over 100 users if their
company has Enterprise Edition? - CORRECT ANSWER Use a multi-cluster
warehouse - a solution for simultaneous querying
What does a Query Profile provide in Snowflake? - CORRECT ANSWER A graphical
representation of the main components of the processing plan for a query
When a Pipe is recreated using the CREATE OR REPLACE PIPE command: - CORRECT
ANSWER The Pipe load history is reset to empty
Refresh is a parameter for ALTER PIPE
Which columns are available in the output of a Snowflake directory table? - CORRECT
ANSWER RELATIVE_PATH and LAST_MODIFIED
Also includes SIZE, MD5, ETag, and FILE_URL
Which Snowflake edition allows only one day of Time Travel? - CORRECT
ANSWER Standard
Enterprise can do 90 (1 by default)
Business Critical can also do 90 (1 by default)
,A medium(M) warehouse has auto-suspend configured after 15 minutes. You have noticed
that all of the queries that run on this warehouse finish within a minute. What will you do to
optimize compute costs? - CORRECT ANSWER Reduce the auto-suspend time to 1
minute
This will make it automatically go to sleep after 60 seconds of inactivity, significantly
reducing credit consumption
Which statement describes how Snowflake supports reader accounts? - CORRECT
ANSWER The SHOW MANAGED ACCOUNTS command will view all the reader
accounts that have been created for an account.
Lists all the managed accounts for your account currently used by data providers to create
reader accounts for their consumers
What property from the Resource Monitors lets you specify whether you want to control the
credit usage of your entire account or a specific set of warehouses? - CORRECT
ANSWER Monitor level
It's a dropdown or property that can be either entire account or entire warehouse level
A company's security audit requires generating a report listing all Snowflake logins within the
last 90 days.
Which of the following statements will return the required information? - CORRECT
ANSWER SELECT EVENT_TIMESTAMP, USER_NAME FROM
ACCOUNT_USAGE.LOGIN_HISTORY;
One might use login_history_by_user function but this function only return activity for the
last 7 days
, Which of the following sizes is not a Warehouse Size? - CORRECT ANSWER XXS
It doubles every time it goes up a size
Size - and Credit per hour
XS - 1
S -2
M-4
L-8
XL - 16
2XL - 32
3XL - 64
4XL - 128
5XL - 256
6XL - 512
What is the MOST performant file format for loading data in Snowflake? - CORRECT
ANSWER CSV (Gzipped)
Gzipped CSV is several times fast than loading from ORC and Parquet at 15TB/hr
Which of the following roles are NOT System-Defined Roles in Snowflake? - CORRECT
ANSWER VIEWER and STORAGEADMIN
ACCOUNTADMIN, SECURITYADMIN, SYSADMIN, USERADMIN, PUBLIC are all
System-Defined roles
When should you consider disabling auto-suspend for a Virtual Warehouse? - CORRECT
ANSWER When managing a steady workload and when the compute must be available
with no delay or lag time
UPDATED ACTUAL QUESTIONS AND
CORRECT ANSWERS
Which of the following APIs are NOT Snowpipe REST APIs? - CORRECT
ANSWER insertHistoryScan and loadFiles - check documentation for further
explanation
How can a Snowflake user configure a virtual warehouse to support over 100 users if their
company has Enterprise Edition? - CORRECT ANSWER Use a multi-cluster
warehouse - a solution for simultaneous querying
What does a Query Profile provide in Snowflake? - CORRECT ANSWER A graphical
representation of the main components of the processing plan for a query
When a Pipe is recreated using the CREATE OR REPLACE PIPE command: - CORRECT
ANSWER The Pipe load history is reset to empty
Refresh is a parameter for ALTER PIPE
Which columns are available in the output of a Snowflake directory table? - CORRECT
ANSWER RELATIVE_PATH and LAST_MODIFIED
Also includes SIZE, MD5, ETag, and FILE_URL
Which Snowflake edition allows only one day of Time Travel? - CORRECT
ANSWER Standard
Enterprise can do 90 (1 by default)
Business Critical can also do 90 (1 by default)
,A medium(M) warehouse has auto-suspend configured after 15 minutes. You have noticed
that all of the queries that run on this warehouse finish within a minute. What will you do to
optimize compute costs? - CORRECT ANSWER Reduce the auto-suspend time to 1
minute
This will make it automatically go to sleep after 60 seconds of inactivity, significantly
reducing credit consumption
Which statement describes how Snowflake supports reader accounts? - CORRECT
ANSWER The SHOW MANAGED ACCOUNTS command will view all the reader
accounts that have been created for an account.
Lists all the managed accounts for your account currently used by data providers to create
reader accounts for their consumers
What property from the Resource Monitors lets you specify whether you want to control the
credit usage of your entire account or a specific set of warehouses? - CORRECT
ANSWER Monitor level
It's a dropdown or property that can be either entire account or entire warehouse level
A company's security audit requires generating a report listing all Snowflake logins within the
last 90 days.
Which of the following statements will return the required information? - CORRECT
ANSWER SELECT EVENT_TIMESTAMP, USER_NAME FROM
ACCOUNT_USAGE.LOGIN_HISTORY;
One might use login_history_by_user function but this function only return activity for the
last 7 days
, Which of the following sizes is not a Warehouse Size? - CORRECT ANSWER XXS
It doubles every time it goes up a size
Size - and Credit per hour
XS - 1
S -2
M-4
L-8
XL - 16
2XL - 32
3XL - 64
4XL - 128
5XL - 256
6XL - 512
What is the MOST performant file format for loading data in Snowflake? - CORRECT
ANSWER CSV (Gzipped)
Gzipped CSV is several times fast than loading from ORC and Parquet at 15TB/hr
Which of the following roles are NOT System-Defined Roles in Snowflake? - CORRECT
ANSWER VIEWER and STORAGEADMIN
ACCOUNTADMIN, SECURITYADMIN, SYSADMIN, USERADMIN, PUBLIC are all
System-Defined roles
When should you consider disabling auto-suspend for a Virtual Warehouse? - CORRECT
ANSWER When managing a steady workload and when the compute must be available
with no delay or lag time
