ExamGecko
Search Search Login
Home Home / Snowflake / COF-R02

Snowflake COF-R02 Practice Test - Questions Answers, Page 33

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
Which minimum Snowflake edition allows for a dedicated metadata store?
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?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does Snowflake recommend maximizing the load performance?
Which TABLE function helps to convert semi-structured data to a relational representation?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
What is a responsibility of Snowflake’s virtual warehouses?

Question 321

Report
Export
Collapse

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

A.
Cloud services layer
A.
Cloud services layer
Answers
B.
Compute layer
B.
Compute layer
Answers
C.
Storage layer
C.
Storage layer
Answers
D.
Cloud agnostic layer
D.
Cloud agnostic layer
Answers
Suggested answer: B

Explanation:

Reference: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556

Question 322

Report
Export
Collapse

Which of the following is the Snowflake Account_Usage.Metering_History view used for?

A.
Gathering the hourly credit usage for an account
A.
Gathering the hourly credit usage for an account
Answers
B.
Compiling an account's average cloud services cost over the previous month
B.
Compiling an account's average cloud services cost over the previous month
Answers
C.
Summarizing the throughput of Snowpipe costs for an account
C.
Summarizing the throughput of Snowpipe costs for an account
Answers
D.
Calculating the funds left on an account's contract
D.
Calculating the funds left on an account's contract
Answers
Suggested answer: A

Question 323

Report
Export
Collapse

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

A.
SHOW MASKING POLICIES
A.
SHOW MASKING POLICIES
Answers
B.
DESCRIBE MASKING POLICY
B.
DESCRIBE MASKING POLICY
Answers
C.
GET_DDL
C.
GET_DDL
Answers
D.
LIST MASKING POLICIES
D.
LIST MASKING POLICIES
Answers
Suggested answer: C

Question 324

Report
Export
Collapse

Which statement describes pruning?

A.
The filtering or disregarding of micro-partitions that are not needed to return a query.
A.
The filtering or disregarding of micro-partitions that are not needed to return a query.
Answers
B.
The return of micro-partitions values that overlap with each other to reduce a query's runtime.
B.
The return of micro-partitions values that overlap with each other to reduce a query's runtime.
Answers
C.
A service that is handled by the Snowflake Cloud Services layer to optimize caching.
C.
A service that is handled by the Snowflake Cloud Services layer to optimize caching.
Answers
D.
The ability to allow the result of a query to be accessed as if it were a table.
D.
The ability to allow the result of a query to be accessed as if it were a table.
Answers
Suggested answer: A

Question 325

Report
Export
Collapse

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

A.
Modify the columns in the underlying table
A.
Modify the columns in the underlying table
Answers
B.
Use the ALTER VIEW command to update the view
B.
Use the ALTER VIEW command to update the view
Answers
C.
Recreate the view with the required changes
C.
Recreate the view with the required changes
Answers
D.
Materialize the view to perform the changes
D.
Materialize the view to perform the changes
Answers
Suggested answer: B

Question 326

Report
Export
Collapse

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

A.
grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
A.
grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;
Answers
B.
grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
B.
grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;
Answers
C.
grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
C.
grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;
Answers
D.
grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
D.
grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;
Answers
E.
grant SELECT on all tables in database DB1 to role MYROLE;
E.
grant SELECT on all tables in database DB1 to role MYROLE;
Answers
F.
grant SELECT on future tables in database DB1 to role MYROLE;
F.
grant SELECT on future tables in database DB1 to role MYROLE;
Answers
Suggested answer: C, D

Question 327

Report
Export
Collapse

Using variables in Snowflake is denoted by using which SQL character?

A.
@
A.
@
Answers
B.
&
B.
&
Answers
C.
$
C.
$
Answers
D.
#
D.
#
Answers
Suggested answer: C

Question 328

Report
Export
Collapse

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

A.
The shared objects are transferred.
A.
The shared objects are transferred.
Answers
B.
The shared objects are copied.
B.
The shared objects are copied.
Answers
C.
The shared objects become accessible.
C.
The shared objects become accessible.
Answers
D.
The shared objects can be re-shared.
D.
The shared objects can be re-shared.
Answers
Suggested answer: B

Question 329

Report
Export
Collapse

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

A.
STRIP_NULL_VALUES
A.
STRIP_NULL_VALUES
Answers
B.
SKIP_BYTE_ORDER_MARK
B.
SKIP_BYTE_ORDER_MARK
Answers
C.
REPLACE_INVALID_CHARACTERS
C.
REPLACE_INVALID_CHARACTERS
Answers
D.
VALIDATION_MODE
D.
VALIDATION_MODE
Answers
Suggested answer: D

Explanation:

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS

String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:

Question 330

Report
Export
Collapse

Which Snowflake tool would be BEST to troubleshoot network connectivity?

A.
SnowCLI
A.
SnowCLI
Answers
B.
SnowUI
B.
SnowUI
Answers
C.
SnowSQL
C.
SnowSQL
Answers
D.
SnowCD
D.
SnowCD
Answers
Suggested answer: D

Explanation:

https://docs.snowflake.com/en/userguide/snowcd.html#:~:text=SnowCD%20(i.e.%20Snowflake%20Connectivity%20Diagnostic,their%20network%20connection%20to%20Snowflake.


Total 330 questions
Go to page: of 33
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms