SnowPro Core COF-C03 Practice Questions & Answers • ExamPrepare

187 questions in this view

Page 1 of 32

Question 1

A Snowflake Practitioner supports a team that uses a custom Python script running on an external scheduler to extract incremental changes from a PostgreSQL database every 30 minutes and load them into Snowflake. The team finds the script difficult to maintain when source schemas change, and the 30-minute batch cycle does not meet near real-time reporting requirements.

Which Snowflake feature addresses these challenges?

Streams and tasks
Dynamic Tables with incremental refresh
Openflow Connector
Snowpipe Streaming

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 2

A user needs to automatically retrieve the Iceberg column definitions using the INFER_SCHEMA function for semi-structured files stored on a stage.

Which file format configuration will help them achieve this?

CREATE FILE FORMAT MY_FF TYPE = ORC;
CREATE FILE FORMAT MY_FF TYPE = AVRO;
CREATE FILE FORMAT MY_FF TYPE = PARQUET USE_VECTORIZED_SCANNER = TRUE;
CREATE FILE FORMAT MY_FF TYPE = PARQUET USE_VECTORIZED_SCANNER = FALSE;

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 3

A TIMEZONE parameter for an account was set at multiple levels:

-Session-level: 'America/Chicago'

-Account-level: 'UTC'

-User-level: 'Asia/Tokyo'

A user working in Brussels runs this command:

SELECT CURRENT_TIMESTAMP();

Which time zone will Snowflake use to display the result?

UTC
Asia/Tokyo
Europe/Brussels
America/Chicago

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 4

A team needs to load large batches of historical data from CSV files stored in Amazon S3 into tables once per week. They want to control costs by using compute resources only when needed.

Which loading method and compute approach will accomplish this?

Use Snowpipe with serverless compute to automatically scale and minimize costs.
Use Snowpipe streaming service to copy the data from S3 into the tables, only consuming credits during ingestion.
Use bulk loading with the COPY INTO command and a user-managed virtual warehouse that is suspended when not in use.
Use the COPY INTO command with serverless compute that automatically resizes based on the data volume.

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 5

During a COPY INTO load, a user would like to transform staged data by joining it to a small reference table and using the FLATTEN function.

What will be the result?

The data will be transformed.
The data will be transformed if ON_ERROR = CONTINUE .
The statement will produce an error.
The data will be transformed if the data is JSON.

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 6

A company is implementing Snowflake and requires these services and features:

- Multi-cluster warehouses

- OAuth for authentication

- Support for private connectivity to the Snowflake service

- Data Metric Functions (DMFs)

Which is the MINIMUM Snowflake edition that will provide these services and features?

Standard
Enterprise
Business Critical
Virtual Private Snowflake (VPS)

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.