Summer Sale- Special Discount Limited Time 65% Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Snowflake COF-C02 SnowPro Core Certification Exam Exam Practice Test

Page: 1 / 89
Total 893 questions

SnowPro Core Certification Exam Questions and Answers

Question 1

What is the relationship between a Query Profile and a virtual warehouse?

Options:

A.

A Query Profile can help users right-size virtual warehouses.

B.

A Query Profile defines the hardware specifications of the virtual warehouse.

C.

A Query Profile can help determine the number of virtual warehouses available.

D.

A Query Profile automatically scales the virtual warehouse based on the query complexity.

Question 2

What step can reduce data spilling in Snowflake?

Options:

A.

Using a larger virtual warehouse

B.

Increasing the virtual warehouse maximum timeout limit

C.

Increasing the amount of remote storage for the virtual warehouse

D.

Using a common table expression (CTE) instead of a temporary table

Question 3

What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?

Options:

A.

FLATTEN

B.

GET_PATH

C.

CHECK_JSON

D.

PARSE JSON

Question 4

What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?

Options:

A.

Standard Edition

B.

Enterprise Edition

C.

Business Critical Edition

D.

Virtual Private Snowflake Edition

Question 5

What is the purpose of the Snowflake SPLIT TO_TABLE function?

Options:

A.

To count the number of characters in a string

B.

To split a string into an array of sub-strings

C.

To split a string and flatten the results into rows

D.

To split a string and flatten the results into columns

Question 6

NO: 504

When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?

Options:

A.

File URL

B.

Scoped URL

C.

Relative URL

D.

Pre-Signed URL

Question 7

A permanent table and temporary table have the same name, TBL1, in a schema.

What will happen if a user executes select * from TBL1 ;?

Options:

A.

The temporary table will take precedence over the permanent table.

B.

The permanent table will take precedence over the temporary table.

C.

An error will say there cannot be two tables with the same name in a schema.

D.

The table that was created most recently will take precedence over the older table.

Question 8

Which command is used to start configuring Snowflake for Single Sign-On (SSO)?

Options:

A.

CREATE SESSION POLICY

B.

CREATE NETWORK RULE

C.

CREATE SECURITY INTEGRATION

D.

CREATE PASSWORD POLICY

Question 9

What transformations are supported when loading data into a table using the COPY INTO

command? (Select TWO).

Options:

A.

Column reordering

B.

Column omission

C.

JOIN function

D.

FLATTEN function

E.

GROUP BY function

Question 10

What does a masking policy consist of in Snowflake?

Options:

A.

A single data type, with one or more conditions, and one or more masking functions

B.

A single data type, with only one condition, and only one masking function

C.

Multiple data types, with only one condition, and one or more masking functions

D.

Multiple data types, with one or more conditions, and one or more masking functions

Question 11

What does a Notify & Suspend action for a resource monitor do?

Options:

A.

Send an alert notification to all account users who have notifications enabled.

B.

Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.

C.

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.

D.

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.

Question 12

What does the LATERAL modifier for the FLATTEN function do?

Options:

A.

Casts the values of the flattened data

B.

Extracts the path of the flattened data

C.

Joins information outside the object with the flattened data

D.

Retrieves a single instance of a repeating element in the flattened data

Question 13

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

Options:

A.

CREATE TABLE LIKE TABLE_A;

B.

CREATE VIEW AS SELECT * FROM TABLE_A;

C.

CREATE TABLE AS SELECT * FROM TABLE_A;

D.

CREATE MATERIALIZED VIEW AS SELECT * FROM TABLE A;

Question 14

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

Options:

A.

Warehouses that are multi-cluster can have nodes of different sizes.

B.

Warehouses can be started and stopped at any time.

C.

Warehouses can be resized at any time, even while running.

D.

Warehouses are billed on a per-minute usage basis.

E.

Warehouses can only be used for querying and cannot be used for data loading.

Question 15

Which Snowflake command can be used to unload the result of a query to a single file?

Options:

A.

Use COPY INTO followed by a GET command to download the file.

B.

Use COPY INTO followed by a put command to download the file.

C.

Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.

D.

Use COPY INTO with SINGLE = TRUE followed by a PUT command to download the file.

Question 16

How can a Snowflake user validate data that is unloaded using the COPY INTO command?

Options:

A.

Load the data into a CSV file.

B.

Load the data into a relational table.

C.

Use the VALlDATlON_MODE - SQL statement.

D.

Use the validation mode = return rows statement.

Question 17

A Snowflake account has activated federated authentication.

What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

Options:

A.

The user will be unable to enter a password.

B.

The user will encounter an error, and will not be able to log in.

C.

The user will be able to log into Snowflake successfully.

D.

After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

Question 18

What tasks can an account administrator perform in the Data Exchange? (Select TWO).

Options:

A.

Add and remove members.

B.

Delete data categories.

C.

Approve and deny listing approval requests.

D.

Transfer listing ownership.

E.

Transfer ownership of a provider profile.

Question 19

What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

Options:

A.

Access control

B.

Fail-safe

C.

Network policies

D.

Time Travel

Question 20

Which data types can be used in Snowflake to store semi-structured data? (Select TWO)

Options:

A.

ARRAY

B.

BLOB

C.

CLOB

D.

JSON

E.

VARIANT

Question 21

What factors impact storage costs in Snowflake? (Select TWO).

Options:

A.

The account type

B.

The storage file format

C.

The cloud region used by the account

D.

The type of data being stored

E.

The cloud platform being used

Question 22

What will prevent unauthorized access to a Snowflake account from an unknown source?

Options:

A.

Network policy

B.

End-to-end encryption

C.

Multi-Factor Authentication (MFA)

D.

Role-Based Access Control (RBAC)

Question 23

A column named "Data" contains VARIANT data and stores values as follows:

Question # 23

How will Snowflake extract the employee's name from the column data?

Options:

A.

Data:employee.name

B.

DATA:employee.name

C.

data:Employee.name

D.

data:employee.name

Question 24

Which Snowflake view is used to support compliance auditing?

Options:

A.

ACCESS_HISTORY

B.

COPY_HISTORY

C.

QUERY_HISTORY

D.

ROW ACCESS POLICIES

Question 25

What is a directory table in Snowflake?

Options:

A.

A separate database object that is used to store file-level metadata

B.

An object layered on a stage that is used to store file-level metadata

C.

A database object with grantable privileges for unstructured data tasks

D.

A Snowflake table specifically designed for storing unstructured files

Question 26

How can a dropped internal stage be restored?

Options:

A.

Enable Time Travel.

B.

Clone the dropped stage.

C.

Execute the UNDROP command.

D.

Recreate the dropped stage.

Question 27

What is the purpose of a Query Profile?

Options:

A.

To profile how many times a particular query was executed and analyze its u^age statistics over time.

B.

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

C.

To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

D.

To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

Question 28

What information is found within the Statistic output in the Query Profile Overview?

Options:

A.

Operator tree

B.

Table pruning

C.

Most expensive nodes

D.

Nodes by execution time

Question 29

A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.

How can this be achieved?

Options:

A.

Flatten the data and store it in structured data types in a flattened table. Query the table.

B.

Store the data in a table with a variant data type. Query the table.

C.

Store the data in a table with a vai : ant data type and include STRIP_NULL_VALUES while loading the table. Query the table.

D.

Store the data in an external stage and create views on top of it. Query the views.

Question 30

Which Snowflake function will parse a JSON-null into a SQL-null?

Options:

A.

TO_CHAR

B.

TO_VARIANT

C.

TO_VARCHAR

D.

STRIP NULL VALUE

Question 31

What type of query will benefit from the query acceleration service?

Options:

A.

Queries without filters or aggregation

B.

Queries with large scans and selective filters

C.

Queries where the GROUP BY has high cardinality

D.

Queries of tables that have search optimization service enabled

Question 32

What is the primary purpose of a directory table in Snowflake?

Options:

A.

To store actual data from external stages

B.

To automatically expire file URLs for security

C.

To manage user privileges and access control

D.

To store file-level metadata about data files in a stage

Question 33

How can a Snowflake user traverse semi-structured data?

Options:

A.

Insert a colon (:) between the VARIANT column name and any first-level element.

B.

Insert a colon (:) between the VARIANT column name and any second-level element. C. Insert a double colon (: :) between the VARIANT column name and any first-level element.

C.

Insert a double colon (: :) between the VARIANT column name and any second-level element.

Question 34

For which use cases is running a virtual warehouse required? (Select TWO).

Options:

A.

When creating a table

B.

When loading data into a table

C.

When unloading data from a table

D.

When executing a show command

E.

When executing a list command

Question 35

Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?

Options:

A.

USAGE_VIEWER

B.

GOVERNANCE_VIEWER

C.

OBJECT_VIEWER

D.

SECURITY_VIEWER

Question 36

What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?

Options:

A.

Data Replication

B.

Secure Data Sharing

C.

Data Exchange

D.

Snowflake Marketplace

Question 37

What happens when a Snowflake user changes the data retention period at the schema level?

Options:

A.

All child objects will retain data for the new retention period.

B.

All child objects that do not have an explicit retention period will automatically inherit the new retention period.

C.

All child objects with an explicit retention period will be overridden with the new retention period.

D.

All explicit child object retention periods will remain unchanged.

Question 38

TION NO: 521

Who can grant object privileges in a regular schema?

Options:

A.

Object owner

B.

Schema owner

C.

Database owner

D.

SYSADMIN

Question 39

What can a Snowflake user do in the Activity section in Snowsight?

Options:

A.

Create dashboards.

B.

Write and run SQL queries.

C.

Explore databases and objects.

D.

Explore executed query performance.

Question 40

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

Options:

A.

The clone always stays in sync with the original table.

B.

The clone has better query performance.

C.

The clone is created almost instantly.

D.

The clone will have time travel history from the original table.

E.

The clone saves space by not duplicating storage.

Question 41

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Options:

A.

CHECK_OPTION

B.

IS_SECURE

C.

IS_UPDATEABLE

D.

TABLE_NAME

Question 42

Which of the following describes the Snowflake Cloud Services layer?

Options:

A.

Coordinates activities in the Snowflake account

B.

Executes queries submitted by the Snowflake account users

C.

Manages quotas on the Snowflake account storage

D.

Manages the virtual warehouse cache to speed up queries

Question 43

What is the recommended way to change the existing file format type in my format from CSV to JSON?

Options:

A.

ALTER FILE FORMAT my_format SET TYPE=JSON;

B.

ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

C.

CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

D.

REPLACE FILE FORMAT my format TYPE-JSON;

Question 44

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?

Options:

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.

Question 45

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

Options:

A.

SHOW GRANTS ON ROLE DATA_SCIENCE

B.

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

C.

SHOW GRANTS TO USER INQUISITIVE_PERSON

D.

SHOW GRANTS OF ROLE DATA_SCIENCE

Question 46

What file formats does Snowflake support for loading semi-structured data? (Choose three.)

Options:

A.

TSV

B.

JSON

C.

PDF

D.

Avro

E.

Parquet

F.

JPEG

Question 47

Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).

Options:

A.

Security

B.

Data storage

C.

Data visualization

D.

Query computation

E.

Metadata management

Question 48

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

Options:

A.

Query execution

B.

Data loading

C.

Time Travel data

D.

Security

E.

Authentication and access control

Question 49

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

Options:

A.

Bytes spilled to local cache.

B.

Bytes spilled to local storage.

C.

Bytes spilled to remote cache.

D.

Bytes spilled to remote storage.

E.

Bytes spilled to remote metastore.

Question 50

What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

Options:

A.

Duo Security

B.

OAuth

C.

Okta

D.

Single Sign-On (SSO)

Question 51

What is the MAXIMUM Time Travel retention period for a transient table?

Options:

A.

O days

B.

1 day

C.

7 days

D.

90 days

Question 52

How would a user run a multi-cluster warehouse in maximized mode?

Options:

A.

Configure the maximum clusters setting to "Maximum."

B.

Turn on the additional clusters manually after starting the warehouse.

C.

Set the minimum Clusters and maximum Clusters settings to the same value.

D.

Set the minimum clusters and maximum clusters settings to different values.

Question 53

What is the recommended compressed file size range for continuous data loads using Snowpipe?

Options:

A.

8-16 MB

B.

16-24 MB

C.

10-99 MB

D.

100-250 MB

Question 54

Which of the following are characteristics of security in Snowflake?

Options:

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.

Question 55

Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Options:

A.

Cloud services layer

B.

Compute layer

C.

Storage layer

D.

Cloud agnostic layer

Question 56

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

Options:

A.

No virtual warehouse will be used, data will be read from the result cache.

B.

No virtual warehouse will be used, data will be read from the local disk cache.

C.

The default virtual warehouse will be used to read all data.

D.

The virtual warehouse that is defined at the session level will be used to read all data.

Question 57

Which TABLE function helps to convert semi-structured data to a relational representation?

Options:

A.

CHECK_JSON

B.

TO_JSON

C.

FLATTEN

D.

PARSE_JSON

Question 58

By definition, a secure view is exposed only to users with what privilege?

Options:

A.

IMPORT SHARE

B.

OWNERSHIP

C.

REFERENCES

D.

USAGE

Question 59

Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

Options:

A.

Directory

B.

File

C.

Pre-signed

D.

Scoped

Question 60

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?

Options:

A.

READ

B.

OWNERSHIP

C.

USAGK

D.

WRTTF

Question 61

How can a user change which columns are referenced in a view?

Options:

A.

Modify the columns in the underlying table

B.

Use the ALTER VIEW command to update the view

C.

Recreate the view with the required changes

D.

Materialize the view to perform the changes

Question 62

At what levels can a resource monitor be configured? (Select TWO).

Options:

A.

Account

B.

Database

C.

Organization

D.

Schema

E.

Virtual warehouse

Question 63

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"

2. Created a database to hold the share and an extra-small warehouse to query the data

3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

Options:

A.

The reader account will automatically use the Standard edition of Snowflake.

B.

The reader account compute will be billed to the provider account.

C.

The reader account can clone data the provider has shared, but cannot re-share it.

D.

The reader account can create a copy of the shared data using CREATE TABLE AS...

Question 64

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

Options:

A.

Enterprise

B.

Business Critical

C.

Standard

D.

Virtual Private Snowflake

Question 65

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Options:

A.

Grant the OWNERSHIP privilege on the schema.

B.

Grant the OWNERSHIP privilege on the database.

C.

Grant the MANAGE GRANTS global privilege.

D.

Grant ALL privileges on the schema.

Question 66

Which Snowflake edition enables data sharing only through Snowflake Support?

Options:

A.

Virtual Private Snowflake

B.

Business Critical

C.

Enterprise

D.

Standard

Question 67

What happens when a database is cloned?

Options:

A.

It does not retain any privileges granted on the source object.

B.

It replicates all granted privileges on the corresponding source objects.

C.

It replicates all granted privileges on the corresponding child objects.

D.

It replicates all granted privileges on the corresponding child schema objects.

Question 68

Which activities are included in the Cloud Sen/ices layer? (Select TWO).

Options:

A.

Data storage

B.

Dynamic data masking

C.

Partition scanning

D.

User authentication

E.

Infrastructure management

Question 69

Which data type can store more than one type of data structure?

Options:

A.

JSON

B.

BINARY

C.

VARCHAR

D.

VARIANT

Question 70

For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

Options:

A.

10

B.

50

C.

64

D.

256

Question 71

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Question 72

What are benefits of using Snowpark with Snowflake? (Select TWO).

Options:

A.

Snowpark uses a Spark engine to generate optimized SQL query plans.

B.

Snowpark automatically sets up Spark within Snowflake virtual warehouses.

C.

Snowpark does not require that a separate cluster be running outside of Snowflake.

D.

Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.

E.

Snowpark executes as much work as possible in the source databases for all operations including User-Defined Functions (UDFs).

Question 73

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

Options:

A.

CREATE_SHARE on the account

B.

SHARE on databases and schemas

C.

SELECT on tables used by the secure view

D.

REFERENCE_USAGE on databases

Question 74

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

Options:

A.

list @bronzestage;

B.

select * from directory(@bronzestage);

C.

select metadata$filename from @bronzestage;

D.

select * from table(information_schema.stage_directory_file_registration_history(

stage name=>'bronzestage1));

Question 75

Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.

How does Snowflake recommend resolving this issue?

Options:

A.

Scale up the existing warehouse.

B.

Create separate warehouses for each user.

C.

Create separate warehouses for each workload.

D.

Stop loading and querying data at the same time.

Question 76

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

Options:

A.

A directory table is a separate database object.

B.

Directory tables store data file metadata.

C.

A directory table will be automatically added to a stage.

D.

Directory tables do not have their own grantable privileges.

E.

Directory table data can not be refreshed manually.

Question 77

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

Options:

A.

The explain plan output is available graphically.

B.

An explain plan can be used to conduct performance analysis without executing a query.

C.

An explain plan will handle queries with temporary tables and the query profiler will not.

D.

An explain plan's output will display automatic data skew optimization information.

Question 78

How are serverless features billed?

Options:

A.

Per second multiplied by an automatic sizing for the job

B.

Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

C.

Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

D.

Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Question 79

When should a multi-cluster warehouse be used in auto-scaling mode?

Options:

A.

When it is unknown how much compute power is needed

B.

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

C.

If the runtime of the executed query is very slow

D.

When a large number of concurrent queries are run on the same warehouse

Question 80

In the Snowflake access control model, which entity owns an object by default?

Options:

A.

The user who created the object

B.

The SYSADMIN role

C.

Ownership depends on the type of object

D.

The role used to create the object

Question 81

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

Options:

A.

CONTENT

B.

PATH

C.

BYTE_SIZE

D.

INDEX

E.

DATATYPE

Question 82

Where can a user find and review the failed logins of a specific user for the past 30 days?

Options:

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

Question 83

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.

Which diagram indicates a well-clustered table?

Options:

A.

Option A83

B.

Option B83

C.

Option C83

D.

Option D83

Question 84

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

Options:

A.

VIEWS_HISTORY

B.

OBJECT_HISTORY

C.

ACCESS_HISTORY

D.

LOGIN_HISTORY

Question 85

In a Snowflake role hierarchy, what is the top-level role?

Options:

A.

SYSADMIN

B.

ORGADMIN

C.

ACCOUNTADMIN

D.

SECURITYADMIN

Question 86

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Options:

A.

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

B.

Allows a user to import the files in a sequential order

C.

Increases the latency staging and accuracy when loading the data

D.

Allows optimization of parallel operations

Question 87

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options:

A.

Management of metadata

B.

Computing the data

C.

Maintaining Availability Zones

D.

Infrastructure security

E.

Parsing and optimizing queries

Question 88

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

Question # 88

A user needs to extract the dealership information from the JSON.

How can this be accomplished?

Options:

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;

Question 89

Which command can be used to load data files into a Snowflake stage?

Options:

A.

JOIN

B.

COPY INTO

C.

PUT

D.

GET

Question 90

In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?

Options:

A.

When the system has enough load for 2 minutes

B.

When the system has enough load for 6 minutes

C.

When the system has enough load for 8 minutes

D.

When the system has enough load for 10 minutes

Question 91

By default, which Snowflake role is required to create a share?

Options:

A.

ORGADMIN

B.

SECURITYADMIN

C.

SHAREADMIN

D.

ACCOUNTADMIN

Question 92

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

Options:

A.

Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

B.

Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

C.

Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

D.

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

E.

All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

F.

Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Question 93

Which of the following describes a Snowflake stored procedure?

Options:

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.

Question 94

Which Snowflake layer is always leveraged when accessing a query from the result cache?

Options:

A.

Data Storage

B.

Compute

C.

Cloud Services

Question 95

What is the following SQL command used for?

Select * from table(validate(t1, job_id => '_last'));

Options:

A.

To validate external table files in table t1 across all sessions

B.

To validate task SQL statements against table t1 in the last 14 days

C.

To validate a file for errors before it gets executed using a COPY command

D.

To return errors from the last executed COPY command into table t1 in the current session

Question 96

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Options:

A.

Tri-Secret Secure

B.

Time Travel

C.

Fail-safe

D.

Data encryption

E.

External stages

Question 97

Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.

Which SQL command should be used to delete the files?

Options:

A.

PURGE

B.

MODIFY

C.

REMOVE

D.

DELETE

Question 98

When cloning a database, what is cloned with the database? (Choose two.)

Options:

A.

Privileges on the database

B.

Existing child objects within the database

C.

Future child objects within the database

D.

Privileges on the schemas within the database

E.

Only schemas and tables within the database

Question 99

How many days is load history for Snowpipe retained?

Options:

A.

1 day

B.

7 days

C.

14 days

D.

64 days

Question 100

Users are responsible for data storage costs until what occurs?

Options:

A.

Data expires from Time Travel

B.

Data expires from Fail-safe

C.

Data is deleted from a table

D.

Data is truncated from a table

Question 101

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

Options:

A.

30 days

B.

7 days

C.

48 hours

D.

24 hours

Question 102

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Options:

A.

SHOW GRANTS OF ROLE MY_ROLE

B.

SHOW GRANTS TO ROLE MY_ROLE

C.

SHOW GRANTS FOR ROLE MY_ROLE

D.

SHOW GRANTS ON ROLE MY_ROLE

Question 103

Which Snowflake architectural layer is responsible for a query execution plan?

Options:

A.

Compute

B.

Data storage

C.

Cloud services

D.

Cloud provider

Question 104

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Options:

A.

INSERT

B.

PUT

C.

GET

D.

COPY

Question 105

The Snowflake Search Optimization Services supports improved performance of which kind of query?

Options:

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

Question 106

What is the default file size when unloading data from Snowflake using the COPY command?

Options:

A.

5 MB

B.

8 GB

C.

16 MB

D.

32 MB

Question 107

What type of query benefits the MOST from search optimization?

Options:

A.

A query that uses only disjunction (i.e., OR) predicates

B.

A query that includes analytical expressions

C.

A query that uses equality predicates or predicates that use IN

D.

A query that filters on semi-structured data types

Question 108

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

Options:

A.

SELECT SUM (ORDER_AMT) FROM SALES;

B.

SELECT AVG(ORDER_QTY) FROM SALES;

C.

SELECT MIN(ORDER_AMT) FROM SALES;

D.

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

Question 109

Network policies can be set at which Snowflake levels? (Choose two.)

Options:

A.

Role

B.

Schema

C.

User

D.

Database

E.

Account

F.

Tables

Question 110

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Options:

A.

Materialized view

B.

Sequence

C.

Secure view

D.

Transient table

E.

Clustered table

Question 111

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

Options:

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.

Question 112

True or False: Snowpipe via REST API can only reference External Stages as source.

Options:

A.

True

B.

False

Question 113

If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

Options:

A.

4

B.

8

C.

16

D.

32

Question 114

A virtual warehouse is created using the following command:

Create warehouse my_WH with

warehouse_size = MEDIUM

min_cluster_count = 1

max_cluster_count = 1

auto_suspend = 60

auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

Question # 114

What action should be taken to address this situation?

Options:

A.

Increase the warehouse size from Medium to 2XL.

B.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C.

Configure the warehouse to a multi-cluster warehouse.

D.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Question 115

Which command should be used to unload all the rows from a table into one or more files in a named stage?

Options:

A.

COPY INTO

B.

GET

C.

INSERT INTO

D.

PUT

Question 116

What is the MINIMUM permission needed to access a file URL from an external stage?

Options:

A.

MODIFY

B.

READ

C.

SELECT

D.

USAGE

Question 117

What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?

Options:

A.

1 minutes

B.

5 minutes

C.

10 minutes

D.

15 minutes

Question 118

For Directory tables, what stage allows for automatic refreshing of metadata?

Options:

A.

User stage

B.

Table stage

C.

Named internal stage

D.

Named external stage

Question 119

Which SQL command can be used to verify the privileges that are granted to a role?

Options:

A.

SHOW GRANTS ON ROLE

B.

SHOW ROLES

C.

SHOW GRANTS TO ROLE

D.

SHOW GRANTS FOR ROLE

Question 120

Which privilege is required to use the search optimization service in Snowflake?

Options:

A.

GRANT SEARCH OPTIMIZATION ON SCHEMA TO ROLE

B.

GRANT SEARCH OPTIMIZATION ON DATABASE TO ROLE

C.

GRANT ADD SEARCH OPTIMIZATION ON SCHEMA TO ROLE

D.

GRANT ADD SEARCH OPTIMIZATION ON DATABASE TO ROLE

Question 121

The VALIDATE table function has which parameter as an input argument for a Snowflake user?

Options:

A.

Last_QUERY_ID

B.

CURRENT_STATEMENT

C.

UUID_STRING

D.

JOB_ID

Question 122

When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?

Options:

A.

1 hour

B.

2 hours

C.

4 hours

D.

8 hours

Question 123

The effects of query pruning can be observed by evaluating which statistics? (Select TWO).

Options:

A.

Partitions scanned

B.

Partitions total

C.

Bytes scanned

D.

Bytes read from result

E.

Bytes written

Question 124

What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?

Options:

A.

0 days

B.

1 day

C.

7 days

D.

14 days

Question 125

Which function will provide the proxy information needed to protect Snowsight?

Options:

A.

SYSTEMADMIN_TAG

B.

SYSTEM$GET_PRIVATELINK

C.

SYSTEMSALLONTLIST

D.

SYSTEMAUTHORIZE

Question 126

Which data types optimally store semi-structured data? (Select TWO).

Options:

A.

ARRAY

B.

CHARACTER

C.

STRING

D.

VARCHAR

E.

VARIANT

Question 127

How does Snowflake describe its unique architecture?

Options:

A.

A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)

B.

A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)

