Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

SnowPro Core Snowflake Cert > Practice Test #2 > Flashcards

Practice Test #2 Flashcards

1
Q

Snowflake’s micro-partitions directly enable which of the following features?

Zero-copy cloning

Data sharing

Time travel

Bulk/continuous data loading

A

zero copy cloning

time travel

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

True or false: There is a difference in storage cost allocation between structured and semi-structured data.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

True or false: Data stored in time travel and fail safe incur storage cost.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

True or false: Once a table created through zero-copy cloning is modified, the modified data will be stored as new blocks and incur storage cost.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

True or false: Time travel is enabled for all Snowflake accounts

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

True or false: The clustering depth for a table is not an absolute or precise measure of whether the table is well-clustered.

A

true. query performance is the best indicator.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Clustering depth is useful for:

Monitoring the clustering “health” of a large table

Determining whether a large table would benefit from explicitly defining a clustering key

A

both

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

True or false: Maintaining clustering of a column that has very high cardinality is more expensive than maintaining clustering of a column that has much lower cardinality.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

True or false: Manually sort rows on key table columns and re-insert them into the table could be expensive.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

True or false: A table with a clustering key defined is considered to be clustered.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

true or false: The compute resources used to perform clustering does not consume credits.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

True or false: All tables should be clustered to improve query efficiency.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

True or false: Generally, the more frequently a table changes, the more expensive it will be to keep it clustered.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

True or false: Putting a higher cardinality column before a lower cardinality column will generally reduce the effectiveness of clustering on the latter column

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What should you consider before defining a clustering key for a table?

A

Associated credit & storage costs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

True or false: A table can only have one clustering key at a time.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

True or false: Snowflake only reclusters a clustered table if it will benefit from the operation.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

True or false: When a Clone of a Table is created, the original Table’s data is physically copied.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

True or false: A Data Provider can create a share for a consumer account location in a different cloud region.

A

false, must be from same region

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What are the two ways to create a share?

A

sql

web ui

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

True or false: Data providers can share any views and/or UDFs with data consumers.

A

False: Can share secure views & secure UDFs only.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

True or false: Not all editions of Snowflake support data sharing.

A

True. VPS doesn’t support it.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Which of the following can a data consumer do? Select all that apply.

Create a clone from a shared DB / schema / table

Time travel for a shared DB / schema / table

Modify any of the information in the shared DB / schema / table

Edit the comments for a shared DB / schema / table

A

none

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

t/f All objects in a share must be from the same DB?

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
True or false: A Data provider may grant privilege to a table without granting the privilege to the schema that the table belongs to,.
False: Must grant it to any container objects before granting to objects inside the container
26
True or false: A data provider may add an account before granting usage on a DB.
False: It will result in an error
27
Which function is used to convert nested values into separate columns?
FLATTEN
28
True or false: The steps for loading semi-structured data into tables are identical to those for loading structured data into relational tables.
TRUE
29
What are the semi-structure data types that Snowflake supports? HINT - there are 5.
JSON, Avro, Parquet, XML, ORC
30
What is the maximum row size for VARIANT data type?
16mb
31
Using the Snowflake Web UI, one can: Create & manage users Create Virtual WH Load data Create databases
ALL
32
True or false: You can use the Query Profile to monitor queries that have not finished executing.
True
33
The Query Profile shows: Query status Query ID Warehouse User
All
34
True or false: The syntax for loading data is COPY INTO
False
35
True or false: The syntax for unloading data is COPY INTO
True
36
True or false: A warehouse must be running in order to perform DELETE.
True
37
True or false: A warehouse consumes credits even when it’s in suspended state.
False
38
How many credits/hour doe a Small-sized warehouse consume?
2
39
How do we consider while calculating the number of credits billed for a multi-cluster warehouse? Number of servers per cluster Number of times the warehouse scale up and/or down Number of clusters that run within the period Whether auto-resume and/or auto-suspend is on
Number of servers per cluster Number of clusters that run within the period
40
True or false: Large warehouse always executes queries faster than a small warehouse.
False
41
True or false: Auto-suspend is enabled by default by Snowflake.
False
42
True or false: You may apply auto-suspend to an individual cluster in a warehouse.
False
43
True or false: The default warehouse for a user is used as the warehouse for all sessions initiated by the user.
True
44
Select all that apply: Which of the following are blocking operators? MERGE UPDATE INSERT COPY
merge | update
45
Scaling policy for a multi-cluster warehouse? Choose 2 Standard Economy Optimized Maximized
standard | economy
46
Which of the following are types of caching use by Snowflake? Select all that apply? Metadata caching Query result caching Warehouse Caching
all
47
True or false: Snowflake only works with cloud-based tools.
false
48
True or false: You can use GET command in the UI.
false
49
What objects can you support time travels on?
tables, schemas, databases
50
What are the different types of tables? Persistent Temporary Transient Permanent
Temporary Transient Permanent
51
What can you download through UI? SnowSQL ODBC Driver JDBC Driver
ODBC Driver JDBC Driver
52
How often does Snowflake release updates? Once a week Once every two weeks Once month There is no set schedule
once a week
53
How to see your clustering information? Select all apply SYSTEM$CLUSTERING_INFORMATION SYSTEM$CLUSTERING_KEYS SYSTEM$CLUSTERING_DEPTH SYSTEM$CLUSTERING_RATIO
SYSTEM$CLUSTERING_INFORMATION | SYSTEM$CLUSTERING_DEPTH
54
Account Usage includes dropped objects.
true
55
Information Schema includes dropped objects.
false
56
True or false: You can clone a share.
false
57
You can grant usage of an object to a user as long as you have the SYSADMIN role.
false
58
Which languages can be used to create user-defined functions? SQL JAVASCRIPT JAVA Python
sql | javascript
59
How long does query history stay in INFORMATION_SCHEMA?
1 year
60
How long does query history stay in the UI?
14 days
61
True or false: When a clone of a table is created, the original table’s data is physically copied?
false
62
True or false: SECURITYADMIN has the highest privileges among all roles.
false
63
True or false: When a Snowflake account is created, the account automatically comes with three out-of-the-box roles: ACCOUNTADMIN, SECURITYADMIN, and SYSADMIN.
false
64
True or false: Users own objects which allows the role to access those objects.
false
65
True or false: Two databases with the same cannot be under the same account.
true
66
What can be used to limit the number of credits consumed?
resource monitors
67
True or false: Cloud-based data sharing can be nearly instantaneous, i.e. independent of data size.
true
68
Can you access anything in the Global Services Layer?
no
69
Which term is used to describe Snowflake’s architecture?
multi cluster shared data wh
70
What is the full name of the highest Snowflake edition?
virtual private snowflake
71
Which of the following doesn’t belong to the top bar in the UI? Shares Tables Credit Usage History
tables | credit usage
72
True or false: Snowflake is great for OLAP workload.
true
73
True or false: A single Snowflake deployment can run in multiple regions as long as the right permissions are granted.
false
74
True or false: The Query Profiler view is only available for completed queries.
false
75
True or false: Auto-clustering feature is only available for certain Snowflake editions.
false
76
Which of the following does SF not support? Upsert Insert Merge
upsert
77
Why would you scale a Virtual Warehouse OUT?
handle concurrency
78
Which of the following table types have no fail-safe feature enabled? Temporary Transient Permanent
temporary | transient
79
Which of the following table types have time-travel feature enabled? Temporary Transient Permanent
all
80
Which of the following are serverless functions? Auto-clustering Snowpipe Materialized Views UDFs
Auto-clustering Snowpipe Materialized Views
81
What is the default file format for data loading if you do not specify one?
csv
82
True or false: When active, a pipe required a dedicated warehouse to execute against it.
false
83
true or false: Snowpipe only works with internal stages.
false
84
True or false: MFA is only for SSO
false
85
True or false: All data in Snowflake is encrypted
true
86
True or false: End-to-end encryption feature is only available for some Snowflake editions.
false
87
How many shares can a data providers create?
unlimited
88
How many shares can a data consumer consume?
unlimited
89
True or false: Data sharing is only available for some Snowflake editions.
true
90
True or false: You cannot modify tables in shared databases in Snowflake.
true
91
Can customers still use Snowflake while the releases are rolling out?
Yes, because there’s no down time for customers
92
True or false: In Snowflake, only NOT NULL constraint is enforced.
true
93
Which layer is the result set cache located?
services layer
94
Does SF external staging require the customer to encrypt the data before transmission?
yes
95
Can you configure fail-safe?
no
96
True or false: A stored procedure may return a value whereas a UDF must return a value.
true

SnowPro Core Snowflake Cert (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions