Practice Test #2 Flashcards
Snowflake’s micro-partitions directly enable which of the following features?
Zero-copy cloning
Data sharing
Time travel
Bulk/continuous data loading
zero copy cloning
time travel
True or false: There is a difference in storage cost allocation between structured and semi-structured data.
false
True or false: Data stored in time travel and fail safe incur storage cost.
true
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.
true
True or false: Time travel is enabled for all Snowflake accounts
true
True or false: The clustering depth for a table is not an absolute or precise measure of whether the table is well-clustered.
true. query performance is the best indicator.
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
both
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.
true
True or false: Manually sort rows on key table columns and re-insert them into the table could be expensive.
true
True or false: A table with a clustering key defined is considered to be clustered.
true
true or false: The compute resources used to perform clustering does not consume credits.
false
True or false: All tables should be clustered to improve query efficiency.
false
True or false: Generally, the more frequently a table changes, the more expensive it will be to keep it clustered.
true
True or false: Putting a higher cardinality column before a lower cardinality column will generally reduce the effectiveness of clustering on the latter column
true
What should you consider before defining a clustering key for a table?
Associated credit & storage costs
True or false: A table can only have one clustering key at a time.
true
True or false: Snowflake only reclusters a clustered table if it will benefit from the operation.
true
True or false: When a Clone of a Table is created, the original Table’s data is physically copied.
false
True or false: A Data Provider can create a share for a consumer account location in a different cloud region.
false, must be from same region
What are the two ways to create a share?
sql
web ui
True or false: Data providers can share any views and/or UDFs with data consumers.
False: Can share secure views & secure UDFs only.
True or false: Not all editions of Snowflake support data sharing.
True. VPS doesn’t support it.
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
none
t/f All objects in a share must be from the same DB?
true
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
True or false: A data provider may add an account before granting usage on a DB.
False: It will result in an error
Which function is used to convert nested values into separate columns?
FLATTEN
True or false: The steps for loading semi-structured data into tables are identical to those for loading structured data into relational tables.
TRUE
What are the semi-structure data types that Snowflake supports? HINT - there are 5.
JSON, Avro, Parquet, XML, ORC
What is the maximum row size for VARIANT data type?
16mb
Using the Snowflake Web UI, one can:
Create & manage users
Create Virtual WH
Load data
Create databases
ALL
True or false: You can use the Query Profile to monitor queries that have not finished executing.
True
The Query Profile shows:
Query status
Query ID
Warehouse
User
All
True or false: The syntax for loading data is COPY INTO
False
True or false: The syntax for unloading data is COPY INTO
True
True or false: A warehouse must be running in order to perform DELETE.
True
True or false: A warehouse consumes credits even when it’s in suspended state.
False
How many credits/hour doe a Small-sized warehouse consume?
2