C.

A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)

D.

A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)

Question 128

What are characteristic of Snowsight worksheet? (Select TWO.)

Options:

A.

Worksheets can be grouped under folder, and a folder of folders.

B.

Each worksheet is a unique Snowflake session.

C.

Users are limited to running only one on a worksheet.

D.

The Snowflake session ends when a user switches worksheets.

E.

Users can import worksheets and share them with other users.

Question 129

When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

Options:

A.

There are multiple SOL UDFs with the same names and the same number of arguments.

B.

There are multiple SQL UDFs with the same names and the same number of argument types.

C.

There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

D.

There are multiple SQL UDFs with different names but the same number of arguments or argument types.

Question 130

Which common query problems are identified by the Query Profile? (Select TWO.)

Options:

A.

Syntax error

B.

Inefficient pruning

C.

Ambiguous column names

D.

Queries too large to fit in memory

E.

Object does not exist or not authorized

Question 131

What does the TableScan operator represent in the Query Profile?

Options:

A.

The access to a single table

B.

The access to data stored in stage objects

C.

The list of values provided with the VALUES clause

D.

The records generated using the TABLE (GENERATOR (...)) construct

Question 132

What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

Options:

A.

GROUP BY

B.

LIMIT

C.

ORDER BY

D.

PARTITION BY

E.

UNION ALL

Question 133

How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

Options:

A.

Use the SHOW STAGES command.

B.

Use the DESCRIBE STAGE command.

C.

Use the GET_ABSOLUTE_PATH function.

D.

Use the GET_STAGE_LOCATION function.

Question 134

Which activities are included in the Cloud Services layer? {Select TWO).

Options:

A.

Data storage

B.

Dynamic data masking

C.

Partition scanning

D.

User authentication

E.

Infrastructure management

Question 135

A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.

How will those object names be resolved during execution?

Options:

A.

Snowflake will resolve them according to the SEARCH_PATH parameter.

B.

Snowflake will only check the schema the UDF belongs to.

C.

Snowflake will first check the current schema, and then the schema the previous query used

D.

Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

Question 136

A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.

What should they do?

Options:

A.

Use the SECURITYADMIN role.

B.

Use the SYSADMIN role.

C.

Use the USERADMIN role.

D.

Contact Snowflake Support.

Question 137

A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?

Options:

A.

Grant the additional privileges to a custom role.

B.

Grant the additional privileges to the ACCOUNTADMIN role.

C.

Grant the additional privileges to the SYSADMIN role.

D.

Grant the additional privileges to the ORGADMIN role.

Question 138

What is the Fail-safe retention period for transient and temporary tables?

Options:

A.

0 days

B.

1 day

C.

7 days

D.

90 days

Question 139

User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.

What will happen if User2 tries to access the query history?

Options:

A.

If User2 has the sysadmin role they will be able to see the results.

B.

If User2 has the securityadmin role they will be able to see the results.

C.

If User2 has the ACCOUNTADMIN role they will be able to see the results.

D.

User2 will be unable to view the result set of the query executed by User1.

Question 140

How can a user get the MOST detailed information about individual table storage details in Snowflake?

Options:

A.

SHOW TABLES command

B.

SHOW EXTERNAL TABLES command

C.

TABLES view

D.

TABLE STORAGE METRICS view

Question 141

When unloading data, which file format preserves the data values for floating-point number columns?

Options:

A.

Avro

B.

CSV

C.

JSON

D.

Parquet

Question 142

What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

Options:

A.

Temporary table

B.

External table

C.

Secure view

D.

Materialized view

Question 143

How are network policies defined in Snowflake?

Options:

A.

They are a set of rules that define the network routes within Snowflake.

B.

They are a set of rules that dictate how Snowflake accounts can be used between multiple users.

C.

They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.

D.

They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect

to Snowflake.

Question 144

What will happen if a Snowflake user increases the size of a suspended virtual warehouse?

Options:

A.

The provisioning of new compute resources for the warehouse will begin immediately.

B.

The warehouse will remain suspended but new resources will be added to the query acceleration service.

C.

The provisioning of additional compute resources will be in effect when the warehouse is next resumed.

D.

The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.

Question 145

By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Question 146

While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).

Options:

A.

BINARY

B.

GEOGRAPHY

C.

GEOMETRY

D.

OBJECT

E.

VARIANT

Question 147

Which statement accurately describes Snowflake's architecture?

Options:

A.

It uses a local data repository for all compute nodes in the platform.

B.

It is a blend of shared-disk and shared-everything database architectures.

C.

It is a hybrid of traditional shared-disk and shared-nothing database architectures.

D.

It reorganizes loaded data into internal optimized, compressed, and row-based format.

Question 148

What is the only supported character set for loading and unloading data from all supported file formats?

Options:

A.

UTF-8

B.

UTF-16

C.

ISO-8859-1

D.

WINDOWS-1253

Question 149

What are characteristics of transient tables in Snowflake? (Select TWO).

Options:

A.

Transient tables have a Fail-safe period of 7 days.

B.

Transient tables can be cloned to permanent tables.

C.

Transient tables persist until they are explicitly dropped.

D.

Transient tables can be altered to make them permanent tables.

E.

Transient tables have Time Travel retention periods of 0 or 1 day.

Question 150

How does Snowflake reorganize data when it is loaded? (Select TWO).

Options:

A.

Binary format

B.

Columnar format

C.

Compressed format

D.

Raw format

E.

Zipped format

Question 151

What are characteristics of reader accounts in Snowflake? (Select TWO).

Options:

A.

Reader account users cannot add new data to the account.

B.

Reader account users can share data to other reader accounts.

C.

A single reader account can consume data from multiple provider accounts.

D.

Data consumers are responsible for reader account setup and data usage costs.

E.

Reader accounts enable data consumers to access and query data shared by the provider.

Question 152

Which function should be used to insert JSON format string data inot a VARIANT field?

Options:

A.

FLATTEN

B.

CHECK_JSON

C.

PARSE_JSON

D.

TO_VARIANT

Question 153

Question # 153

What do these Query Profile metrics indicate about the query micro-partition pruning?

Options:

A.

No micro-partitions were pruned during execution.

B.

The query used the local disk cache and pruning was not required.

C.

The size of the data queried was too small to trigger micro-partition pruning.

D.

Since the bytes scanned is less than the bytes written to results some pruning has occurred.

Question 154

A Snowflake user accidentally deleted a table. The table no longer exists, but the session is within the data retention period. How can the table be restored using the LEAST amount of operational overhead?

Options:

A.

Clone the table schema as it existed before the table was dropped.

B.

Clone the database as it existed before the table was dropped.

C.

Recreate the table and reload the data.

D.

Run the UNDROP command against the table.

Question 155

Which object type is granted permissions for reading a table?

Options:

A.

User

B.

Role

C.

Attribute

D.

Schema

Question 156

How does the search optimization service help Snowflake users improve query performance?

Options:

A.

It scans the micro-partitions based on the joins used in the queries and scans only join columns.

B.

II maintains a persistent data structure that keeps track of the values of the table's columns m each of its micro-partitions.

C.

It scans the local disk cache to avoid scans on the tables used in the Query.

D.

It keeps track of running queries and their results and saves those extra scans on the table.

Question 157

How can a 5 GB table be downloaded into a single file MOST efficiently?

Options:

A.

Keep the default MAX_FILE_SIZE to 16 MB

B.

Set the default MAX_FILE_SI2E to 5 GB.

C.

Set the SINGLE parameter to TRUE.

D.

Use a regular expression in the stage specifications of the COPY command.

Question 158

Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?

Options:

A.

Directory table

B.

Temporary table

C.

Transient table

D.

A table with a materialized view

Question 159

When used with the UNLOAD command, which parameter specifies the destination of unloaded data?

Options:

A.

COPY INTO

B.

COPY INTO

C.

GET

D.

PUT

Question 160

Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)

Options:

A.

Range searches

B.

Equality searches

C.

Substring searches

D.

Queries with IN predicates

E.

Queries with aggregation

Question 161

What kind of value does a User-Defined Function (UDF) return? (Select TWO).

Options:

A.

Dictionary

B.

List

C.

Object

D.

Scalar

E.

Tabular

Question 162

Which Snowsight feature can be used to perform data manipulations and transformations using a programming language?

Options:

A.

SnowSQL

B.

Dashboards

C.

Python worksheets

D.

Provider Studio

Question 163

Which Snowflake objects use storage? (Select TWO)

Options:

A.

Regular table

B.

Regular view

C.

Cached query result

D.

Materialized view

E.

External table

Question 164

Awarding a user which privileges on all virtual warehouses is equivalent to granting the user the global MANAGE WAREHOUSES privilege?

Options:

A.

MODIFY, MONITOR and OPERATE privileges

B.

ownership and usage privileges

C.

APPLYBUDGET and audit privileges

D.

MANAGE LISTING ADTOTOLFillment and resolve all privileges

Question 165

A Snowflake table that is loaded using a Kafka connector has a schema consisting of which two variant columns? (Select TWO).

Options:

A.

RECORD_TIMESTAMP

B.

RECORD_CONTENT

C.

RECORDKEY

D.

RECORD_SESSION

E.

RECORD_METADATA

Question 166

What does Snowflake recommend as a best practice for using secure views?

Options:

A.

Use sequence-gen era ted values

B.

Programmatically reveal the identifiers.

C.

Use secure views solely for query convenience.

D.

Do not expose the sequence-generated column(s)

Question 167

Which views are included in the data_sharing_usage schema? (Select TWO).

Options:

A.

ACCESS_HISTORY

B.

DATA_TRANSFER_HISTORY

C.

WAREHOUSE_METERING_HISTORY

D.

MONETIZED_USAGE_DAILY

E.

LISTING TELEMETRY DAILY

Question 168

