Font size
S
M
L
XL
WorksheetsEOD Fundamentals Quiz
Total questions: 54
Worksheet time: 27mins
Name
Class
Date
1.
What are the types of scaling?
a)
Across
b)
Up/Down
c)
Blocked/Through
d)
Back/Out
2.
Metadata is managed in which layer?
a)
Compute Layer
b)
Data Storage Layer
c)
Cloud Services Layer
d)
Cloud Vendor (Azure, AWS, GCP)
3.
How does Snowflake eliminate irrelevant data from scans?
a)
Defragmentation
b)
Pruning
c)
Indexes
d)
Gaussian elimination
4.
What are the four components of your session context?
a)
Schema
b)
Database
c)
Role
d)
Group
e)
Warehouse
5.
How can you connect to Snowflake?
a)
JDBC
b)
Snowsight
c)
Snowclient
d)
SnowSQL
6.
How could you protect a table with sensitive columns from being accessed by certain roles, without consuming more storage?
a)
Create a secure materialized view on the sensitive table, grant access only to the secure materialized view
b)
Create a secure view on the sensitive table, grant access only to the secure view
c)
Create a materialized view on the sensitive table, grant access only to the materialized view
d)
Create a view on the sensitive table, grant access only to the view.
7.
You execute "create table MyTable (column1 varchar(50));". What is the name of the table created?
a)
MyTable
b)
mytable
c)
"MyTable"
d)
MYTABLE
8.
While troubleshooting, you want a way to quickly locate all queries related to a specific workload. What feature would help with this?
a)
Query Tags
b)
Workload Labels
c)
Snowcategories
d)
Indexes
9.
You execute the following statements:
ALTER ACCOUNT SET DATA_RETENTION_TIME_IN_DAYS = 5;
ALTER TABLE mytable SET DATA_RETENTION_TIME_IN_DAYS = 10;
How many days of retention will be effective on mytable?
a)
0
b)
1.0
c)
5.0
d)
10.0
10.
What caches do we have in Snowflake?
a)
Buffer Cache
b)
Data Cache
c)
Query Result Cache
d)
Metadata Cache
e)
Index Cache
11.
Which cache can be bypassed?
a)
Buffer Cache
b)
Data Cache
c)
Result Cache
d)
Metadata Cache
e)
Index Cache
12.
Without actually executing a query, how can you see the steps the query will take when executed?
a)
QUERY PROFILE
b)
DATA DICTIONARY
c)
EXPLAIN PLAN
d)
ACCESS PATH
13.
After executing a query, where can you see the steps taken?
a)
QUERY PROFILE
b)
DATA DICTIONARY
c)
EXPLAIN PLAN
d)
ACCESS PATH
14.
When performing a GROUP BY, which characteristics will improve performance?
a)
More distinct values in the GROUP BY columns
b)
Fewer distinct values in the GROUP BY columns
c)
Using Indexed columns in the GROUP BY columns
d)
Gathering Statistics on the GROUP BY columns
15.
What type of stage is "@%somename"?
a)
USER
b)
TABLE
c)
NAMED
16.
You load data from a stage using COPY INTO. You wish to load the data again, effectively duplicating the rows. How would you do this?
a)
Perform the COPY INTO with the DUPLICATE option
b)
Perform the same COPY INTO command a second time
c)
This is not possible
d)
Perform the COPY INTO with the FORCE option
17.
Which feature can facilitate continuous data loading?
a)
Snowkafka
b)
Snowkinesis
c)
Snowpipe
d)
Snowrealtime
18.
You wish to export data from Snowflake. Which command will help with this?
a)
COPY FROM
b)
COPY INTO
c)
UNLOAD INTO
d)
EXPORT FROM
19.
What are ways you can define when a task should run?
a)
Click the scheduling options in the Task wizard.
b)
Specify the AFTER option to automatically run a child task after its parent task has successfully completed.
c)
Specify an interval of time after which the task should run (such as 60 minutes).
d)
Use CRON sytax to specify a time, date, day of the week, and similar options.
20.
Which view do you use to see the status of your tasks?
a)
INFORMATION_SCHEMA.TASK_HISTORY
b)
INFORMATION_SCHEMA.QUERY_HISTORY
c)
INFORMATION_SCHEMA.TASK_STATUS
d)
INFORMATION_SCHEMA.SERVERLESS_TASK_HISTORY
21.
What do High-Performing Functions do?
a)
Provide procedural logic that SQL alone does not support
b)
Typically run slower in order to produce precise results
c)
Estimate approximate values using litle memory
d)
Perform aggregate functions on a subset of input rows
22.
Which are true of User Defined Functions?
a)
Can include DDL to create and modify tables
b)
Can be defined as secure so unauthorized users cannot see the underlying definition or tables
c)
Contain only one SQL statement
d)
Return either one (scalar) or more (tabular) rows
23.
For login access on your organization's Snowflake account, you can create a network policy to allow or block access based on:
a)
IP address
b)
device type
c)
subnet range, such as countries or continents (using CIDR notation)
d)
hostname
24.
Examples of authentication supported in Snowflake include federated authentication through SAML 2.0, third party services using the OAuth protocol, and automated cloud-based identity management through SCIM.
a)
True
b)
false
25.
Which are true of authorization in Snowflake?
a)
Queries of a secure view are optimized to run faster because when users are blocked, processing steps are bypassed.
b)
Row-level authorization limits which rows a user sees based on their current role, user, or account.
c)
Secure views and UDFs prevent unauthorized users from seeing their underlying query logic or source data.
d)
Privileges are assigned to roles.
26.
Which role has all privileges, so should be assigned to a limited number of people (and not as their default role)?
a)
SECURITYADMIN
b)
USERADMIN
c)
SYSADMIN
d)
ACCOUNTADMIN
27.
If you were querying a table earlier, but now the query returns an error message and you no longer see the table in the Object Browser, what should you check first?
a)
Check with someone who can use the ACCOUNTADMIN role and ask them to make sure nothing happened to the table.
b)
Check which role you are currently using, as you may have switched to a role that does not have access to the table.
c)
Check with other users to find out if someone deleted the table.
d)
Check with Snowflake support to ask them to retrieve the table with Fail-safe.
28.
How does Snowflake most commonly store semi-structured data, such as JSON, Avro, Parquet, ORC, and XML?
a)
Stored as JSON, AVRO, PARQUET, ORC, or XML data types
b)
Stored as CLOB, NCLOB, LOB, or BSON data types
c)
Stored as VARCHAR data type
d)
Stored as VARIANT data type
29.
To refer to the value "temperature" in column "v" of a JSON data file, you can use SELECT v:temperature or SELECT v['temperature'].
a)
True
b)
false
30.
How can you operate on values stored in semi-structured format, for example, to compare values, add or average values, or filter them?
a)
Use the UNRAVEL command
b)
CAST the values to SQL data types
c)
Use the FLATTEN command to pull out nested values
d)
Directly query the VARIANT column
31.
Data sharing is _________.
a)
globally available
b)
subject to data transfer costs from Provider to Consumer
c)
available only for read-only access
d)
revokable at any time
32.
A share set up by a Provider for Direct Data Sharing is automatically enabled for Consumers in other regions or cloud providers.
a)
True
b)
false
33.
What can Consumers do with a share?
a)
Join rows of a share with rows of an existing table in their own account
b)
Clone a share
c)
Import the same share to multiple "database" definitions in their own account
d)
Copy shared data into another table in their own account with CREATE TABLE AS…
e)
Execute Time Travel on a share
34.
To consume data from the Snowflake Data Marketplace, consumers must load the shared data into a database in their own account.
a)
True
b)
false
35.
What will allow a Virtual Warehouse to handle more simultaneous sessions?
a)
Scaling out with larger size
b)
Scaling up with larger size
c)
Scaling out with multicluster
d)
Scaling up with multicluster
36.
With an Economy scale-out policy, how many minutes could a query be waiting before starting?
a)
There is no wait; A new cluster is started as soon as required
b)
You can define this wait time with the parameter MAX_QUERY_WAIT_TIME
c)
Up to 6 minutes
d)
Up to 1 minute
e)
With Economy, a query could potentially wait forever
37.
What is the default maximum duration for a single statement?
a)
6 minutes
b)
1 hour
c)
1 day
d)
2 days
e)
Infinity
38.
Which are recommended to save on Snowflake storage costs?
a)
Reduce default Time travel settings on objects where appropriate.
b)
Opt for pay-as-you-use pricing over capacity pricing.
c)
Remove transient objects that are no longer needed.
d)
Use COPY INTO with the PURGE option or check internal stages for already-loaded files.
39.
To save on compute costs, which are recommended?
a)
Use Resource Monitors to help control compute usage.
b)
Set the auto-suspend value to short timeframes (1 minute or less).
c)
Always select the smallest size virtual warehouse.
d)
Use multi-cluster warehouses with auto-scaling.
40.
What is the name of the schema that you can use to find current details about storage, compute, and objects in your account?
a)
RESOURCE_SCHEMA
b)
INFORMATION_SCHEMA
c)
USAGE_SCHEMA
d)
ALL_SNOWFLAKE_SCHEMA
e)
SNOWFLAKE
41.
You see bytes spilled in a query profile. Without modifying the query, what might improve performance?
a)
Increase Warehouse Size
b)
Increase Number of Clusters
c)
Gather Stats
d)
Decrease Metadata overhead
42.
If EXPLAIN doesn't look good, you can give hints to influence the optimizer
a)
True
b)
false
43.
Which of these are potential causes of poor micro-partition pruning?
a)
Not using a WHERE clause
b)
Filtering on any column other than the date
c)
Using a WHERE x LIKE '%something%'
d)
Using SELECT in the FROM clause
44.
What does a FILE FORMAT do?
a)
Format the data being written to the table
b)
Describe how to read input files
45.
Which are true about STAGES?
a)
A stage is a cloud file respository
b)
A stage can be internal or external
c)
Stages disappear as soon as all files are loaded
d)
You can manually create named stages, user stages, or table stages
46.
Which are true about FORMATS?
a)
File formats store data of a particular type
b)
A file format stores information needed to parse input files for loading
c)
You must specify a file format as part of every COPY INTO command
d)
The default file format is CSV
47.
Using AUTO_INGEST, Snowpipe can load files from both internal and external stages
a)
True
b)
false
48.
What kind of function is found here? SELECT SUM(col1) FROM mytable;
a)
Table
b)
Clean
c)
Window
d)
Aggregate
e)
Scalar
49.
The SECURITYADMIN can set up MFA on any user in the system
a)
True
b)
false
50.
Snowflake managed keys are rotated how often?
a)
Daily (1 day)
b)
Weekly (7 days)
c)
Monthly (30 days)
d)
Yearly (365 days)
51.
When is Snowflake responsible for encrypting files in a stage?
a)
When it is external
b)
When it is internal
c)
When the file is tagged "secure"
d)
When the client fails to encrypt the file
52.
Which Built-in roles should be used to create roles and grants?
a)
ACCOUNTADMIN
b)
SYSADMIN
c)
SECURITYADMIN
d)
USERADMIN
e)
PUBLIC
53.
Privileges can be granted to
a)
Users
b)
Groups
c)
Security Groups
d)
Roles
e)
Warehouses
54.
GRANT ROLE ROLE_C to ROLE ROLE_A; GRANT ROLE_A TO USER BOB; Which roles can Bob use?
a)
ROLE_A
b)
ROLE_B
c)
ROLE_C
d)
PUBLIC
Reset
