Snow16
Authored by Ismael Navarro Cruz
Specialty
Professional Development
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
13 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
Users
Tables
Databases
Internal Stages
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
parse_json()
json_extract_path_text()
object_construct()
flatten
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.
Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which Snowflake feature is used for both querying and restoring data?
Cluster keys
Time Travel
Fail-safe
Cloning
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
Configure the Maximum Clusters setting to ‘Auto-Scale’
Set the Warehouse type to ‘Auto’
Set the Minimum Clusters and Maximum Clusters settings to the same value
Set the Minimum Clusters and Maximum Clusters settings to the different values
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which of the following roles is recommended to be used to create and manage users and roles?
SYSADMIN
SECURITYADMIN
PUBLIC
ACCOUNTADMIN
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which Snowflake table supports unstructured data?
Directory
Transient
Temporary
Permanent
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
11 questions
CANARA CHANAKYA QUIZ ON FOUNDERS DAY 2019
Quiz
•
10th Grade - Professi...
10 questions
KIẾN THỨC CHUNG
Quiz
•
Professional Development
16 questions
DTW Quiz 1
Quiz
•
Professional Development
10 questions
Psychiatric Nursing
Quiz
•
University - Professi...
17 questions
Care Bears: UNLOCK THE MAGIC
Quiz
•
2nd Grade - Professio...
17 questions
Stacks
Quiz
•
KG - Professional Dev...
10 questions
Preclinical Prosthodontics-Quiz-1
Quiz
•
Professional Development
16 questions
EDUC 204
Quiz
•
Professional Development
Popular Resources on Wayground
8 questions
Spartan Way - Classroom Responsible
Quiz
•
9th - 12th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
14 questions
Boundaries & Healthy Relationships
Lesson
•
6th - 8th Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
3 questions
Integrity and Your Health
Lesson
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
9 questions
FOREST Perception
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade