Snowflake SnowPro Advanced:Data Analyst
Domain 4Objective 1
Ingest Data for Analysis SNOWPRO-ADVANCED-DATA-ANALYST Practice Questions (Page 1)
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 1–5
- 1
A data analyst is responsible for loading daily files from an external stage into a Snowflake table. The files are large (several GB) and arrive at unpredictable times. The analyst wants to minimize cost while ensuring the load completes within a reasonable time. The team has a limited budget and cannot afford a large warehouse running continuously. Which approach is the most cost-effective?
Select an answer first - 2
Which Snowflake object allows you to query data directly from files in an external stage without loading the data into a table?
Select an answer first - 3
A data analyst is loading a large batch of CSV files into a Snowflake table. Some files are expected to contain malformed rows that should be rejected, but the analyst wants the load to continue with valid files and then review the rejected rows. Which COPY INTO option should be used to achieve this?
Select an answer first - 4
Which Snowflake object is used to define the structure and options for reading a specific type of data file, such as CSV or JSON?
Select an answer first - 5
Which file format is a columnar format that is optimized for analytical queries and is commonly used in Snowflake?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
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.