Snowflake New 2024 COF-C02 Sample Questions Reliable COF-C02 Test Engine [Q159-Q179]

NO.159 Which rotes can make grant decisions to objects within a managed access schema? (Select TWO)

ACCOUNTADMIN

SECURITYADMIN

SYSTEMADMIN

ORGADMIN

USERADMIN

NO.160 Which of the following best describes where Snowflake’s metadata is stored?

Within the data files

Inside the Virtual Warehouses

In the Cloud Services Layer

within the drivers

NO.161 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.162 What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?

Use Snowflake’s native API.

Use a custom-built connector.

Contact Snowflake Support for a new driver.

Connect through Snowflake’s JDBC or ODBC drivers

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

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

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

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

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

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

NO.164 As a best practice, clustering keys should only be defined on tables of which minimum size?

Multi-Kilobyte (KB) Range

Multi-Megabyte (MB) Range

Multi-Gigabyte (GB) Range

Multi-Terabyte (TB) Range

NO.165 When unloading data with the COPY into <location> command, what is the purpose of the PARTITION BY
<expression> parameter option?

To sort the contents of the output file by the specified expression.

To delimit the records in the output file using the specified expression.

To include a new column in the output using the specified window function expression.

To split the output into multiple files, one for each distinct value of the specified expression.

NO.166 Which of the following are characteristics of security in Snowflake?

Account and user authentication is only available with the Snowflake Business Critical edition.

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

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

SHOW GRANTS ON ROLE DATA_SCIENCE

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

SHOW GRANTS TO USER INQUISITIVE_PERSON

SHOW GRANTS OF ROLE DATA_SCIENCE

NO.168 How does Snowflake define i1s approach to Discretionary Access Control (DAC)?

A defined level of access to an object

An entity in which access can be granted

Each object has an owner, who can in turn grail access to that object.

Access privileges are assigned to roles. which are in turn assigned to use’s

NO.169 What is the purpose of an External Function?

To call code that executes outside of Snowflake

To run a function in another Snowflake database

To share data in Snowflake with external parties

To ingest data from on-premises data sources

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

Pipes

Streams

Tasks

Procedures

NO.171 Which of the following statements about data sharing are true? choose 2 answers

New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts

All database objects can be included In a shared database

Reader Accounts are created and funded by Data Prowlers

Shared databases are read-only

NO.172 When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

10-50 MB

100-250 MB

300-500 MB

1000-1500 MB

NO.173 Which statement accurately describes a characteristic of a materialized view?

A materialized view can query only a single table.

Data accessed through materialized views can be stale.

Materialized view refreshes need to be maintained by the user.

Querying a materialized view is slower than executing a query against the base table of the view.

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

READ

OWNERSHIP

USAGK

WRTTF

NO.175 Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

Area chart

Box plot

Heat grid

Pie chart

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

Standard Edition

Enterprise Edition

Business Critical Edition

Virtual Private Snowflake Edition

NO.177 Which stream type can be used for tracking the records in external tables?

Append-only

External

Insert-only

Standard

NO.178 Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

The validation_mode option is used when creating an Internal Stage

validation_mode=return_all_errors is a parameter of the copy command

The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

NO.179 True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

True

False

Snowflake New 2024 COF-C02 Sample Questions Reliable COF-C02 Test Engine [Q159-Q179]

admin

Leave a Reply Cancel reply