A data analyst is loading a Parquet file that contains columns in a different order than the target table. The analyst wants to map the columns correctly during the COPY INTO operation. Which approach should be used?

Use the MATCH_BY_COLUMN_NAME option in the file format.

Use a SELECT statement in the COPY INTO command that lists the columns in the correct order, matching the target table.

Use the FILE_FORMAT option to specify the column order.

Load the file into a temporary table and then use INSERT INTO with a column list.

A data analyst needs to query JSON files stored in Google Cloud Storage (GCS) directly from Snowflake. The files are large and the analyst wants to minimize the amount of data scanned for typical queries. Which approach should be used?

Use Snowpipe to load the JSON files into a table.

Load the JSON files into a Snowflake table and then create a view.

Create an external table with a file format that defines the JSON structure and use partitioning or clustering on the external table.

Use the GET command to download the files and query them locally.

A data analyst is setting up a new ingestion pipeline. The source system produces files that are uploaded to an S3 bucket. The analyst wants to organize the files by date and only load files from the current day. The analyst also wants to keep the stage definition simple and avoid managing credentials in multiple places. Which stage configuration should be used?

Create an external stage that references the S3 bucket and use a partitioned path like s3://bucket/date=YYYY-MM-DD/ in the COPY INTO command.

Create an internal stage and upload the files manually each day.

Create a separate external stage for each day's files.

Use a file format object to filter files by date.

Why is it recommended to compress data files before loading them into Snowflake?

To ensure data integrity during loading

To reduce storage costs and improve load performance

To avoid the need for a file format object

To make the data easier to read for analysts

Which of the following can be applied during a COPY INTO command to transform data as it is loaded?

A GROUP BY clause to aggregate data

A JOIN clause to combine data from multiple files

A SELECT statement with column mapping and type casting

Snowflake SnowPro Advanced:Data Analyst

Domain 4Objective 1

Ingest Data for Analysis SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 5)

Part of the Data Ingestion and Data Preparation domain, which accounts for 17% of the SNOWPRO-ADVANCED-DATA-ANALYST exam.

30questions here

6free pages

9concepts

17%of the exam

Questions 21–25

21application · medium
A data analyst is loading a Parquet file that contains columns in a different order than the target table. The analyst wants to map the columns correctly during the COPY INTO operation. Which approach should be used?
Select an answer first
22application · medium
A data analyst needs to query JSON files stored in Google Cloud Storage (GCS) directly from Snowflake. The files are large and the analyst wants to minimize the amount of data scanned for typical queries. Which approach should be used?
Select an answer first
23application · medium
A data analyst is setting up a new ingestion pipeline. The source system produces files that are uploaded to an S3 bucket. The analyst wants to organize the files by date and only load files from the current day. The analyst also wants to keep the stage definition simple and avoid managing credentials in multiple places. Which stage configuration should be used?
Select an answer first
24foundation · easy
Why is it recommended to compress data files before loading them into Snowflake?
Select an answer first
25foundation · easy
Which of the following can be applied during a COPY INTO command to transform data as it is loaded?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SNOWPRO-ADVANCED-DATA-ANALYST

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “SNOWPRO-ADVANCED-DATA-ANALYST” is a trademark of its owner, used for identification only.