Select the different types of Internal Stages: (Choose three.)
A.
Named Stage
B.
User Stage
C.
Table Stage
D.
Schema Stage
Named Stage
User Stage
Table Stage
Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-anduse.
html/#Snowflake-Internal-
Named-Stage
Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:
A.
Scaling rhythmically
B.
Scaling max
C.
Scaling out
D.
Scaling Up
Scaling out
What is the maximum compressed row size in Snowflake?
A.
8KB
B.
16MB
C.
50MB
D.
4000GB
16MB
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
A.
Configure the Maximum Clusters setting to “Auto-Scale”
B.
Set the Warehouse type to “Auto”
C.
Set the Minimum Clusters and Maximum Clusters settings to the same value
D.
Set the Minimum Clusters and Maximum Clusters settings to the different values
Set the Minimum Clusters and Maximum Clusters settings to the different values
Which of the following is true of Snowpipe via REST API?
Choose 2 answers
A.
you can only use it on internal Stages
B.
All COPY INTO options are available fluting pipe creation
C.
Snowflake automatically manages the compute required to execute the Pipe's copy into
commands
D.
Snowpipe keeps track of which files it has loaded
All COPY INTO options are available fluting pipe creation
Snowpipe keeps track of which files it has loaded
What is the minimum Snowflake edition that provides data sharing?
A.
Standard
B.
Premier
C.
Enterprise
D.
Business Critical Edition
Standard
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization
when connecting?
(Choose all that apply.)
A.
JDBC
B.
SnowSQL
C.
Snowflake Web Interface (UI)
D.
ODBC
E.
Python
D18912E1457D5D1DDCBD40AB3BF70D5D
JDBC
SnowSQL
Snowflake Web Interface (UI)
ODBC
Python
D18912E1457D5D1DDCBD40AB3BF70D5D
True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).
A.
True
B.
False
False
Reference: https://docs.snowflake.com/en/user-guide/admin-security-fed-auth-use.html
Fail-safe is unavailable on which table types?
A.
Temporary
B.
Transient
C.
Provisional
D.
Permanent
Temporary
Transient
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html
which of the following are valid approaches to loading data into a snowflake table? select
all the below that apply.
A.
Bulk copy from an External Stage
B.
Continuous load using Snowpipe REST API
C.
The Snowflake Web Interface (UT) data loading wizard
D.
Bulk copy from an Internal Stage
Bulk copy from an External Stage
Continuous load using Snowpipe REST API
The Snowflake Web Interface (UT) data loading wizard
Reference: https://docs.snowflake.com/en/user-guide/data-load-overview.html
True or False: When you create a custom role, it is a practice to immediately grant that role
to ACCOUNTADMIN.
A.
True
B.
False
False
Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?
Select one.
A.
Account -> Schema -> Database -> Table
B.
Account -> Database -> Schema -> Table
C.
Database -> Schema -> Table -> Account
D.
Database -> Table -> Schema -> Account
Account -> Database -> Schema -> Table
| Page 3 out of 14 Pages |
| Previous |