support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Snowflake
  4. SnowPro Advanced Architect

Free SnowPro Advanced Architect Exam Braindumps
SnowPro Advanced Architect Questions 26–30 (page: 7)

Updated On: 10-Feb-2026
Page 7 of 23
PDF with 254 Questions

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.

Answer(s): B



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.

Answer(s): C,D



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.

Answer(s): D,E



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.

Answer(s): B,E,F



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.

Answer(s): A,B,C



  PDF
Viewing page 7 of 23
Viewing questions 31 - 35 out of 254 questions


Post your Comments and Discuss Snowflake SnowPro Advanced Architect exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!