[COF-C02] SnowPro Core Certification Mock Exam - 1 Flashcards
Type of function that can operate on a subset of rows within the set of input rows.
Window Function
If you recreate a pipe using CREATE OR REPLACE PIPE command. What does happen to load history if the Snowpipe gets recreated?
When you recreate a pipe, if you do CREATE OR REPLACE PIPE, that load history is reset to empty, so Snowflake doesn’t know which files we’ve already loaded.
Are Shares available for replication?
Yes
Database and share replication are available in all editions, including the Standard edition.
Replication of all other objects is only available for Business Critical Edition (or higher).
If a user is logged in to Snowflake in a federated environment and IdP times out, the current Snowflake sessions are affected?
No
After a specified period of time (defined by the IdP), a user’s session in the IdP automatically times out, but this does not affect their Snowflake sessions. Any Snowflake sessions that are active at the time remain open and do not require re-authentication. However, to initiate any new Snowflake sessions, the user must log into the IdP again.
CREATE DIRECTORY TABLE is the command necessary to create a Directory Table
No
A Directory table is not a separate database object; it stores a catalog of staged files in cloud storage.
Roles with sufficient privileges can query a directory table to retrieve file URLs to access the staged files and other metadata.
A directory table can be added explicitly to a stage when the stage is created (using CREATE STAGE) or later (using ALTER STAGE) with supplying directoryTableParams. directoryTableParams (for internal stages) ::= [ DIRECTORY = ( ENABLE = { TRUE | FALSE } [ REFRESH_ON_CREATE = { TRUE | FALSE } ] ) ] ENABLE = TRUE | FALSE Specifies whether to add a directory table to the stage. When the value is TRUE, a directory table is created with the stage.
Monica has successfully created a task with the 5 minutes schedule. It has been 30 minutes, but the task did not run. What could be the reason?
Monica should run the ALTER TASK command to RESUME the task
The first time we create the TASK, we need to run the ALTER TASK command to RESUME the task.
The major benefits of defining Clustering Keys
Defining clustering keys for very large tables (in the multi-terabyte range) helps optimize table maintenance and query performance. Small tables are not a good candidate for clustering.
An account-level resource monitor overrides the resource monitor assignment for individual warehouses. (True/False)
False
An account-level resource monitor does not override resource monitor assignments for individual warehouses.
If either the account resource monitor or the warehouse resource monitor reaches its defined threshold and a suspend action has been defined, the warehouse is suspended.
If an account has federated authentication enabled. Can Snowflake admins still maintain user IDs and passwords in Snowflake?
Yes
With federated authentication enabled on an account, Snowflake still allows maintaining and using Snowflake user credentials (login name and password).
Time Travel can be disabled for an account by ACCOUNTADMIN. (True/False)
False
Time Travel cannot be disabled for an account.
A user with the ACCOUNTADMIN role can set DATA_RETENTION_TIME_IN_DAYS to 0 at the account level, which means that all databases (and subsequently all schemas and tables) created in the account have no retention period by default; however, this default can be overridden at any time for any database, schema, or table
Which languages does Snowflake support for writing UDFs (User-Defined Functions)?
- Python
- JS
- Java
- SQL
- Scala
What options are available for data transformation while loading data into a table using the COPY command?
Snowflake supports transforming data while loading it into a table using the COPY command. Options include:
- Column reordering
- Column omission
- Casts
- Truncating text strings that exceed the target column length
What is the purpose of option LOAD_UNCERTAIN_FILES
Boolean that specifies to load files for which the load status is unknown. The COPY command skips these files by default.
The load status is unknown if all of the following conditions are true:
- The file’s LAST_MODIFIED date (i.e. date when the file was staged) is older than 64 days.
- The initial set of data was loaded into the table more than 64 days earlier.
- If the file was already loaded successfully into the table, this event occurred more than 64 days earlier.
To force the COPY command to load all files regardless of whether the load status is known, use the FORCE option instead.
What are the supported file formats for data unloading in Snowflake?
Currently, only JSON and Parquet file formats are supported for data unloading.
Other formats are not supported at this time. However,other formats are supported for data loading.
Dynamic Data Masking is supported in which version
Dynamic Data Masking features require Enterprise Edition (or higher).
Which systems function can help find the overlap depth of a table’s micro-partitions?
SYSTEM$CLUSTERING_DEPTH
SYSTEM$CLUSTERING_INFORMATION
In what situations should you consider User-Managed Tasks over Serverless Tasks?
User-managed Tasks is recommended when you can fully utilize a single warehouse by scheduling multiple concurrent tasks to take advantage of available compute resources. Also, recommended when adherence to the schedule interval is less critical.
In what situations should you consider Serverless Tasks over User-Managed Tasks ?
Serverless Tasks is recommended when you cannot fully utilize a warehouse because too few tasks run concurrently or they run to completion quickly (in less than 1 minute).
Also, recommended when adherence to the schedule interval is critical.
The data objects stored by Snowflake are not directly visible nor accessible by customers; they are only accessible through SQL query operations run using Snowflake. (True/False)
True
The data objects stored by Snowflake are not directly visible nor accessible by customers; they are only accessible through SQL query operations run using Snowflake.
Snowflake Query history page allows you to view the details of all the queries executed in the last 31 days
(True/False)
False
Snowflake Query history page allows you to view the details of all the queries executed in the last 14 days.
At what frequency does Snowflake rotate the object keys?
30 Days
All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created.
Which SQL command determines whether a network policy is set on the account or for a specific user
SHOW PARAMETERS
Which database objects can be shared using the Snowflake Secure Data Sharing feature?
The following Snowflake database objects can be shared:
- Tables
- External tables
- Secure views
- Secure materialized views
- Secure UDFs
A user cannot view the result set from a query that another user executed except for the ACCOUNTADMIN role.
(True / False)
False
A user cannot view the result set from a query that another user executed. Even a user with the ACCOUNTADMIN role cannot view the results for a query run by another user.
