SNOWPRO CORE CERTIFICATION
EXAM NEWEST ACTUAL EXAM 2024
QUESTIONS AND DETAILED CORRECT
ANSWERS (VERIFIED ANSWERS) |
ALREADY PASSED A+ GRADE
What are the two scaling policies that can be defined
when creating a multi-cluster warehouse? Choose two
correct values.
a. Maximized
b. Conservative
c. Standard
d. Economy
e. Minimum Correct Answer Standard & Economy
What do you configure a SHARE object with? Choose two
correct values.
a. Object privileges.
b. A retention period in days.
c. Account identifiers.
d. URL. Correct Answer a. Object privileges. & c. Account
identifiers.
What is the default compression format used when
unloading files from Snowflake using the GET command?
Choose one correct value.
a. SNAPPY
b. Bz2
,c. GZIP
d. BROTLI Correct Answer c. GZIP
What's the maximum number of days a user could set the
table property DATA_RETENTION_TIME_IN_DAYS to for
a transient table on a business critical edition Snowflake
account? Choose one correct value.
a. 0
b. 1
c. 10
d. 90 Correct Answer b. 1
Which system-defined role is it recommended to assign
custom roles to? Choose one correct value.
a. USERADMIN
b. ACCOUNTADMIN
c. SECURITYADMIN
d. SYSADMIN
e. ORGADMIN Correct Answer d. SYSADMIN
Which system function is called to retrieve clustering
metadata for a column or columns? Choose one correct
value.
a. system$natural_clustering_information
b. system$allowlist
c. system$clustering_metadata
d. system$clustering_information Correct Answer d.
system$clustering_information
What is the purpose of the VALIDATE function? Choose
one correct value.
,a. Allows a user to perform a dry-run of the load process
to expose errors.
b. Allows a user to view all errors encountered during all
previous runs of a COPY INTO execution.
c. Allows a user to view all errors encountered during a
previous COPY INTO execution.
d. Outputs a pdf to a configured stage of all the errors of a
past execution. Correct Answer c. Allows a user to view all
errors encountered during a previous COPY INTO
execution.
Micro-partitions can be modified once they have been
created. True or false?
True
False Correct Answer False
What is the query to remove a virtual warehouse? Choose
one correct value.
a. DROP WAREHOUSE MY_WAREHOUSE;
b. CLEAR WAREHOUSE MY_WAREHOUSE;
c. DELETE WAREHOUSE MY_WAREHOUSE;
d. REMOVE WAREHOUSE MY_WAREHOUSE; Correct
Answer a. DROP WAREHOUSE MY_WAREHOUSE;
Virtual warehouses are billed on a per second basis. What
is the minimum number of seconds a virtual warehouse is
billed for? Choose one correct value.
a. 120
b. 60
c. 10
, d. 30 Correct Answer b. 60
Data loading typically requires the use of a XXL Virtual
Warehouse. True or false?
True
False Correct Answer False
How many days is the query history maintained in the
history tab of the classic UI? Choose one correct value.
a. 7
b. 14
c. 21
d. 10 Correct Answer 14
Snowflake uses the following access control schemes:
role based access control (RBAC) and _________.
Choose one correct value.
a. Discretionary Access Control (DAC)
b. Mandatory Access Control (MAC)
c. Compulsory Access Control (CAC)
d. Imperative Access Control (IAC) Correct Answer a.
Discretionary Access Control (DAC)
When is a table stage not appropriate to use for data
loading? Select all that apply.
a. When multiple users want to load data into multiple
tables.
b. When a single user wants to load data into multiple
tables.
c. When multiple users want to load data into a single
table.
EXAM NEWEST ACTUAL EXAM 2024
QUESTIONS AND DETAILED CORRECT
ANSWERS (VERIFIED ANSWERS) |
ALREADY PASSED A+ GRADE
What are the two scaling policies that can be defined
when creating a multi-cluster warehouse? Choose two
correct values.
a. Maximized
b. Conservative
c. Standard
d. Economy
e. Minimum Correct Answer Standard & Economy
What do you configure a SHARE object with? Choose two
correct values.
a. Object privileges.
b. A retention period in days.
c. Account identifiers.
d. URL. Correct Answer a. Object privileges. & c. Account
identifiers.
What is the default compression format used when
unloading files from Snowflake using the GET command?
Choose one correct value.
a. SNAPPY
b. Bz2
,c. GZIP
d. BROTLI Correct Answer c. GZIP
What's the maximum number of days a user could set the
table property DATA_RETENTION_TIME_IN_DAYS to for
a transient table on a business critical edition Snowflake
account? Choose one correct value.
a. 0
b. 1
c. 10
d. 90 Correct Answer b. 1
Which system-defined role is it recommended to assign
custom roles to? Choose one correct value.
a. USERADMIN
b. ACCOUNTADMIN
c. SECURITYADMIN
d. SYSADMIN
e. ORGADMIN Correct Answer d. SYSADMIN
Which system function is called to retrieve clustering
metadata for a column or columns? Choose one correct
value.
a. system$natural_clustering_information
b. system$allowlist
c. system$clustering_metadata
d. system$clustering_information Correct Answer d.
system$clustering_information
What is the purpose of the VALIDATE function? Choose
one correct value.
,a. Allows a user to perform a dry-run of the load process
to expose errors.
b. Allows a user to view all errors encountered during all
previous runs of a COPY INTO execution.
c. Allows a user to view all errors encountered during a
previous COPY INTO execution.
d. Outputs a pdf to a configured stage of all the errors of a
past execution. Correct Answer c. Allows a user to view all
errors encountered during a previous COPY INTO
execution.
Micro-partitions can be modified once they have been
created. True or false?
True
False Correct Answer False
What is the query to remove a virtual warehouse? Choose
one correct value.
a. DROP WAREHOUSE MY_WAREHOUSE;
b. CLEAR WAREHOUSE MY_WAREHOUSE;
c. DELETE WAREHOUSE MY_WAREHOUSE;
d. REMOVE WAREHOUSE MY_WAREHOUSE; Correct
Answer a. DROP WAREHOUSE MY_WAREHOUSE;
Virtual warehouses are billed on a per second basis. What
is the minimum number of seconds a virtual warehouse is
billed for? Choose one correct value.
a. 120
b. 60
c. 10
, d. 30 Correct Answer b. 60
Data loading typically requires the use of a XXL Virtual
Warehouse. True or false?
True
False Correct Answer False
How many days is the query history maintained in the
history tab of the classic UI? Choose one correct value.
a. 7
b. 14
c. 21
d. 10 Correct Answer 14
Snowflake uses the following access control schemes:
role based access control (RBAC) and _________.
Choose one correct value.
a. Discretionary Access Control (DAC)
b. Mandatory Access Control (MAC)
c. Compulsory Access Control (CAC)
d. Imperative Access Control (IAC) Correct Answer a.
Discretionary Access Control (DAC)
When is a table stage not appropriate to use for data
loading? Select all that apply.
a. When multiple users want to load data into multiple
tables.
b. When a single user wants to load data into multiple
tables.
c. When multiple users want to load data into a single
table.
