SnowPro Advanced Architect Practice Test

SnowPro Advanced Architect Practice Test practice questions, page 7 of 10, with answer review and explanations.

Question 31

An Architect needs to allow a user to create a database from an inbound share. To meet this requirement, the user’s role must have which privileges? (Choose two.)

  1. IMPORT SHARE;
  2. IMPORT PRIVILEGES;
  3. CREATE DATABASE;
  4. CREATE SHARE;
  5. IMPORT DATABASE;

Question 32

Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives. How can a Snowflake Architect meet this requirement with the LEAST amount of coding? (Choose two.)

  1. Use Snowpipe with auto-ingest.
  2. Use a COPY command with a task.
  3. Use a materialized view on an external table.
  4. Use the COPY INTO command.
  5. Use a combination of a task and a stream.

Question 33

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME() or CURRENT_TIMESTAMP() what will occur?

  1. All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.
  2. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.
  3. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.
  4. All rows loaded using a specific COPY statement will have the same timestamp value.

Question 34

How does a standard virtual warehouse policy work in Snowflake?

  1. It conserves credits by keeping running clusters fully loaded rather than starting additional clusters.
  2. It starts only if the system estimates that there is a query load that will keep the cluster busy for at least 6 minutes.
  3. It starts only f the system estimates that there is a query load that will keep the cluster busy for at least 2 minutes.
  4. It prevents or minimizes queuing by starting additional clusters instead of conserving credits.

Question 35

Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?

  1. External table
  2. Materialized view
  3. Search optimization
  4. Result cache