Pass SnowPro Core COF-C02 exam [Apr 27, 2023] Updated 265 Questions [Q98-Q121]

ExamBoosts April 27, 2023 COF-C02 > Snowflake 0

Rate this post

Pass SnowPro Core COF-C02 exam [Apr 27, 2023] Updated 265 Questions

Snowflake COF-C02 Actual Questions and 100% Cover Real Exam Questions

The SnowPro Core Certification exam is a computer-based exam that consists of 90 multiple-choice questions. The exam is timed and lasts for 2 hours. Candidates must achieve a score of at least 80% to pass the exam and earn their certification. The exam is available in multiple languages and can be taken online from anywhere in the world.

NO.98 A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?

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

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

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

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

NO.99 Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Load files that are approximately 25 MB or smaller.

Remove all dates and timestamps.

Load files that are approximately 100-250 MB (or larger)

Avoid using embedded characters such as commas for numeric data types

Remove semi-structured data types

NO.100 True or False the longer the data retention period, the higher the resulting storage costs.

True

False

NO.101 Which of the following are common use cases for zero-copy cloning? Choose 3 answers

Quick provisioning of Dev and Test/QA environments

Data backups

Point in time snapshots

Performance optimization

NO.102 Which of the following describes a Snowflake stored procedure?

They can be created as secure and hide the underlying metadata from the user.

They can only access tables from a single database.

They can contain only a single SQL statement.

They can be created to run with a caller’s rights or an owner’s rights.

NO.103 The FLATEEN function is used to query which type of data in Snowflake?

Structured data

Semi-structured data

Both of the above

None of the above

NO.104 If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

The columns that are queried in the select clause.

The columns with very high cardinality.

The columns with many different values.

The columns most actively used in the select filters.

NO.105 A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
A)

B)

C)

D)

Option A

Option B

Option C

Option D

NO.106 Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

A Data Exchange allows groups of accounts to share data privately among the accounts.

A Data Exchange allows accounts to share data with third, non-Snowflake parties.

Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.

NO.107 Select the different types of Internal Stages: (Choose three.)

Named Stage

User Stage

Table Stage

Schema Stage

NO.108 What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

On-premise availability

Simplicity

Open source based

Concurrency

Performance

NO.109 Which SQL command can be used to see the CREATE definition of a masking policy?

SHOW MASKING POLICIES

DESCRIBE MASKING POLICY

GET_DDL

LIST MASKING POLICIES

NO.110 Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Internal stages

Incremental backups

Time Travel

Zero-copy clones

Fail-safe

NO.111 Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Compute resources

Query execution

Authentication

Data storage

Metadata

https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.
Services managed in this layer include:
Authentication
Infrastructure management
Metadata management
Query parsing and optimization
Access control

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

Queries against large tables where frequent DML occurs

Queries against tables larger than 1 TB

Selective point lookup queries

Queries against a subset of columns in a table

Reference:
%20point,OBJECT%2C%20and%20ARRAY%20columns)

NO.113 User-level network policies can be created by which of the following roles? (Select TWO).

ROLEADMIN

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN

USERADMIN

NO.114 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?

PURGE

MODIFY

REMOVE

DELETE

NO.115 True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

True

False

NO.116 Which copy INTO command outputs the data into one file?

SINGLE=TRUE

MAX_FILE_NUMBER=1

FILE_NUMBER=1

MULTIPLE=FAISE

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

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Object-level access control

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

https://docs.snowflake.com/en/user-guide/intro-editions.html

NO.118 Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

Schemas

Roles

Secure Views

Stored Procedures

Tables

Secure User-Defined Functions (UDFs)

NO.119 Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Internal stages

Incremental backups

Time Travel

Zero-copy clones

Fail-safe

Time travel and fail safe are the two continuous data protection features support the recovery of data automatically.
Snowflake provides powerful CDP features for ensuring the maintenance and availability of your historical data (i.e. data that has been changed or deleted):
Querying, cloning, and restoring historical data in tables, schemas, and databases for up to 90 days through Snowflake Time Travel.
Disaster recovery of historical data (by Snowflake) through Snowflake Fail-safe.
https://docs.snowflake.com/en/user-guide/data-availability.html

NO.120 True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

True

False

NO.121 True or False: Pipes can be suspended and resumed.

True

False

Loading …

The Snowflake COF-C02 (SnowPro Core Certification) Certification Exam covers a wide range of topics related to Snowflake’s cloud data platform. The exam includes questions on data warehousing, data modeling, SQL and SnowSQL, data loading, data unloading, and data management. It also tests candidates on their understanding of Snowflake’s security model, performance optimization techniques, and best practices for query tuning.

Snowflake COF-C02 Real 2023 Braindumps Mock Exam Dumps: https://www.examboosts.com/Snowflake/COF-C02-practice-exam-dumps.html