[2026] Snowflake SnowPro Advanced Architect Certification

문제1

The IT Security team has identified that there is an ongoing credential stuffing attack on many of their organization's system.
What is the BEST way to find recent and ongoing login attempts to Snowflake?

A. View the Users section in the Account tab in the Snowflake UI and review the last login column.

B. Call the LOGIN_HISTORY Information Schema table function.

C. Query the LOGIN_HISTORY view in the ACCOUNT_USAGE schema in the SNOWFLAKE database.

D. View the History tab in the Snowflake UI and set up a filter for SQL text that contains the text
"LOGIN".

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제2

What is a characteristic of Role-Based Access Control (RBAC) as used in Snowflake?

A. A user can use a "super-user" access along with securityadmin to bypass authorization checks and access all databases, schemas, and underlying objects.

B. Privileges can be granted at the database level and can be inherited by all underlying objects.

C. A user can create managed access schemas to support current and future grants and ensure only object owners can grant privileges to other roles.

D. A user can create managed access schemas to support future grants and ensure only schema owners can grant privileges to other roles.

정답: D

설명: (Fast2test 회원만 볼 수 있음)

문제3

An Architect wants to build an automated ETL pipeline that reads data from an external stage using an external table, performs transformations on changed data, joins with dimension tables, and loads results into a target table.
What should the Architect use?

A. Materialized views

B. Streams and tasks

C. Snowpipe with auto-ingest

D. Dynamic tables

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제4

When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

A. FAIL

B. CONTINUE

C. ABORT_STATEMENT

D. SKIP_FILE

정답: B,C,D

설명: (Fast2test 회원만 볼 수 있음)

문제5

An Architect is using SnowCD to investigate a connectivity issue.
Which system function will provide a list of endpoints that the network must be able to access to use a specific Snowflake account, leveraging private connectivity?

A. SYSTEMSALLOWLIST ()

B. SYSTEMSGET_PRIVATELINK

C. SYSTEMSALLOWLIST_PRIVATELINK ()

D. SYSTEMSAUTHORIZE_PRIVATELINK

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제6

An Architect wants to alter a virtual warehouse for horizontal scaling but cannot find minimum and maximum cluster settings in the interface, even with the ACCOUNTADMIN role.
What is the MOST likely issue?

A. Using Standard edition where multi-cluster is not available.

B. Missing CREATE WAREHOUSE privilege.

C. A Snowflake Support ticket is required.

D. Incorrect SQL command used.

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제7

A company has a source system that provides JSON records for various loT operations. The JSON Is loading directly into a persistent table with a variant field. The data Is quickly growing to 100s of millions of records and performance to becoming an issue. There is a generic access pattern that Is used to filter on the create_date key within the variant field.
What can be done to improve performance?

A. Validate the size of the warehouse being used. If the record count is approaching 100s of millions, size XL will be the minimum size required to process this amount of data.

B. Alter the target table to Include additional fields pulled from the JSON records. This would Include a create_date field with a datatype of time stamp. When this field Is used in the filter, partition pruning will occur.

C. Incorporate the use of multiple tables partitioned by date ranges. When a user or process needs to query a particular date range, ensure the appropriate base table Is used.

D. Alter the target table to include additional fields pulled from the JSON records. This would include a create_date field with a datatype of varchar. When this field is used in the filter, partition pruning will occur.

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제8

A call center processes sensitive PII and PHI data. Requirements:
* Object owners and privileged roles must see sensitive columns.
* Pre-tokenized data must be de-tokenized at query time.What should be used? (Select TWO).

A. Dynamic Data Masking

B. Materialized views

C. External tokenization

D. Role-Based Access Control (RBAC)

E. Object tagging

정답: A,D

설명: (Fast2test 회원만 볼 수 있음)

문제9

What is a key consideration when setting up search optimization service for a table?

A. Search optimization service can significantly improve query performance on partitioned external tables.

B. Search optimization service can help to optimize storage usage by compressing the data into a GZIP format.

C. The table must be clustered with a key having multiple columns for effective search optimization.

D. Search optimization service works best with a column that has a minimum of 100 K distinct values.

정답: D

설명: (Fast2test 회원만 볼 수 있음)

Snowflake SnowPro Advanced Architect Certification - ARA-C01무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트