Black Friday Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

COF-C02 SnowPro Core Certification Exam Questions and Answers

Questions 4

Which type of role can be granted to a share?

Options:

A.

Account role

B.

Custom role

C.

Database role

D.

Secondary role

Buy Now
Questions 5

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

Buy Now
Questions 6

What takes the highest precedence in Snowflake file format options, when specified in multiple locations during data loading?

Options:

A.

The stage definition

B.

The table definition

C.

The use of a copy into

statement

D.

The use of a copy INTO statement

Buy Now
statement take the highest precedence over other locations such as the stage or table definitions. This ensures that any specific settings for a particular load operation are applied correctly.

    File Format Hierarchy:

      Stage Definition: Specifies default file format options for files staged in the location.

      Table Definition: Can specify default file format options associated with the table.

      COPY INTO Statement: Overrides both the stage and table definitions with the file format options specified directly in the statement.

    Example Usage:

COPY INTO my_table

FROM @my_stage

FILE_FORMAT = (FORMAT_NAME = 'my_format' FIELD_OPTIONALLY_ENCLOSED_BY = '"');

References:

    Snowflake Documentation: Copy into Table

    Snowflake Documentation: File Format Options

Questions 7

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

Buy Now
Questions 8

Which statements reflect valid commands when using secondary roles? (Select TWO).

Options:

A.

Use SECONDARY ROLES RESUME

B.

USE SECONDARY ROLES SUSPEND

C.

USE SECONDARY RLES ALL

D.

USE SECONDARY ROLES ADD

E.

Use SECONDARY ROLES NONE

Buy Now
Questions 9

Which governance feature is supported by all Snowflake editions?

Options:

A.

Object tags

B.

Masking policies

C.

Row access policies

D.

OBJECT_DEPENDENCIES View

Buy Now
Questions 10

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

Buy Now
Questions 11

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.

Buy Now
Questions 12

How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

Options:

A.

Set the WAREHOUSES_SIZE to 6XL.

B.

Set the STATEMENT_TIMEOUT_1M_SECOMES to 0.

C.

Set the MAX_CONCURRENCY_LEVEL to a value of 12 or large.

D.

Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

Buy Now
Questions 13

What are type predicates used for?

Options:

A.

Extracting data from a variant column

B.

Casting a value in a variant column to a particular data type

C.

Determining if a value in a variant column is a particular data type

D.

Manipulating objects and arrays in a VARIANT column

Buy Now
Questions 14

In the Data Exchange, who can get or request data from the listings? (Select TWO).

Options:

A.

Users with ACCOUNTADMIN role

B.

Users with sysadmin role

C.

Users with ORGADMIN role

D.

Users with import share privilege

E.

Users with manage grants privilege

Buy Now
Questions 15

Which Snowflake function and command combination should be used to convert rows in a relational table to a single VARIANT column, and unload the rows Into a file in JSON format? (Select TWO).

Options:

A.

PUT

B.

GET

C.

COPY

D.

EXPORT

E.

OBJECT CONSTRUCT

Buy Now
Questions 16

What command is used to export or unload data from Snowflake?

Options:

A.

PUT @mystage

B.

GET @mystage

C.

COPY INTO @mystage

D.

INSERT @mystage

Buy Now
Questions 17

If a virtual warehouse is suspended, what happens to the warehouse cache?

Options:

A.

The cache is dropped when the warehouse is suspended and is no longer available upon restart.

B.

The warehouse cache persists for as long the warehouse exists, regardless of its suspension status.

C.

The cache is maintained for up to two hours and can be restored If the warehouse Is restarted within this limit.

D.

The cache is maintained for the auto suspend duration and can be restored it the warehouse 15 restarted within this limit.

Buy Now
Questions 18

Which object type is granted permissions for reading a table?

Options:

A.

User

B.

Role

C.

Attribute

D.

Schema

Buy Now
Questions 19

Which Snowflake privilege is required on a pipe object to pause or resume pipes?

