COF-C03 Practice Questions

A.  

To return a tabular value for each input row.

B.  

To process input rows and return the results as a pandas series.

C.  

To return one output row as a single column or value for each input row.

D.  

To process input rows as pandas DataFrames and return tabular results.

A.  

Use the automatic sharing feature for seamless access.

B.  

Drop the object and then re-add it to the database to trigger sharing.

C.  

Recreate the object with a different name in the database before sharing.

D.  

Use the grant privilege ... TO share command to grant the necessary privileges.

A.  

Consumers can create and apply masking policies to unloaded data.

B.  

Consumers can use resource monitors to track and limit costs.

C.  

Consumers can use a single reader account to access data from multiple data providers.

D.  

Providers can share data with consumers who do not have Snowflake accounts.

E.  

Consumers can unload data using the COPY INTO < location > command.

A.  

Create an account for an organization.

B.  

Edit the account data for an organization.

C.  

Delete the account data for an organization.

D.  

View usage information for all accounts in an organization.

E.  

Select all the data in tables for all accounts in an organization.

A.  

View

B.  

Secure view

C.  

Materialized view

D.  

External table

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.

A.  

The base tables do not change frequently.

B.  

The results of the view change often.

C.  

The query is not resource intensive.

D.  

The query results are not used frequently.

A.  

Disaster recovery

B.  

Time Travel

C.  

Fail-safe

D.  

Database failover and fallback

E.  

Data security

A.  

GRANT SEARCH OPTIMIZATION ON SCHEMA < schema_name > TO ROLE < role >

B.  

GRANT SEARCH OPTIMIZATION ON DATABASE < database_name > TO ROLE < role >

C.  

GRANT ADD SEARCH OPTIMIZATION ON SCHEMA < schema_name > TO ROLE < role >

D.  

GRANT ADD SEARCH OPTIMIZATION ON DATABASE < database name > TO ROLE < role >

A.  

SYSTEMADMIN_TAG

B.  

SYSTEM$GET_PRIVATELINK

C.  

SYSTEMSALLONTLIST

D.  

SYSTEMAUTHORIZE

A.  

BINARY_FORMAT

B.  

ESCAPE_UNENCLOSED_FIELD

C.  

FIELD_OPTIONALLY_ENCLOSED_BY

D.  

SKIP BYTE ORDER MARK

A.  

ARRAY

B.  

OBJECT

C.  

TEXT

D.  

VARIANT

A.  

Data storage

B.  

Dynamic data masking

C.  

Partition scanning

D.  

User authentication

E.  

Infrastructure management

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.

A.  

The provisioning of new compute resources for the warehouse will begin immediately.

B.  

The warehouse will remain suspended but new resources will be added to the query acceleration service.

C.  

The provisioning of additional compute resources will be in effect when the warehouse is next resumed.

D.  

The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.

A.  

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

B.  

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

C.  

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

D.  

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

E.  

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

A.  

1 minutes

B.  

5 minutes

C.  

10 minutes

D.  

15 minutes

A.  

60

B.  

91

C.  

120

D.  

121

A.  

Worksheets can be grouped under folder, and a folder of folders.

B.  

Each worksheet is a unique Snowflake session.

C.  

Users are limited to running only one on a worksheet.

D.  

The Snowflake session ends when a user switches worksheets.

E.  

Users can import worksheets and share them with other users.

A.  

Last_QUERY_ID

B.  

CURRENT_STATEMENT

C.  

UUID_STRING

D.  

JOB_ID