Free Access Snowflake.COF-C02.v2023-02-20.q85 Practice Test (Page 3)

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

A.Internal Named Stage

B.Database Stage

C.Table Stage

D.Schema Stage

E.User Stage

F.External Named Stage

What is true about sharing data in Snowflake? (Choose two.)

A.The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

B.A Snowflake account can both provide and consume shared data.

C.The Provider is charged for compute resources used by the Data Consumer to query the shared data.

D.The Data Consumer pays for data storage as well as for data computing.

E.The Data Consumer pays only for compute resources to query the shared data.

Which statement is true about running tasks in Snowflake?

A.A task can be executed using a SELECT statement to run a predefined SQL command.

B.A task allows a user to execute a set of SQL commands on a predefined schedule.

C.A task allows a user to execute a single SQL statement/command using a predefined schedule.

D.A task can be called using a CALL statement to run a set of predefined SQL commands.

What is the minimum Snowflake edition required to create a materialized view?

A.Standard Edition

B.Enterprise Edition

C.Business Critical Edition

D.Virtual Private Snowflake Edition

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

A.Incoming data can be joined with other tables

B.Data can be filtered by an optional where clause

C.Row level access can be defined

D.Columns can be reordered

E.Columns can be omitted

Other Version: 765Snowflake.COF-C02.v2025-06-30.q512; 1077Snowflake.COF-C02.v2023-09-01.q136

Latest Upload: 107Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 156TheSecOpsGroup.CNSP.v2025-09-08.q20; 207CFAInstitute.ESG-Investing.v2025-09-08.q173; 155PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 144Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 177Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Download PDF File