SnowPro Core Certification Exam
Last Update Apr 24, 2024
Total Questions : 605
We are offering FREE SnowPro-Core Snowflake exam questions. All you do is to just go and sign up. Give your details, prepare SnowPro-Core free exam questions and then go for complete pool of SnowPro Core Certification Exam test questions that will help you more.
Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
A.
Column compression
B.
Data clustering
C.
Micro-partitioning
D.
Metadata management
Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?
A.
Directory
B.
File
C.
Pre-signed
D.
Scoped
How would a user execute a series of SQL statements using a task?
A.
Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1
WHERE ..
B.
A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS
call stored_proc1(); call stored_proc2();
C.
Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();
D.
Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.
At what levels can a resource monitor be configured? (Select TWO).
A.
Account
B.
Database
C.
Organization
D.
Schema
E.
Virtual warehouse
Resource monitors in Snowflake can be configured at the account and virtual warehouse levels. They are used to track credit usage and control costs associated with running virtual warehouses. When certain thresholds are reached, resource monitors can trigger actions such as sending alerts or suspending warehouses to prevent excessive credit consumption. References: [COF-C02] SnowPro Core Certification Exam Study Guide
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
A.
The data from the permanent table.
B.
The data from the temporary table.
C.
An error stating that the view could not be compiled.
D.
An error stating that the referenced object could not be uniquely identified.
Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).
A.
Security
B.
Data storage
C.
Data visualization
D.
Query computation
E.
Metadata management
The Cloud Services layer in Snowflake is responsible for various services, including security (like authentication and authorization) and metadata management (like query parsing and optimization). References: Based on general cloud architecture knowledge as of 2021.
Network policies can be applied to which of the following Snowflake objects? (Choose two.)
A.
Roles
B.
Databases
C.
Warehouses
D.
Users
E.
Accounts
Network policies in Snowflake can be applied to users and accounts. These policies control inbound access to the Snowflake service and internal stages, allowing or denying access based on the originating network identifiers12.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
Which formats does Snowflake store unstructured data in? (Choose two.)
A.
GeoJSON
B.
Array
C.
XML
D.
Object
E.
BLOB
Snowflake supports storing unstructured data and provides native support for semi-structured file formats such as JSON, Avro, Parquet, ORC, and XML1. GeoJSON, being a type of JSON, and XML are among the formats that can be stored in Snowflake. References: [COF-C02] SnowPro Core Certification Exam Study Guide
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
A.
Table definition
B.
Stage definition
C.
Session level
D.
COPY INTO TABLE statement
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
A.
READ
B.
OWNERSHIP
C.
USAGK
D.
WRTTF
Which of the following are characteristics of security in Snowflake?
A.
Account and user authentication is only available with the Snowflake Business Critical edition.
B.
Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
C.
Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
D.
Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.
The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?
A.
In the metadata of the target table for 14 days
B.
In the metadata of the pipe for 14 days
C.
In the metadata of the target table for 64 days
D.
In the metadata of the pipe for 64 days
Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?
A.
Cross join
B.
Inner join
C.
Natural join
D.
Outer join
What can a Snowflake user do with the information included in the details section of a Query Profile?
A.
Determine the total duration of the query.
B.
Determine the role of the user who ran the query.
C.
Determine the source system that the queried table is from.
D.
Determine if the query was on structured or semi-structured data.
What is the recommended file sizing for data loading using Snowpipe?
A.
A compressed file size greater than 100 MB, and up to 250 MB
B.
A compressed file size greater than 100 GB, and up to 250 GB
C.
A compressed file size greater than 10 MB, and up to 100 MB
D.
A compressed file size greater than 1 GB, and up to 2 GB
Which activities are included in the Cloud Sen/ices layer? (Select TWO).
A.
Data storage
B.
Dynamic data masking
C.
Partition scanning
D.
User authentication
E.
Infrastructure management
The Cloud Services layer in Snowflake includes activities such as user authentication and infrastructure management. This layer coordinates activities across Snowflake, including security enforcement, query compilation and optimization, and more
Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)
A.
NUMBER
B.
OBJECT
C.
STRING
D.
VARCHAR
E.
VARIANT
Snowflake supports semi-structured data types, which include OBJECT and VARIANT. These data types are capable of storing JSON-like data structures, allowing for flexibility in data representation. OBJECT can directly contain VARIANT, and thus indirectly contain any other data type, including itself1.
Which objects together comprise a namespace in Snowflake? (Select TWO).
A.
Account
B.
Database
C.
Schema
D.
Table
E.
Virtual warehouse
In Snowflake, a namespace is comprised of a database and a schema. The combination of a database and schema uniquely identifies database objects within an account
What is cached during a query on a virtual warehouse?
A.
All columns in a micro-partition
B.
Any columns accessed during the query
C.
The columns in the result set of the query
D.
All rows accessed during the query
What is used to diagnose and troubleshoot network connections to Snowflake?
A.
SnowCD
B.
Snowpark
C.
Snowsight
D.
SnowSQL
Which statement MOST accurately describes clustering in Snowflake?
A.
The database ACCOUNTADMIN must define the clustering methodology for each Snowflake table.
B.
Clustering is the way data is grouped together and stored within Snowflake micro-partitions.
C.
The clustering key must be included in the COPY command when loading data into Snowflake.
D.
Clustering can be disabled within a Snowflake account.
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
A.
Cloud services layer
B.
Compute layer
C.
Storage layer
D.
Cloud agnostic layer
Which of the following describes external functions in Snowflake?
A.
They are a type of User-defined Function (UDF).
B.
They contain their own SQL code.
C.
They call code that is stored inside of Snowflake.
D.
They can return multiple rows for each row received
User-level network policies can be created by which of the following roles? (Select TWO).
A.
ROLEADMIN
B.
ACCOUNTADMIN
C.
SYSADMIN
D.
SECURITYADMIN
E.
USERADMIN
User-level network policies in Snowflake can be created by roles with the necessary privileges to manage security and account settings. The ACCOUNTADMIN role has the highest level of privileges across the account, including the ability to manage network policies. The SECURITYADMIN role is specifically responsible for managing security objects within Snowflake, which includes the creation and management of network policies.
References:
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?
A.
A single join node uses more than 50% of the query time
B.
Partitions scanned is equal to partitions total
C.
An AggregateOperacor node is present
D.
The query is spilling to remote storage
What are the default Time Travel and Fail-safe retention periods for transient tables?
A.
Time Travel - 1 day. Fail-safe - 1 day
B.
Time Travel - 0 days. Fail-safe - 1 day
C.
Time Travel - 1 day. Fail-safe - 0 days
D.
Transient tables are retained in neither Fail-safe nor Time Travel
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
A.
Informatica
B.
Power Bl
C.
Adobe
D.
Data Robot
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
A.
True
B.
False
Which statement describes pruning?
A.
The filtering or disregarding of micro-partitions that are not needed to return a query.
B.
The return of micro-partitions values that overlap with each other to reduce a query's runtime.
C.
A service that is handled by the Snowflake Cloud Services layer to optimize caching.
D.
The ability to allow the result of a query to be accessed as if it were a table.
How does a scoped URL expire?
A.
When the data cache clears.
B.
When the persisted query result period ends.
C.
The encoded URL access is permanent.
D.
The length of time is specified in the expiration_time argument.
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?
A.
It removes the last element of the outer array.
B.
It removes the outer array structure and loads the records into separate table rows,
C.
It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns
D.
It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
A.
Via the Snowflake Web Interface (Ul)
B.
Via the data_share=true parameter
C.
Via SQL commands
D.
Via Virtual Warehouses
In Snowflake, Data Shares can be created and managed in two primary ways:
Where can a user find and review the failed logins of a specific user for the past 30 days?
A.
The USERS view in ACCOUNT_USAGE
B.
The LOGIN_HISTORY view in ACCOUNT_USAGE
C.
The ACCESS_HISTORY view in ACCOUNT_USAGE
D.
The SESSIONS view in ACCOUNT_USAGE
How does Snowflake Fail-safe protect data in a permanent table?
A.
Fail-safe makes data available up to 1 day, recoverable by user operations.
B.
Fail-safe makes data available for 7 days, recoverable by user operations.
C.
Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
D.
Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
A.
Schema
B.
View
C.
Internal stage
D.
Table
E.
User
F.
Role
The UNDROP command in Snowflake can be used to directly restore Views and Tables. These objects, when dropped, are moved to a ‘Recycle Bin’ where they can be restored within a time limit before they are permanently deleted. References: [COF-C02] SnowPro Core Certification Exam Study Guide
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
A.
INSERT
B.
PUT
C.
GET
D.
COPY
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
A.
1 second
B.
60 seconds
C.
5 minutes
D.
60 minutes
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
A.
Compute resources
B.
Query execution
C.
Authentication
D.
Data storage
E.
Metadata
The Snowflake Cloud Services layer manages various services, including authentication and metadata management. This layer ties together all the different components of Snowflake to process user requests, manage sessions, and control access3.
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON.
How can this be accomplished?
A.
select src:dealership from car_sales;
B.
select src.dealership from car_sales;
C.
select src:Dealership from car_sales;
D.
select dealership from car_sales;
Which of the following is a data tokenization integration partner?
A.
Protegrity
B.
Tableau
C.
DBeaver
D.
SAP
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
A.
30 days
B.
7 days
C.
48 hours
D.
24 hours
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
A.
UPDATE TABLE FROM STREAM
B.
SELECT FROM STREAM
C.
INSERT INTO TABLE SELECT FROM STREAM
D.
ALTER TABLE AS SELECT FROM STREAM
E.
BEGIN COMMIT
The SQL commands that consume a stream and advance the stream offset are those that result in changes to the data, such as UPDATE and INSERT operations. Specifically, ‘UPDATE TABLE FROM STREAM’ and ‘INSERT INTO TABLE SELECT FROM STREAM’ will consume the stream and move the offset forward, reflecting the changes made to the data.
References: [COF-C02] SnowPro Core Certification Exam Study Guide
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
A.
Data is live, ready-to-query, and can be personalized.
B.
Data needs to be loaded into a cloud provider as a consumer account.
C.
Data is not available for copying or moving to an individual Snowflake account.
D.
Data is available without copying or moving.
E.
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
When leveraging third-party data from the Snowflake Data Marketplace, the data is live, ready-to-query, and can be personalized. Additionally, the data is available without the need for copying or moving it to an individual Snowflake account, allowing for seamless integration with existing data
Which of the following describes a Snowflake stored procedure?
A.
They can be created as secure and hide the underlying metadata from the user.
B.
They can only access tables from a single database.
C.
They can contain only a single SQL statement.
D.
They can be created to run with a caller's rights or an owner's rights.
What is the default file size when unloading data from Snowflake using the COPY command?
A.
5 MB
B.
8 GB
C.
16 MB
D.
32 MB
Network policies can be set at which Snowflake levels? (Choose two.)
A.
Role
B.
Schema
C.
User
D.
Database
E.
Account
F.
Tables
Network policies in Snowflake can be set at the user level and at the account level2.
The Snowflake Search Optimization Services supports improved performance of which kind of query?
A.
Queries against large tables where frequent DML occurs
B.
Queries against tables larger than 1 TB
C.
Selective point lookup queries
D.
Queries against a subset of columns in a table
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)
A.
Amazon Web Services
B.
Docker
C.
IBM Cloud
D.
Microsoft Azure Cloud
E.
Google Cloud Platform
F.
Oracle Cloud
Snowflake supports the use of external stages with Amazon Web Services (AWS), Microsoft Azure Cloud, and Google Cloud Platform (GCP). These platforms allow users to stage data externally and integrate with Snowflake for data loading operations
Which statement is true about running tasks in Snowflake?
A.
A task can be called using a CALL statement to run a set of predefined SQL commands.
B.
A task allows a user to execute a single SQL statement/command using a predefined schedule.
C.
A task allows a user to execute a set of SQL commands on a predefined schedule.
D.
A task can be executed using a SELECT statement to run a predefined SQL command.
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
A.
The Pipe load history is reset to empty.
B.
The REFRESH command is executed.
C.
The stage will be purged.
D.
The destination table is truncated.
A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?
A.
view @my_stage
B.
list @my_stage
C.
show @my_stage
D.
display @my_stage
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)
A.
Row level access policies
B.
Data masking policies
C.
Data encryption
D.
Time Travel
E.
External tokenization
Data encryption and Time Travel are part of Snowflake’s Continuous Data Protection (CDP) feature set that do not require additional configuration. Data encryption is automatically applied to all files stored on internal stages, and Time Travel allows for querying and restoring data without any extra setup
The is the minimum Fail-safe retention time period for transient tables?
A.
1 day
B.
7 days
C.
12 hours
D.
0 days
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)
A.
Use the DROP
B.
Specify the TEMPORARY option when creating the file format.
C.
Specify the PURGE copy option in the COPY INTO