Options:

A.

OPERATE

B.

READ

C.

SELECT

D.

USAGE

Buy Now
Questions 20

Which system_defined, read-only view display information on column lineage that specifies how data flows from source to target in a SQL write operation?

Options:

A.

ACCESS_HISTORY

B.

LOAD_HOSTORY

C.

QUERY_HISTORY

D.

COPY_HISTORY

Buy Now
Questions 21

When should a stored procedure be created with caller's rights?

Options:

A.

When the caller needs to be prevented from viewing the source code of the stored procedure

B.

When the caller needs to run a statement that could not execute outside of the stored procedure

C.

When the stored procedure needs to run with the privileges of the role that called the stored procedure

D.

When the stored procedure needs to operate on objects that the caller does not have privileges on

Buy Now
Questions 22

Which user preferences can be set for a user profile in Snowsight? (Select TWO).

Options:

A.

Multi-Factor Authentication (MFA)

B.

Default database

C.

Default schema

D.

Notification

E.

Username

Buy Now
Questions 23

What activities can a user with the ORGADMIN role perform? (Select TWO).

Options:

A.

Create information_schema in a database

B.

View usage information for all accounts in the organization.

C.

Enable database cloning for an account in the organization.

D.

Enable database replication for an account in the organization.

E.

View micro-partition information for all accounts in the organization.

Buy Now
Questions 24

Which privilege is needed for a SnowFlake user to see the definition of a secure view?

Options:

A.

OWNERSHIP

B.

MODIFY

C.

CREATE

D.

USAGE

Buy Now
Questions 25

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

Buy Now
Questions 26

What do temporary and transient tables have m common in Snowflake? (Select TWO).

Options:

A.

Both tables have no Fail-safe period.

B.

Both tables have data retention period maximums of one day.

C.

Both tables are visible only to a single user session.

D.

For both tables the retention period ends when the tables are dropped.

E.

For both tables, the retention period does not end when the session ends

Buy Now
Questions 27

When does a materialized view get suspended in Snowflake?

Options:

A.

When a column is added to the base table

B.

When a column is dropped from the base table

C.

When a DML operation is run on the base table

D.

When the base table is reclustered

Buy Now
Questions 28

What objects can be cloned within Snowflake? (Select TWO).

Options:

A.

Schemas

B.

Users

C.

External tables

D.

Internal named stages

E.

External named stages

Buy Now
Questions 29

Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?

Options:

A.

APPROXIMATE_SIMILARITY

B.

JAROWINKLER_SIMILARITY

C.

APPROXIMATE_JACCARD_INDEX

D.

MINHASH COMBINE

Buy Now
Questions 30

Which table function should be used to view details on a Directed Acyclic Graphic (DAG) run that is presently scheduled or is executing?

Options:

A.

TASK_HISTORY

B.

TASK_DEPENDENTS

C.

CURRENT_TASK_GRAPHS

D.

COMPLETE_TASK_GRAPHS

Buy Now
Questions 31

What is the MINIMUM Snowftake edition that supports database replication?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPS)

Buy Now
Questions 32

What best practice recommendations will help prevent timeouts when using the PUT command to load large data sets? (Select TWO).

Options:

A.

Compress the files before loading.

B.

Use a semi-structured file format.

C.

Increase the PARALLEL option value.

D.

Load the data into a table stage.

E.

Enable the overwrite option.

Buy Now
Questions 33

How does Snowflake handle the bulk unloading of data into single or multiple files?

Options:

A.

It assigns each unloaded data file a unique name.

B.

It uses the put command to download the data by default.

C.

It uses COPY INTO for bulk unloading where the default option is SINGLE - TRUE.

D.

It uses COPY INTO to copy the data from a table into one or more files in an external stage only.

Buy Now
Questions 34

Which statement describes pruning?

Options:

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.

Buy Now
Questions 35

How can a user improve the performance of a single large complex query in Snowflake?

