Practice Questions · Part 4
Thirty questions in the exam's format: single choice and multiple select, no topic hints. Answer each one, then read the explanation even when you got it right.
SnowPro Core COF-C03 Study GuidePart 4: Data loading and storagePractice Questions: Part 4
Thirty questions in the exam's format: single choice and multiple select, no topic hints. Answer each one, then read the explanation even when you got it right.
An external stage has no file format, the COPY INTO statement sets none, and the target table has no STAGE_FILE_FORMAT. The staged files are JSON documents with a .json extension. What happens when the COPY runs?
Stage LANDING has a CSV file format with SKIP_HEADER = 1. A data engineer runs a COPY from LANDING that adds FILE_FORMAT = (TYPE = CSV FIELD_DELIMITER = '|'). The first line of each file is a header. What happens to the header lines?
A COPY INTO <table> with ON_ERROR = CONTINUE has already run in the current session. Which statements about running the VALIDATE function on that load are true? (Choose two.)
JOB_ID => '_last'.Where does Snowflake keep the load metadata for files loaded by a bulk COPY INTO <table>, and for how long?
A COPY INTO statement loaded 20 files an hour ago. The same statement runs again against the same stage and table, and none of the files has changed. What happens?
A data engineer must unload relational table ORDERS (columns ORDER_ID and AMOUNT) to a stage as JSON, one object per row. Which approach works?
A loading pipeline uses several objects. Which of them live in a schema, so that using them needs USAGE on that schema? (Choose three.)
What is the maximum size of a single value stored in a VARIANT column?
Small files land in an S3 bucket at unpredictable times all day. A team wants each file loaded within a few minutes of arrival, without scheduling anything or keeping a warehouse running. What should it use?
AUTO_REFRESH = TRUEA security team requires that Snowflake read an S3 bucket without any AWS access key or secret ever appearing in Snowflake DDL or query history. What should the data engineer configure?
Which statements about external tables are true? (Choose two.)
A web application must give its end users short-lived HTTPS links to download PDFs stored on an internal stage. The end users have no Snowflake login. Which function generates these links?
A source system exports one 20 GB gzipped CSV file per day, and the nightly COPY on a Large warehouse is slow. Which change has the most impact?
An application emits sensor readings as rows, never as files. The business wants them queryable in Snowflake within seconds, with no staging step and no warehouse to manage. What should the team use?
Which statements about stages are true? (Choose two.)
@~) is created automatically and can't be dropped.A data engineer runs COPY INTO @export/orders/ FROM orders; on a large table, with no other options. What does Snowflake write by default?
An external table over Parquet files in S3 was created without auto-refresh. New files have since landed in the bucket, but queries don't return their rows. What should the team do?
ALTER EXTERNAL TABLE ... REFRESHA team runs the classic Snowflake Connector for Kafka (version 3) with default settings and lets it create the target table for a topic. Which columns does that table have?
Which statements about the ON_ERROR option of a bulk COPY INTO <table> are true? (Choose two.)
A pipe's COPY statement doesn't set ON_ERROR. Of 50 files that arrive, one contains a malformed row. What does Snowpipe do?
Before loading new files, a data engineer wants a list of every error the files would produce, without loading any rows. What should the engineer use?
JOB_ID => '_last'Which statements describe Snowpipe compared with bulk COPY INTO? (Choose two.)
A stage path holds files of mixed age. Files loaded in the last few weeks must not load again. Some files staged more than 64 days ago were never loaded, and COPY skips them because their load status is unknown. Which copy option loads those old files without reloading the recent ones?
FORCE = TRUELOAD_UNCERTAIN_FILES = TRUEPURGE = TRUEMATCH_BY_COLUMN_NAME = CASE_INSENSITIVEAn analyst in SnowSQL runs GET @s3_landing/orders/ file:///tmp/; where S3_LANDING is an external stage on Amazon S3. What happens?
Which statements about directory tables are true? (Choose two.)
DIRECTORY = (ENABLE = TRUE).Standard table ORDERS declares ORDER_ID as its PRIMARY KEY. A COPY loads a file in which two rows share the same ORDER_ID. What happens?
Each staged JSON file holds one top-level array of thousands of objects. The team wants one table row per object, each stored in a VARIANT column. Which file format option does this?
ENABLE_OCTAL = TRUESTRIP_NULL_VALUES = TRUEALLOW_DUPLICATE = TRUESTRIP_OUTER_ARRAY = TRUEA COPY INTO <table> loads from a SELECT over staged files. Which operations can that SELECT perform? (Choose two.)
A bucket can't send event notifications to Snowflake, but the application that writes the files knows exactly when each batch lands. How should the team trigger Snowpipe for each new batch?
ALTER PIPE ... REFRESH every minuteAUTO_INGEST = TRUE on the pipeA team has hundreds of Parquet files in a stage. It wants to create a standard table whose column names and types match the files, without typing the column list, and then load the files into it. What should it run first?
Finish this set to count it as done.