[2026] Snowflake SnowPro Advanced: Architect Recertification

문제1

An Architect needs to automate the daily Import of two files from an external stage into Snowflake. One file has Parquet-formatted data, the other has CSV-formatted data.
How should the data be joined and aggregated to produce a final result set?

A. Use Snowpipe to ingest the two files, then create a materialized view to produce the final result set.

B. Create a JavaScript stored procedure to read. join, and aggregate the data directly from the external stage, and then store the results in a table.

C. Create a task using Snowflake scripting that will import the files, and then call a User-Defined Function (UDF) to produce the final result set.

D. Create a materialized view to read, Join, and aggregate the data directly from the external stage, and use the view to produce the final result set

정답: C

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

문제2

What are characteristics of Dynamic Data Masking? (Select TWO).

A. A masking policy can be applied to a column with the GEOGRAPHY data type.

B. A masking policy can be applied to the value column of an external table.

C. A single masking policy can be applied to columns in different tables.

D. A masking policy that Is currently set on a table can be dropped.

E. The role that creates the masking policy will always see unmasked data In query results

정답: C,D

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

문제3

A group of Data Analysts have been granted the role analyst role. They need a Snowflake database where they can create and modify tables, views, and other objects to load with their own data. The Analysts should not have the ability to give other Snowflake users outside of their role access to this data.
How should these requirements be met?

A. Grant ANALYST_R0LE OWNERSHIP on the database, but make sure that ANALYST_ROLE does not have the MANAGE GRANTS privilege on the account.

B. Make every schema in the database a managed access schema, owned by SYSADMIN, and grant create privileges on each schema to the ANALYST_ROLE for each type of object that needs to be created.

C. Grant ANALYST_ROLE ownership on the database, but grant the ownership on future [object type] s in database privilege to SYSADMIN.

D. Grant SYSADMIN ownership of the database, but grant the create schema privilege on the database to the ANALYST_ROLE.

정답: B

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

문제4

Which of the following ingestion methods can be used to load near real-time data by using the messaging services provided by a cloud provider?

A. Spark

B. Snowpipe

C. Snowflake Connector for Kafka

D. Snowflake streams

정답: C

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

문제5

An Architect clones a database and all of its objects, including tasks. After the cloning, the tasks stop running.
Why is this occurring?

A. The Architect has insufficient privileges to alter tasks on the cloned database.

B. The objects that the tasks reference are not fully qualified.

C. Cloned tasks are suspended by default and must be manually resumed.

D. Tasks cannot be cloned.

정답: C

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

문제6

Which Snowflake architecture recommendation needs multiple Snowflake accounts for implementation?

A. Create external stages pointing to cloud providers and regions other than the region hosting the Snowflake account.

B. Enable separation of the development, test, and production environments.

C. Enable a disaster recovery strategy across multiple cloud providers.

D. Enable zero-copy cloning among the development, test, and production environments.

정답: B

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

문제7

A Developer is having a performance issue with a Snowflake query. The query receives up to 10 different values for one parameter and then performs an aggregation over the majority of a fact table. It then joins against a smaller dimension table. This parameter value is selected by the different query users when they execute it during business hours. Both the fact and dimension tables are loaded with new data in an overnight import process.
On a Small or Medium-sized virtual warehouse, the query performs slowly. Performance is acceptable on a size Large or bigger warehouse. However, there is no budget to increase costs. The Developer needs a recommendation that does not increase compute costs to run this query.
What should the Architect recommend?

A. Create a task that will run the 10 different variations of the query corresponding to the 10 different parameters before the users come in to work. The task will be scheduled to align with the users' working hours in order to allow the warehouse cache to be used.

B. Create a dedicated size Large warehouse for this particular set of queries. Create a new role that has USAGE permission on this warehouse and has the appropriate read permissions over the fact and dimension tables. Have users switch to this role and use this warehouse when they want to access this data.

C. Create a task that will run the 10 different variations of the query corresponding to the 10 different parameters before the users come in to work. The query results will then be cached and ready to respond quickly when the users re-issue the query.

D. Enable the search optimization service on the table. When the users execute the query, the search optimization service will automatically adjust the query execution plan based on the frequently-used parameters.

정답: D

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

문제8

At which object type level can the APPLY MASKING POLICY, APPLY ROW ACCESS POLICY and APPLY SESSION POLICY privileges be granted?

A. Global

B. Table

C. Database

D. Schema

정답: A

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

문제9

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?

A. All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.

B. All rows loaded using a specific COPY statement will have the same timestamp value.

C. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.

D. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.

정답: B

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

문제10

There are two databases in an account, named fin_db and hr_db which contain payroll and employee data, respectively. Accountants and Analysts in the company require different permissions on the objects in these databases to perform their jobs. Accountants need read-write access to fin_db but only require read-only access to hr_db because the database is maintained by human resources personnel.
An Architect needs to create a read-only role for certain employees working in the human resources department.
Which permission sets must be granted to this role?

A. USAGE on database hr_db, USAGE on all schemas in database hr_db, REFERENCES on all tables in database hr_db

B. USAGE on database hr_db, SELECT on all schemas in database hr_db, SELECT on all tables in database hr_db

C. USAGE on database hr_db, USAGE on all schemas in database hr_db, SELECT on all tables in database hr_db

D. MODIFY on database hr_db, USAGE on all schemas in database hr_db, USAGE on all tables in database hr_db

정답: C

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

문제11

What is the MOST efficient way to design an environment where data retention is not considered critical, and customization needs are to be kept to a minimum?

A. Use a transient database.

B. Use a temporary table.

C. Use a transient schema.

D. Use a transient table.

정답: A

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

문제12

Following objects can be cloned in snowflake

A. Internal stages

B. Temporary table

C. Transient table

D. Permanent table

E. External tables

정답: C,D,E

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

문제13

In a managed access schema, what are characteristics of the roles that can manage object privileges? (Select TWO).

A. Users who are schema owners can grant object privileges in a managed access schema.

B. Users with the SECURITYADMIN role or higher, can grant object privileges in a managed access schema.

C. Users who are database owners can grant object privileges in a managed access schema.

D. Users with the SYSADMIN role can grant object privileges in a managed access schema.

E. Users who are object owners can grant object privileges in a managed access schema.

정답: A,B

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

문제14

A Snowflake Architect created a new data share and would like to verify that only specific records in secure views are visible within the data share by the consumers.
What is the recommended way to validate data accessibility by the consumers?

A. Create a row access policy as shown below and assign it to the data share.
create or replace row access policy rap_acct as (acct_id varchar) returns boolean -> case when
'acctl_role' = current_role() then true else false end;

B. Alter the share settings as shown below, in order to impersonate a specific consumer account.
alter share sales share set accounts = 'Consumerl' share restrictions = true

C. Set the session parameter called SIMULATED_DATA_SHARING_C0NSUMER as shown below in order to impersonate the consumer accounts.
alter session set simulated_data_sharing_consumer - 'Consumer Acctl*

D. Create reader accounts as shown below and impersonate the consumers by logging in with their credentials.
create managed account reader_acctl admin_name = userl , adroin_password 'Sdfed43da!44T , type = reader;

정답: C

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

Snowflake SnowPro Advanced: Architect Recertification - ARA-R01무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트