Options:

A.

Scale up the virtual warehouse.

B.

Scale out the virtual warehouse.

C.

Enable standard warehouse scaling.

D.

Enable economy warehouse scaling.

Buy Now
Questions 36

Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

Options:

A.

Configure the user to be initially disabled.

B.

Force an immediate password change.

C.

Set a default role for the user.

D.

Set the number of minutes to unlock to 15 minutes.

E.

Set the user's access to expire within a specified timeframe.

Buy Now
Questions 37

How can a data provider ensure that a data consumer is going to have access to the required objects?

Options:

A.

Enable the data sharing feature in the account and validate the view.

B.

Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.

C.

Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.

D.

Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

Buy Now
Questions 38

Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)

Options:

A.

NUMBER

B.

OBJECT

C.

STRING

D.

VARCHAR

E.

VARIANT

Buy Now
Questions 39

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

Buy Now
Questions 40

If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

Options:

A.

1 minute

B.

2 minutes

C.

6 minutes

D.

8 minutes

Buy Now
Questions 41

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

Options:

A.

Schema Stage

B.

User Stage

C.

Database Stage

D.

Table Stage

E.

External Named Stage

F.

Internal Named Stage

Buy Now
Questions 42

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

Options:

A.

SHOW STORAGE BY TABLE;

B.

SHOW TABLES;

C.

Information Schema -> TABLE_HISTORY

D.

Information Schema -> TABLE_FUNCTION

E.

Information Schema -> TABLE_STORAGE_METRICS

Buy Now
Questions 43

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.

Buy Now
Questions 44

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

Options:

A.

Files

B.

External tables

C.

Secure User-Defined Functions (UDFs)

D.

Sequences

E.

Streams

Buy Now
Questions 45

What does Snowflake recommend regarding database object ownership? (Select TWO).

Options:

A.

Create objects with ACCOUNTADMIN and do not reassign ownership.

B.

Create objects with SYSADMIN.

C.

Create objects with SECURITYADMIN to ease granting of privileges later.

D.

Create objects with a custom role and grant this role to SYSADMIN.

E.

Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

Buy Now
Questions 46

Which features make up Snowflake's column level security? (Select TWO).

Options:

A.

Continuous Data Protection (CDP)

B.

Dynamic Data Masking

C.

External Tokenization

D.

Key pair authentication

E.

Row access policies

Buy Now
Questions 47

Which items are considered schema objects in Snowflake? (Select TWO).

Options:

A.

Pipe

B.

File format

C.

Resource monitor

D.

Storage integration

E.

Virtual warehouse

Buy Now
Questions 48

Which of the following can be used when unloading data from Snowflake? (Choose two.)

Options:

A.

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

B.

Use the ENCODING file format option to change the encoding from the default UTF-8.

C.

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

D.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

E.

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

Buy Now
Questions 49

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

Buy Now
Questions 50

Which role has the ability to create and manage users and roles?

Options:

A.

ORGADMIN

B.

USERADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Buy Now
Questions 51

How would a user execute a series of SQL statements using a task?

Options:

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.

Buy Now
Questions 52

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

Buy Now
Questions 53

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

Buy Now
Questions 54

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

Options:

A.

ROW_NUMBER

B.

TABLE

C.

TABULAR

D.

VALUES

Buy Now
Questions 55

Which type of join will list a I rows in the specified table, even if those rows have no match in the other table?

Options:

A.

Cross join

B.

Inner join

C.

Natural join

D.

Outer join

Buy Now
Questions 56

How long can a data consumer who has a pre-signed URL access data files using Snowflake?

Options:

A.

Indefinitely

B.

Until the result_cache expires

C.

Until the retention_time is met

D.

Until the expiration time is exceeded

Buy Now
Questions 57

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

Buy Now
Questions 58

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.

Buy Now
Questions 59

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

Options:

A.

The shared objects are transferred.

B.

The shared objects are copied.

