What is a characteristic of a tag associated with a masking policy?

A tag can have only one masking policy for each data type.

A tag can be dropped after a masking policy is assigned

A tag can have only one masking policy for each data type.

A tag can have multiple masking policies for each data type.

A tag can have multiple masking policies with varying data types

While unloading data into a stage, how can the user ensure that the output will be a single file?

Use the COPY Option SINGLE=TRUE .

Use the copy option files=single.

Use the COPY Option SINGLE=TRUE .

Use the get option SINGLE-TRUE.

Use the GET option FILES-SINGLE.

Who can create and manage reader accounts? (Select TWO).

A user with CREATE ACCOUNT privilege

What would cause different results to be returned when running the same query twice?

sample is used and the seed is not set.

SAMPLE is used and the seed is set

sample is used and the seed is not set.

Fraction-based sampling is used.

Which MINIMUM set of privileges is required to temporarily bypass an active network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY?

Only while in the ACCOUNTADMIH role

Only while in the securityadmin role

Only the role with the ownership privilege on the network policy

Only Snowflake Support can set the value for this object property

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

A table with a materialized view

What are type predicates used for?

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

Extracting data from a variant column

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

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

Manipulating objects and arrays in a VARIANT column

Which actions can be performed using a resource monitor in Snowflake? (Select TWO).

Suspend a virtual warehouse when its credit usage reaches a defined limit.

Trigger a notification to account administrators when credit usage reaches a specified threshold

Monitor the performance of individual queries in real-time

Automatically allocate more storage space to a virtual warehouse

Modify the queries being executed within a virtual warehouse.

Suspend a virtual warehouse when its credit usage reaches a defined limit.

Trigger a notification to account administrators when credit usage reaches a specified threshold

Why would a Snowflake user load JSON data into a VARIANT column instead of a string column?

A variant column can be used to create a data hierarchy and a string column cannot

A VARIANT column is more secure than a string column

A VARIANT column compresses data and a string column does not.

A variant column can be used to create a data hierarchy and a string column cannot

A VARIANT column will have a better query performance than a string column.

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

Set the SINGLE parameter to TRUE.

Keep the default MAX_FILE_SIZE to 16 MB

Set the default MAX_FILE_SI2E to 5 GB.

Set the SINGLE parameter to TRUE.

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

Which security models are used in Snowflake to manage access control? (Select TWO).

Discretionary Access Control (DAC)

Role-Based Access Control (RBAC)

Discretionary Access Control (DAC)

Identity Access Management (1AM)

Role-Based Access Control (RBAC)

Security Assertion Markup Language (SAML)

What is the MINIMUM Snowftake edition that supports database replication?

Virtual Private Snowflake (VPS)

Which type of workload traditionally benefits from the use of the query acceleration service?

Workloads that include on-demand data analyses

Workloads with a predictable data volume for each query

Workloads that include on-demand data analyses

Queries with small scans and non-selective filters

Queries that do not have filters or aggregation

In which use cases does Snowflake apply egress charges?

Data sharing within a specific region

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

Until the expiration time is exceeded

Until the retention_time is met

Until the expiration time is exceeded

What Snowflake recommendation is designed to ensure that staged data is only loaded once'?

Removing data files after loading

Loading only the most recently-staged data files

Removing data files after loading

Identifying and removing duplicates after each data load

How can the Query Profile be used to troubleshoot a problematic query?

It will indicate if a virtual warehouse memory is too small to run the query

It will indicate if a user lacks the privileges needed to run the query.

It will indicate if a virtual warehouse is in auto-scale mode

It will indicate if the user has enough Snowflake credits to run the query

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

Do not expose the sequence-generated column(s)

Use sequence-gen era ted values

Programmatically reveal the identifiers.

Use secure views solely for query convenience.

Do not expose the sequence-generated column(s)

Which objects will incur storage costs associated with Fail-safe?

Data files available in external stages

Data files available in internal stages

Data files available in external stages

How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtual warehouse?

Use the ALTER warehouse command on a suspended Standard virtual warehouse.

Use the ALTER WAREHOUSE command on an active Standard virtual warehouse

Use the alter warehouse command on an active Snowpark-optimized warehouse.

Use the ALTER warehouse command on a suspended Standard virtual warehouse.

Use the ALTER WAREHOUSE command on a suspended Snowpark-optimized warehouse.

Snowflake COF-C02 Practice Test 17 - Free Online Exam Prep & Questions

Spam

Selling illegal goods, money scams etc.

Hate Speech

Serious attack on a group.

Harassment and bullying

Harassing an individual (including doxing)

Harmful activities

Threatening or glorifying violence or serious harm, including self-harm

Adult content (Consensual)

Nudity/Sexual content

Sexual exploitation and abuse (child safety)

Sexually explicit or suggestive imagery or writing involving minors

Sexual exploitation and abuse (adults and animals)

Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans

Plagiarism

Reusing content without attribution (link and blockquotes)

Poorly written

Not in English or has very bad formatting, grammar, and spelling

Inappropriate credential

Author's credential is offensive, spam, or impersonation

Other

Ex. Illegal content, incomplete question...

Snowflake COF-C02 Practice Test 17

Question

Snowflake COF-C02 Practice Tests

Practice Tests