Secured Data Sharing is allowed for which Snowflake database objects? (Select TWO).

Options:

A.

Tables

B.

User-Defined Table Functions (UDTFs)

C.

Secure views

D.

Stored procedures

E.

Worksheets

Question 169

Which Snowflake objects can be restored using Time Travel? (Select VNO).

Options:

A.

Roles

B.

Users

C.

Databases

D.

Schemas

E.

Virtual warehouses

Question 170

Which table function is used to perform additional processing on the results of a previously-run query?

Options:

A.

QUERY_HISTORY

B.

RESULT_SCAN

C.

DESCRIBE_RESULTS

D.

QUERY HISTORY BY SESSION

Question 171

In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?

Options:

A.

READ

B.

REFERENCES

C.

REFERENCEJJSAGE

D.

USAGE

Question 172

Which categories are included in the execution time summary in a Query Profile? (Select TWO).

Options:

A.

Pruning

B.

Spilling

C.

Initialization

D.

Local Disk I/O

E.

Percentage of data read from cache

Question 173

While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).

Options:

A.

GET

B.

CREATE STAGE

C.

PUT

D.

COPY INTO

E.

CREATE PIPE

Question 174

What can a user win a reader account do in Snowflake?

Options:

A.

Load now data

B.

Update existing data

C.

Create a new snare

D.

Query shared data

Question 175

Which JSON paths are considered to be equivalent in Snowflake? (Select TWO).

Options:

A.

Option A175

B.

Option B175

C.

Option C175

D.

Option D175

E.

Option E175

Question 176

What does Snowflake recommend for a user assigned the ACCOUNTADMIN role?

Options:

A.

The ACCCUKTMKIN role should be set as tie user's default role.

B.

The user should use federated authentication instead of a password

C.

The user should be required to use Multi-Factor Authentication (MFA).

D.

There should be just one user with the ACCOUNTADMIN role in each Snowflake account.

Question 177

How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?

Options:

A.

ACCESS_HISTORY

B.

LOAD_HISTORY

C.

QUERY_HISTORY

D.

REST EVENT HISTORY

Question 178

A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.

What should the user do?

Options:

A.

Add a clustering key to the table.

B.

Add the search optimization service to the table.

C.

Create a materialized view based on the query.

D.

Enable the query acceleration service for the virtual warehouse.

Question 179

Who can access the data published in a Data Exchange?

Options:

A.

Only the data provider who published the data

B.

Any Snowflake user, regardless of their role or permissions

C.

Any user who has been provided with a unique Data Exchange URL

D.

Only the users that the data provider has invited to the Data Exchange

Question 180

Which steps will help optimize query performance? (Select TWO).

Options:

A.

Using the query acceleration service

B.

Clustering a table

C.

Indexing a column

D.

Increasing the size of the micro-partitions

E.

Decreasing the size of the virtual warehouse

Question 181

How does Snowflake recommend defining a clustering key on a high-cardinality column that includes a 15 digit ID numbered column ID_NUMER?

Options:

A.

TRUNC (ID_NUMBER, -6)

B.

TRUNC (ID_NUMBER, 5)

C.

ID_NUMBER*100

D.

TO CHAR(ID_NUMBER)

Question 182

Which table function will identify data that was loaded using COPY INTO

statements and also identify data loaded using Snowpipe?

Options:

A.

DATA_TRANSFER_HISTORY

B.

PIPE_USAGE_HISTORY

C.

VALIDATE_PIPE_LOAD

D.

COPY_HISTORY

commands and automated data loading through Snowpipe. This function provides visibility into load operations, making it valuable for monitoring data ingestion, ensuring data integrity, and troubleshooting loading processes.

Question 183

Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?

Options:

A.

ACCESS_HOSTORY

B.

LOGIN_HISTORY

C.

SESSIONS

D.

QUERY HISTORY

Question 184

Which privilege is required for a user to be able to view a resource monitor?

Options:

A.

USAGE

B.

SELECT

C.

MONITOR

D.

OPERATE

Question 185

While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

Options:

A.

MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters

B.

MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters

C.

MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters

D.

MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters

Question 186

Which role is responsible for managing the billing and credit data within Snowflake?

Options:

A.

ORGADMIN

B.

ACCOUNTADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Question 187

A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?

Options:

A.

Source_column.element[1]:name

B.

Source_column.element[0]:name

C.

Source_column.element[1].name

D.

Source_column.element[0]:name

Question 188

Given the statement template below, which database objects can be added to a share?(Select TWO).

GRANT ON To SHARE ;

Options:

A.

Secure functions

B.

Stored procedures

C.

Streams

D.

Tables

E.

Tasks

Question 189

Masking policies are created at what level in Snowflake?

Options:

A.

Table

B.

Column

C.

Schema

D.

Database

Question 190

What object does Snowflake recommend using when planning to unload similarly-formatted data on a regular basis?

Options:

A.

Stream

B.

Task

C.

Storage integration

D.

Named file format

Question 191

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Options:

A.

An FTP server with TLS encryption

B.

An HTTPS server with WebDAV

C.

A Google Cloud storage bucket

D.

A Windows server file share on Azure

Question 192

Which of the following describes how clustering keys work in Snowflake?

Options:

A.

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

B.

Clustering keys sort the designated columns over time, without blocking DML operations

C.

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

D.

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Question 193

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

Options:

A.

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

B.

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

C.

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

D.

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Question 194

In which use cases does Snowflake apply egress charges?

Options:

A.

Data sharing within a specific region

B.

Query result retrieval

C.

Database replication

D.

Loading data into Snowflake

Question 195

What features does Snowflake Time Travel enable?

Options:

A.

Querying data-related objects that were created within the past 365 days

B.

Restoring data-related objects that have been deleted within the past 90 days

C.

Conducting point-in-time analysis for Bl reporting

D.

Analyzing data usage/manipulation over all periods of time

Question 196

Which Snowflake feature is used for both querying and restoring data?

Options:

A.

Cluster keys

B.

Time Travel

C.

Fail-safe

D.

Cloning

Question 197

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

Which statements will provide this access?

Options:

A.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

B.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

C.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

D.

GRANT ROLE MYROLE TO USER USER1;

CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Question 198

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?

Options:

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

Question 199

What are the default Time Travel and Fail-safe retention periods for transient tables?

Options:

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

Question 200

A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

Options:

A.

Query against the result set cache

B.

Query against a virtual warehouse cache

C.

Query against the most-recently created micro-partition

D.

Query against the metadata excite

Question 201

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Options:

A.

Compute layer

B.

Storage layer

C.

Cloud infrastructure layer

D.

Cloud services layer

Question 202

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

Which application will the Snowflake users need to install on their devices in order to connect with MFA?

Options:

A.

Okta Verify

B.

Duo Mobile

C.

Microsoft Authenticator

D.

Google Authenticator

Question 203

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Options:

A.

Pipe

B.

External stage

C.

Task

D.

Stream

Question 204

What is a best practice after creating a custom role?

Options:

A.

Create the custom role using the SYSADMIN role.

B.

Assign the custom role to the SYSADMIN role

C.

Assign the custom role to the PUBLIC role

D.

Add__CUSTOM to all custom role names

Question 205

Which of the following commands cannot be used within a reader account?

Options:

A.

CREATE SHARE

B.

ALTER WAREHOUSE

C.

DROP ROLE

D.

SHOW SCHEMAS

E.

DESCRBE TABLE

Question 206

What is a responsibility of Snowflake's virtual warehouses?

Options:

A.

Infrastructure management

B.

Metadata management

C.

Query execution

D.

Query parsing and optimization

E.

Management of the storage layer

Question 207

What Snowflake role must be granted for a user to create and manage accounts?

Options:

A.

ACCOUNTADMIN

B.

ORGADMIN

C.

SECURITYADMIN

D.

SYSADMIN

Question 208

Which Snowflake technique can be used to improve the performance of a query?

Options:

A.

Clustering

B.

Indexing

C.

Fragmenting

D.

Using INDEX__HINTS

Question 209

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Options:

A.

Customer-managed encryption keys through Tri-Secret Secure

B.

Automatic encryption of all data

C.

Up to 90 days of data recovery through Time Travel

D.

Object-level access control

E.

Column-level security to apply data masking policies to tables and views

Question 210

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Options:

A.

Pipes

B.

Streams

C.

Tasks

D.

D. Procedures

Question 211

What is the minimum Snowflake edition required to create a materialized view?

Options:

A.

Standard Edition

B.

Enterprise Edition

C.

Business Critical Edition

D.

Virtual Private Snowflake Edition

Question 212

Which cache type is used to cache data output from SQL queries?

Options:

A.

Metadata cache

B.

Result cache

C.

Remote cache

D.

Local file cache

Question 213

How often are encryption keys automatically rotated by Snowflake?

Options:

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days

Question 214

What feature can be used to reorganize a very large table on one or more columns?

Options:

A.

Micro-partitions

B.

Clustering keys

C.

Key partitions

D.

Clustered partitions

Question 215

Which of the following are benefits of micro-partitioning? (Select TWO)

Options:

A.

Micro-partitions cannot overlap in their range of values

B.

Micro-partitions are immutable objects that support the use of Time Travel.

C.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

D.

Rows are automatically stored in sorted order within micro-partitions

E.

Micro-partitions can be defined on a schema-by-schema basis

Question 216

What are ways to create and manage data shares in Snowflake? (Select TWO)

Options:

A.

Through the Snowflake web interface (Ul)

B.

Through the DATA_SHARE=TRUE parameter

C.

Through SQL commands

D.

Through the enable__share=true parameter

E.

Using the CREATE SHARE AS SELECT * TABLE command

Question 217

Which command is used to unload data from a Snowflake table into a file in a stage?

Options:

A.

COPY INTO

B.

GET

C.

WRITE

D.

EXTRACT INTO

Question 218

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

Options:

A.

The table contains a column that has very low cardinality

B.

DML statements that are being issued against the table are blocked

C.

The table has a small number of micro-partitions

D.

Queries on the table are running slower than expected

E.

The clustering depth for the table is large

Question 219

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Options:

A.

Compute Credits = 50 Credits Cloud Services = 10

B.

Compute Credits = 80 Credits Cloud Services = 5

C.

Compute Credits = 10 Credits Cloud Services = 9

D.

Compute Credits = 120 Credits Cloud Services = 10

E.

Compute Credits = 200 Credits Cloud Services = 26

Question 220

Which statement about billing applies to Snowflake credits?

Options:

A.

Credits are billed per-minute with a 60-minute minimum

B.

Credits are used to pay for cloud data storage usage

C.

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D.

Credits are consumed based on the warehouse size and the time the warehouse is running

Question 221

What is the default File Format used in the COPY command if one is not specified?

Options:

A.

CSV

B.

JSON

C.

Parquet

D.

XML

Question 222

What is a limitation of a Materialized View?

Options:

A.

A Materialized View cannot support any aggregate functions

B.

A Materialized View can only reference up to two tables

C.

A Materialized View cannot be joined with other tables

D.

A Materialized View cannot be defined with a JOIN

Question 223

UESTION NO: 241

What SQL command would be used to view all roles that were granted to user.1?

Options:

A.

show grants to user USER1;

B.

show grants of user USER1;

C.

describe user USER1;

D.

show grants on user USER1;

Question 224

What happens when a cloned table is replicated to a secondary database? (Select TWO)

Options:

A.

A read-only copy of the cloned tables is stored.

B.

The replication will not be successful.

C.

The physical data is replicated

D.

Additional costs for storage are charged to a secondary account

E.

Metadata pointers to cloned tables are replicated

Question 225

Which of the following objects can be shared through secure data sharing?

Options:

A.

Masking policy

B.

Stored procedure

C.

Task

D.

External table

Question 226

True or False: A Virtual Warehouse can be resized while suspended.

Options:

A.

True

B.

False

Page: 1 / 89
Total 893 questions