C.

The shared objects become accessible.

D.

The shared objects can be re-shared.

Buy Now
Questions 60

What is the difference between a stored procedure and a User-Defined Function (UDF)?

Options:

A.

Stored procedures can execute database operations while UDFs cannot.

B.

Returning a value is required in a stored procedure while returning values in a UDF is optional.

C.

Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

D.

Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

Buy Now
Questions 61

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Options:

A.

The warehouse size does not change until all queries currently running in the warehouse have completed.

B.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

C.

The warehouse size does not change until the warehouse is suspended and restarted.

D.

It does not return from the command until the warehouse has finished changing its size.

Buy Now
Questions 62

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.

Buy Now
Questions 63

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.

Buy Now
Questions 64

How does a scoped URL expire?

Options:

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.

Buy Now
Questions 65

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

Options:

A.

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

B.

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

C.

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

D.

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Buy Now
Questions 66

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.

Buy Now
Questions 67

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

Buy Now
Questions 68

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.

Buy Now
Questions 69

How should clustering be used to optimize the performance of queries that run on a very large table?

Options:

A.

Manually re-cluster the table regularly.

B.

Choose one high cardinality column as the clustering key.

C.

Use the column that is most-frequently used in query select clauses as the clustering key.

D.

Assess the average table depth to identify how clustering is impacting the query.

Buy Now
Questions 70

Which statements describe benefits of Snowflake's separation of compute and storage? (Select TWO).

Options:

A.

The separation allows independent scaling of computing resources.

B.

The separation ensures consistent data encryption across all virtual data warehouses.

C.

The separation supports automatic conversion of semi-structured data into structured data for advanced data analysis.

D.

Storage volume growth and compute usage growth can be tightly coupled.

E.

Compute can be scaled up or down without the requirement to add more storage.

Buy Now
Questions 71

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

Buy Now
Questions 72

Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

Options:

A.

USERADMIN

B.

ORGADMIN

C.

SYSADMIN

D.

SECURITYADMIN

Buy Now
Questions 73

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.

Buy Now
Questions 74

Which commands can only be executed using SnowSQL? (Select TWO).

Options:

A.

COPY INTO

B.

GET

C.

LIST

D.

PUT

E.

REMOVE

Buy Now
Questions 75

Which Snowflake object does not consume any storage costs?

Options:

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Buy Now
Questions 76

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.

Buy Now
Questions 77

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

Buy Now
Questions 78

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

Buy Now
Questions 79

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

Options:

A.

DATA_RETENTION_TIME_IN_DAYS

B.

MAX_DATA_EXTENSION_TIME_IN_DAYS

C.

MIN_DATA_RETENTION_TIME_IN_DAYS

D.

MAX CONCURRENCY LEVEL

Buy Now
Questions 80

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

Options:

A.

Range of values

B.

Distinct values

C.

Index values

D.

Sorted values

E.

Null values

Buy Now
Questions 81

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

Buy Now
Questions 82

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

Buy Now
Questions 83

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

Buy Now
Questions 84

What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

Options:

A.

It removes null values from all columns in the data.

B.

It converts null values to empty strings during loading.

C.

It skips rows with null values during the loading process.

D.

It removes object or array elements containing null values.

Buy Now
Questions 85

Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?

Options:

A.

Automatic clustering

B.

Materialized views

C.

Query acceleration service

D.

Search optimization service

Buy Now
Questions 86

Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)

Options:

A.

INTEGER

B.

OBJECT

C.

VARIANT

D.

VARCHAR

E.

LIST

Buy Now
Questions 87

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

Buy Now
Questions 88

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).

Options:

A.

Bytes scanned

B.

Partitions scanned

C.

Bytes spilled to local storage

D.

Bytes spilled to remote storage

E.

Percentage scanned from cache

Buy Now
Questions 89

Which operation can be performed on Snowflake external tables?

Options:

A.

INSERT

B.

JOIN

C.

RENAME

