
SP Study Udemy

Quiz
•
Professional Development
•
Professional Development
•
Hard
Dane S
FREE Resource
36 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
What is the purpose of the Snowflake SPLIT_TO_TABLE function?
To split a string into an array of sub-strings
To split a string and flatten the results into rows
To split a string and flatten the results into columns
To count the number of characters in a string
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How are privileges inherited in a role hierarchy in Snowflake?
Privileges are only inherited by the direct child role in the hierarchy.
Privileges are inherited by any roles above that role in the hierarchy.
Privileges are only inherited by the direct parent role in the hierarchy.
Privileges are inherited by any roles at the same level in the hierarchy.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):
SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
ACCOUNTADMIN
SECURITYADMIN, ACCOUNTADMIN
SECURITYADMIN, ACCOUNTADMIN, SYSADMIN
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?
Internal tokenization
Comments
Tags
Row access policies
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which loop type iterates until a condition is true?
FOR
REPEAT
WHILE
LOOP
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the Snowflake recommended Parquet file size when querying from external tables to optimize the number of parallel scanning operations?
1-16 MB
256-512 MB
16-128 MB
100-250 MB
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
The VALIDATE table function has which parameter as an input argument for a Snowflake user?
CURRENT_STATEMENT
JOB_ID
LAST_QUERY_ID
UUID_STRING
Create a free account and access millions of resources
Similar Resources on Wayground
37 questions
Docker Networking and Storage

Quiz
•
Professional Development
40 questions
C&SE PRE-KNOWLEDGE SURVEY (A+ 1102-CORE 2)

Quiz
•
University - Professi...
39 questions
AWS Practitioner 06

Quiz
•
Professional Development
31 questions
DP-900_Simulado_01

Quiz
•
Professional Development
39 questions
PPPK BK

Quiz
•
Professional Development
35 questions
0402 - Logistics Final Quiz

Quiz
•
Professional Development
40 questions
CISSP All-In-One Practice Exam Domain 1 Part 1

Quiz
•
Professional Development
40 questions
Surveillance

Quiz
•
Professional Development
Popular Resources on Wayground
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
10 questions
"LAST STOP ON MARKET STREET" Vocabulary Quiz

Quiz
•
3rd Grade
19 questions
Fractions to Decimals and Decimals to Fractions

Quiz
•
6th Grade
16 questions
Logic and Venn Diagrams

Quiz
•
12th Grade
15 questions
Compare and Order Decimals

Quiz
•
4th - 5th Grade
20 questions
Simplifying Fractions

Quiz
•
6th Grade
20 questions
Multiplication facts 1-12

Quiz
•
2nd - 3rd Grade