SnowPro Advanced Architect Practice Test

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

Question 26

A Snowflake Architect is designing an application and tenancy strategy for an organization where strong legal isolation rules as well as multi-tenancy are requirements. Which approach will meet these requirements if Role-Based Access Policies (RBAC) is a viable option for isolating tenants?

  1. Create accounts for each tenant in the Snowflake organization.
  2. Create an object for each tenant strategy if row level security is viable for isolating tenants.
  3. Create an object for each tenant strategy if row level security is not viable for isolating tenants.
  4. Create a multi-tenant table strategy if row level security is not viable for isolating tenants.

Question 27

Which statements describe characteristics of the use of materialized views in Snowflake? (Choose two.)

  1. They can include ORDER BY clauses.
  2. They cannot include nested subqueries.
  3. They can include context functions, such as CURRENT_TIME().
  4. They can support MIN and MAX aggregates.
  5. They can support inner joins, but not outer joins.

Question 28

The Data Engineering team at a large manufacturing company needs to engineer data coming from many sources to support a wide variety of use cases and data consumer requirements which include: 1. Finance and Vendor Management team members who require reporting and visualization 2. Data Science team members who require access to raw data for ML model development 3. Sales team members who require engineered and protected data for data monetization What Snowflake data modeling approaches will meet these requirements? (Choose two.)

  1. Consolidate data in the company’s data lake and use EXTERNAL TABLES.
  2. Create a raw database for landing and persisting raw data entering the data pipelines.
  3. Create a set of profile-specific databases that aligns data with usage patterns.
  4. Create a single star schema in a single database to support all consumers’ requirements.
  5. Create a Data Vault as the sole data pipeline endpoint and have all consumers directly access the Vault.

Question 29

An Architect on a new project has been asked to design an architecture that meets Snowflake security, compliance, and governance requirements as follows: 1. Use Tri-Secret Secure in Snowflake 2. Share some information stored in a view with another Snowflake customer 3. Hide portions of sensitive information from some columns 4. Use zero-copy cloning to refresh the non-production environment from the production environment To meet these requirements, which design elements must be implemented? (Choose three.)

  1. Define row access policies.
  2. Use the Business Critical edition of Snowflake.
  3. Create a secure view.
  4. Use the Enterprise edition of Snowflake.
  5. Use Dynamic Data Masking.
  6. Create a materialized view.

Question 30

Which of the following are characteristics of how row access policies can be applied to external tables? (Choose three.)

  1. An external table can be created with a row access policy, and the policy can be applied to the VALUE column.
  2. A row access policy can be applied to the VALUE column of an existing external table.
  3. A row access policy cannot be directly added to a virtual column of an external table.
  4. External tables are supported as mapping tables in a row access policy.
  5. While cloning a database, both the row access policy and the external table will be cloned.
  6. A row access policy cannot be applied to a view created on top of an external table.