D.

ALTER

Buy Now
Questions 90

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.

Buy Now
Questions 91

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.

Buy Now
Questions 92

Which Snowflake feature allows a user to track sensitive data for compliance, discovery, protection, and resource usage?

Options:

A.

Tags

B.

Comments

C.

Internal tokenization

D.

Row access policies

Buy Now
Questions 93

Which Snowflake table objects can be shared with other accounts? (Select TWO).

Options:

A.

Temporary tables

B.

Permanent tables

C.

Transient tables

D.

External tables

E.

User-Defined Table Functions (UDTFs)

Buy Now
Questions 94

Which privilege must be granted by one role to another role, and cannot be revoked?

Options:

A.

MONITOR

B.

OPERATE

C.

OWNERSHIP

D.

ALL

Buy Now
Questions 95

How is unstructured data retrieved from data storage?

Options:

A.

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

B.

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

C.

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

D.

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.

Buy Now
Questions 96

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

Buy Now
Questions 97

When using the ALLOW CLIENT_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

Buy Now
Questions 98

Which object can be used with Secure Data Sharing?

Options:

A.

View

B.

Materialized view

C.

External table

D.

User-Defined Function (UDF)

Buy Now
Questions 99

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

Buy Now
Questions 100

Which commands are restricted in owner's rights stored procedures? (Select TWO).

Options:

A.

SHOW

B.

MERGE

C.

INSERT

D.

DELETE

E.

DESCRIBE

Buy Now
Questions 101

A user with which privileges can create or manage other users in a Snowflake account? (Select TWO).

Options:

A.

GRANT

B.

SELECT

C.

MODIFY

D.

OWNERSHIP

E.

CREATE USER

Buy Now
Questions 102

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

Buy Now
Questions 103

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

Options:

A.

Compute

B.

Data storage

C.

Cloud services

D.

Cloud provider

Buy Now
Questions 104

Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Options:

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Buy Now
Questions 105

Who can grant object privileges in a regular schema?

Options:

A.

Object owner

B.

Schema owner

C.

Database owner

D.

SYSADMIN

Buy Now
Questions 106

Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

Options:

A.

Amazon Web Services

B.

Docker

C.

IBM Cloud

D.

Microsoft Azure Cloud

E.

Google Cloud Platform

F.

Oracle Cloud

Buy Now
Questions 107

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

Options:

A.

Role

B.

Schema

C.

User

D.

Database

E.

Account

F.

Tables

Buy Now
Questions 108

The is the minimum Fail-safe retention time period for transient tables?

Options:

A.

1 day

B.

7 days

C.

12 hours

D.

0 days

Buy Now
Questions 109

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.

Buy Now
Questions 110

What is the minimum Snowflake edition required for row level security?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Buy Now
Questions 111

When loading data into Snowflake, how should the data be organized?

Options:

A.

Into single files with 100-250 MB of compressed data per file

B.

Into single files with 1-100 MB of compressed data per file

C.

Into files of maximum size of 1 GB of compressed data per file

D.

Into files of maximum size of 4 GB of compressed data per file

Buy Now
Questions 112

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

Options:

A.

JOIN

B.

COPY INTO

C.

PUT

D.

GET

Buy Now
Questions 113

The Snowflake Cloud Data Platform is described as having which of the following architectures?

Options:

A.

Shared-disk

B.

Shared-nothing

C.

Multi-cluster shared data

D.

Serverless query engine

Buy Now
Questions 114

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

Options:

A.

Compress the file and load the compressed file.

B.

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

C.

Use a larger-sized warehouse.

D.

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Buy Now
Questions 115

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

Buy Now
Questions 116

Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

Options:

A.

parse_json()

B.

json_extract_path_text()

C.

object_construct()

D.

flatten

Buy Now
Questions 117

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

Buy Now
Questions 118

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

Buy Now
Questions 119

Which minimum Snowflake edition allows for a dedicated metadata store?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Buy Now
Questions 120

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

