← Back to exam page

Free SNOWPRO-ADVANCED-DATA-ENGINEER – Snowflake SNOWPRO-ADVANCED-DATA-ENGINEER Practice Test Question

Loading demo links...

Showing 4–6 of 13 questions

Question 4 (Topic 1)

At what isolation level are Snowflake streams?

Select an option, then click Submit answer.

  • ○ Snapshot
  • ○ Repeatable read
  • ○ Read committed
  • ○ Read uncommitted
Question 5 (Topic 1)

A Data Engineer wants to centralize grant management to maximize security. A user needs OWNERSHIP on a table in a new schema. However, this user should not have the ability to make grant decisions. What is the correct way to do this?

Select an option, then click Submit answer.

  • ○ Grant OWNERSHIP to the user on the table.
  • ○ Revoke grant decisions from the user on the table.
  • ○ Revoke grant decisions from the user on the schema.
  • ○ Add the WITH MANAGED ACCESS parameter on the schema.
Question 6 (Topic 1)

A CSV file, around 1 TB in size, is generated daily on an on-premise server. A corresponding table, internal stage, and file format have already been created in Snowflake to facilitate the data loading process. How can the process of bringing the CSV file into Snowflake be automated using the LEAST amount of operational overhead?

Select an option, then click Submit answer.

  • ○ Create a task in Snowflake that executes once a day and runs a COPY INTO statement that references the internal stage. The internal stage will read the files directly from the on-premise server and copy the newest file into the table from the on-premise server to the Snowflake table.
  • ○ On the on-premise server, schedule a SQL file to run using SnowSQL that executes a PUT to push a specific file to the internal stage. Create a task that executes once a day in Snowflake and runs a COPY INTO statement that references the internal stage. Schedule the task to start after the file lands in the internal stage.
  • ○ On the on-premise server, schedule a SQL file to run using SnowSQL that executes a PUT to push a specific file to the internal stage. Create a pipe that runs a COPY INTO statement that references the internal stage. Snowpipe auto-ingest will automatically load the file from the internal stage when the new file lands in the internal stage.
  • ○ On the on-premise server, schedule a Python file that uses the Snowpark Python library. The Python script will read the CSV data into a DataFrame and generate an INSERT INTO statement that will directly load into the table. The script will bypass the need to move a file into an internal stage.