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.)

Define row access policies.
Use the Business Critical edition of Snowflake.
Create a secure view.
Use the Enterprise edition of Snowflake.
Use Dynamic Data Masking.
Create a materialized view.

Answer(s): B,E,F

Reveal Solution Next Question

QUESTION: 30

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

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

Answer(s): A,B,C

Reveal Solution Next Question

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.)

IMPORT SHARE;
IMPORT PRIVILEGES;
CREATE DATABASE;
CREATE SHARE;
IMPORT DATABASE;

Answer(s): B,C

Reveal Solution Next Question

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.)

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

Answer(s): A,E

Reveal Solution Next Question

Free SnowPro Advanced Architect Exam Braindumps (page: 8)

QUESTION: 29

QUESTION: 30

QUESTION: 31

QUESTION: 32