Options:

A.

4 minutes

B.

10 minutes

C.

14 minutes

D.

24 minutes

Buy Now
Questions 121

How long is the Fail-safe period for temporary and transient tables?

Options:

A.

There is no Fail-safe period for these tables.

B.

1 day

C.

7 days

D.

31 days

E.

90 days

Buy Now
Questions 122

How many days is load history for Snowpipe retained?

Options:

A.

1 day

B.

7 days

C.

14 days

D.

64 days

Buy Now
Questions 123

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

Options:

A.

PUT

B.

GET

C.

COPY

D.

SELECT

Buy Now
Questions 124

Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

Options:

A.

VARIANT

B.

VARRAY

C.

STRUCT

D.

ARRAY

E.

QUEUE

Buy Now
Questions 125

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

Buy Now
Questions 126

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

Buy Now
Questions 127

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

Options:

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

Buy Now
Questions 128

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Options:

A.

Removing a column from the query SELECT list

B.

Stopping the virtual warehouse that the query is running against

C.

Clustering of the data used by the query

D.

Executing the RESULTS_SCAN() table function

E.

Changing a column that is not in the cached query

Buy Now
Questions 129

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

Options:

A.

ORGADMIN

B.

SECURITYADMIN

C.

SHAREADMIN

D.

ACCOUNTADMIN

Buy Now
Questions 130

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

Options:

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.

Buy Now
Questions 131

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

Options:

A.

Custom Edition

B.

Virtual Private Snowflake

C.

Business Critical Edition

D.

Standard Edition

E.

Enterprise Edition

Buy Now
Questions 132

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.

Buy Now
Questions 133

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Options:

A.

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

B.

All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

C.

The ACCOUNTADMIN role must be granted to only one user.

D.

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

E.

All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Buy Now
Questions 134

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

Buy Now
Questions 135

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

Options:

A.

Snowflake leverages a Role-Based Access Control (RBAC) model.

B.

Snowflake requires a user to configure an IAM user to connect to the database.

C.

All data in Snowflake is encrypted.

D.

Snowflake can run within a user's own Virtual Private Cloud (VPC).

E.

All data in Snowflake is compressed.

Buy Now
Questions 136

True or False: Fail-safe can be disabled within a Snowflake account.

Options:

A.

True

B.

False

Buy Now
Questions 137

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

Buy Now
Questions 138

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Options:

A.

External Tokenization

B.

External Tables

C.

Materialized Views

D.

User-Defined Table Functions (UDTF)

Buy Now
Questions 139

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Options:

A.

Informatica

B.

Power Bl

C.

Adobe

D.

Data Robot

Buy Now
Questions 140

The fail-safe retention period is how many days?

Options:

A.

1 day

B.

7 days

C.

45 days

D.

90 days

Buy Now
Questions 141

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

Buy Now
Questions 142

Which stage type can be altered and dropped?

Options:

A.

Database stage

B.

External stage

C.

Table stage

D.

User stage

Buy Now
Questions 143

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

Buy Now
Questions 144

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

Buy Now
Questions 145

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

Buy Now
Questions 146

What is the purpose of an External Function?

Options:

A.

To call code that executes outside of Snowflake

B.

To run a function in another Snowflake database

C.

To share data in Snowflake with external parties

D.

To ingest data from on-premises data sources

Buy Now
Questions 147

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

Buy Now
Questions 148

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

Options:

A.

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME

FROM ACCOUNT_USAGE.USERS;

B.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM table(information_schema.login_history_by_user())

C.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.ACCESS_HISTORY;

D.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Buy Now
Questions 149

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

Buy Now
Questions 150

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

Buy Now
Questions 151

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Options:

A.

Via the Snowflake Web Interface (Ul)

B.

Via the data_share=true parameter

C.

Via SQL commands

D.

Via Virtual Warehouses

Buy Now
Questions 152

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

Buy Now
Questions 153

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Options:

A.

Materialized views

B.

Sequences

C.

Procedures

D.

Tables

E.

Secure User Defined Functions (UDFs)

Buy Now
Questions 154

What are value types that a VARIANT column can store? (Select TWO)

Options:

A.

STRUCT

B.

OBJECT

C.

BINARY

D.

ARRAY

E.

CLOB

Buy Now
Questions 155

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

Options:

A.

Standard

B.

Premium

C.

Enterprise

D.

Business Critical

Questions 156

When unloading to a stage, which of the following is a recommended practice or approach?

Options:

A.

Set SINGLE: = true for larger files

B.

Use OBJECT_CONSTRUCT ( * ) when using Parquet

C.

Avoid the use of the CAST function

D.

Define an individual file format

Buy Now
Questions 157

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

Buy Now
Questions 158

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Options:

A.

True

B.

False

Buy Now
Questions 159

When is the result set cache no longer available? (Select TWO)

Options:

A.

When another warehouse is used to execute the query

B.

When another user executes the query

C.

When the underlying data has changed

D.

When the warehouse used to execute the query is suspended

E.

When it has been 24 hours since the last query

Buy Now
Questions 160

Which copy INTO command outputs the data into one file?

Options:

A.

SINGLE=TRUE

B.

MAX_FILE_NUMBER=1

C.

FILE_NUMBER=1

D.

MULTIPLE=FAISE

Buy Now
Questions 161

What is the recommended file sizing for data loading using Snowpipe?

Options:

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

Buy Now
Questions 162

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

Buy Now
Questions 163

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

Options:

A.

STATEMENT_TIMEOUT__IN__SECONDS

B.

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

C.

MAX_CONCURRENCY__LEVEL

D.

QUERY_TIMEOUT_IN_SECONDS

Buy Now
Questions 164

Will data cached in a warehouse be lost when the warehouse is resized?

Options:

A.

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B.

Yes. because the compute resource is replaced in its entirety with a new compute resource.

C.

No. because the size of the cache is independent from the warehouse size

D.

Yes. became the new compute resource will no longer have access to the cache encryption key

Buy Now
Questions 165

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;

Buy Now
Questions 166

How would you determine the size of the virtual warehouse used for a task?

Options:

A.

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B.

Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C.

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

D.

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Buy Now
Questions 167

What is the default character set used when loading CSV files into Snowflake?

Options:

A.

UTF-8

B.

UTF-16

C.

ISO S859-1

D.

ANSI_X3.A

Buy Now
Questions 168

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

COPY INTO my__table FROM @my__stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same copy into command what will happen?

Options:

A.

All data from all of the files on the stage will be appended to the table

B.

Only data about new customers from the new files will be appended to the table

C.

The operation will fail with the error uncertain files in stage.

D.

All data from only the newly-added files will be appended to the table.

Buy Now
Questions 169

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

Options:

A.

list @mytable;

B.

list @%raytable;

C.

list @ %m.ystage;

D.

list @mystage;

Buy Now
Questions 170

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse

According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Options:

A.

Use multi-clustered warehousing to scale out warehouse capacity.

B.

Scale up the warehouse size to allow Queries to execute faster.

C.

Stop and start the warehouse to clear the queued queries

D.

Migrate some queries to a new warehouse to reduce load

E.

Limit user access to the warehouse so fewer queries are run against it.

Buy Now
Questions 171

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

Buy Now
Questions 172

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

Buy Now
Questions 173

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

Buy Now
Questions 174

What type of function returns one value for each Invocation?

Options:

A.

Aggregate

B.

Scalar

C.

Table

D.

Window

Buy Now
Questions 175

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.

Buy Now
Questions 176

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.

Buy Now
Questions 177

Which role has the ability to create a share from a shared database by default?

Options:

A.

ACCOUNTADMIN

B.

SECURITYADMIN

C.

SYSADMIN

D.

ORGADMIN

