A team uses a shared external stage for loading data. A new analyst needs to load data from this stage, but the security team requires that the analyst cannot see the storage credentials or modify the stage. What is the best way to grant access?

Grant READ on the stage to the analyst's role.

Grant OWNERSHIP on the stage to the analyst's role.

Grant USAGE on the stage to the analyst's role.

Create a new stage with the same credentials and grant USAGE on that stage.

Which SQL command removes a role's ability to access a stage?

REVOKE USAGE ON STAGE ... FROM ROLE

GRANT USAGE ON STAGE ... TO ROLE

A company needs to load large volumes of data for analytics. They are choosing between CSV and Parquet formats. What is the primary advantage of using Parquet over CSV for this use case?

Parquet provides better compression and columnar pruning, reducing storage and query costs.

Parquet does not require a file format definition in Snowflake.

Parquet is the only format that supports semi-structured data.

Parquet files are human-readable, making debugging easier.

Which best practice is recommended when organizing files in a stage for efficient loading?

Use a separate stage for each file

Use random file names to avoid conflicts

Store all files in a single flat directory

Organize files into logical folders by date or data source

Snowflake SnowPro Advanced:Data Analyst

Domain 4Objective 3

Configure Stages and File Formats 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.

20questions here

4free pages

7concepts

17%of the exam

Questions 1–5

1expert · medium
A team uses a shared external stage for loading data. A new analyst needs to load data from this stage, but the security team requires that the analyst cannot see the storage credentials or modify the stage. What is the best way to grant access?
Select an answer first
2foundation · easy
Which SQL command removes a role's ability to access a stage?
Select an answer first
3application · medium
A company needs to load large volumes of data for analytics. They are choosing between CSV and Parquet formats. What is the primary advantage of using Parquet over CSV for this use case?
Select an answer first
4foundation · easy
Which file format is generally recommended for large analytical datasets in Snowflake to optimize query performance?
Select an answer first
5foundation · easy
Which best practice is recommended when organizing files in a stage for efficient loading?
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.