Snowflake
COF-R02
Q1:
Which Snowflake tool would be BEST to troubleshoot network connectivity?
○
A
SnowCLI○
B
SnowUI○
C
SnowSQL○
D
SnowCD
Snowflake
COF-R02
Q2:
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?
○
A
SHOW GRANTS ON ROLE DATA_SCIENCE○
B
SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING○
C
SHOW GRANTS TO USER INQUISITIVE_PERSON○
D
SHOW GRANTS OF ROLE DATA_SCIENCE
Snowflake
COF-R02
Q3:
Which of the following are characteristics of security in Snowflake?
○
A
Account and user authentication is only available with the Snowflake Business Critical edition.○
B
Support for HIPAA and GDPR compliance is available for UI Snowflake editions.○
C
Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher○
D
Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
Snowflake
COF-R02
Q4:
Which formats does Snowflake store unstructured data in? (Choose two.)
☐
A
GeoJSON☐
B
Array☐
C
XML☐
D
Object☐
E
BLOB
Snowflake
COF-R02
Q5:
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
○
A
The warehouse size does not change until all queries currently running in the warehouse have completed.○
B
The warehouse size does not change until all queries currently in the warehouse queue have completed.○
C
The warehouse size does not change until the warehouse is suspended and restarted.○
D
It does not return from the command until the warehouse has finished changing its size.