Buy Now
Questions 178

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.

Buy Now
Questions 179

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

Buy Now
Questions 180

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

Buy Now
Questions 181

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.

Buy Now
Questions 182

By default, how long is the standard retention period for Time Travel across all Snowflake accounts?

Options:

A.

0 days

B.

1 day

C.

7 days

D.

14 days

Buy Now
Questions 183

Which view can be used to determine if a table has frequent row updates or deletes?

Options:

A.

TABLES

B.

TABLE_STORAGE_METRICS

C.

STORAGE_DAILY_HISTORY

D.

STORAGE USAGE

Buy Now
Questions 184

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

Questions 185

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

Buy Now
Questions 186

If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?

Options:

A.

60

B.

91

C.

120

D.

121

Buy Now
Questions 187

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

Buy Now
Questions 188

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

Buy Now
Questions 189

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

Buy Now
Questions 190

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

Buy Now
Questions 191

What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?

Options:

A.

View

B.

Secure view

C.

Materialized view

D.

External table

Buy Now
Questions 192

Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

Options:

A.

The column name and element names are both case-sensitive.

B.

The column name and element names are both case-insensitive.

C.

The column name is case-sensitive but element names are case-insensitive.

D.

The column name is case-insensitive but element names are case-sensitive.

Buy Now
Questions 193

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

Buy Now
Questions 194

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

Options:

A.

Clone the data from the production account to the non-production account.

B.

Create a data share from the production account to the non-production account.

C.

Create a subscription in the production account and have it publish to the non-production account.

D.

Create a reader account using the production account and link the reader account to the non-production account.

Buy Now
Questions 195

Which Snowflow object does not consume and storage costs?

Options:

A.

Secure view

B.

Materialized view

C.

Temporary table

D.

Transient table

Buy Now
Questions 196

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

Buy Now
Questions 197

What does the worksheet and database explorer feature in Snowsight allow users to do?

Options:

A.

Add or remove users from a worksheet.

B.

Move a worksheet to a folder or a dashboard.

C.

Combine multiple worksheets into a single worksheet.

D.

Tag frequently accessed worksheets for ease of access.

Buy Now
Questions 198

What are the benefits of the replication feature in Snowflake? (Select TWO).

Options:

A.

Disaster recovery

B.

Time Travel

C.

Fail-safe

D.

Database failover and fallback

E.

Data security

Buy Now
Questions 199

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

Buy Now
Questions 200

Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?

Options:

A.

Data classification

B.

Query acceleration service

C.

Search optimization service

D.

Tagging

Buy Now
Questions 201

Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).

Options:

A.

Binary file in Avro

B.

Binary file in Parquet

C.

Comma-separated JSON

D.

Newline Delimited JSON

E.

Plain text file containing XML elements

Buy Now
Questions 202

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

Buy Now
Questions 203

What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?

Options:

A.

Hierarchical key model

B.

Client-side encryption

C.

Tri-secret secure encryption

D.

Key pair authentication

Buy Now
Questions 204

A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

Options:

A.

ARRAY

B.

OBJECT

C.

TEXT

D.

VARIANT

Buy Now
Questions 205

When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?

Options:

A.

(12,2)

B.

(10,4)

C.

(14,8)

D.

(15,9)

Buy Now
Questions 206

Which Snowflake layer is associated with virtual warehouses?

Options:

A.

Cloud services

B.

Query processing

C.

Elastic memory

D.

Database storage

Buy Now
Questions 207

What information does the Query Profile provide?

Options:

A.

Graphical representation of the data model

B.

Statistics for each component of the processing plan

C.

Detailed Information about I he database schema

D.

Real-time monitoring of the database operations

Buy Now
Exam Code: COF-C02
Exam Name: SnowPro Core Certification Exam
Last Update: Nov 24, 2024
Questions: 693

PDF + Testing Engine

$134.99

Testing Engine

$99.99

PDF (Q&A)

$84.99