최신 ARA-C01 무료덤프 - Snowflake SnowPro Advanced Architect Certification

문제1

A table, EMP_ TBL has three records as shown:

The following variables are set for the session:

Which SELECT statements will retrieve all three records? (Select TWO).

A. SELECT * FROM identifier($tbl_ref) WHERE ID IN Cvarl','var2','var3');

B. SELECT * FROM identifier<Stbl_ref> WHERE NAME IN ($var1, $var2, $var3);

C. Select * FROM Stbl_ref WHERE Scol_ref IN ('Name1','Nam2','Name3');

D. SELECT * FROM EMP_TBL WHERE identifier(Scol_ref) IN ('Namel','Name2', 'Name3');

E. SELECT * FROM $tb1_ref WHERE $col_ref IN ($var1, Svar2, Svar3);

정답: D,E

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

문제2

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

A. Shared databases cannot be cloned.

B. Shared databases must be refreshed in order for new data to be visible.

C. Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.

D. Shared databases are not supported by Time Travel.

E. Shared databases are read-only.

F. Shared databases can also be created as transient databases.

정답: A,D,E

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

문제3

How can an Architect enable optimal clustering to enhance performance for different access paths on a given table?

A. Create super projections that will automatically create clustering.

B. Create multiple materialized views with different cluster keys.

C. Create a clustering key that contains all columns used in the access paths.

D. Create multiple clustering keys for a table.

정답: B

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

문제4

The following table exists in the production database:
A regulatory requirement states that the company must mask the username for events that are older than six months based on the current date when the data is queried.
How can the requirement be met without duplicating the event data and making sure it is applied when creating views using the table or cloning the table?

A. Use a masking policy on the username column with event_timestamp as a conditional column.

B. Use a row level policy on the user_events table using a entitlement table with valid dates.

C. Use a masking policy on the username column using a entitlement table with valid dates.

D. Use a secure view on the user_events table using a case statement on the username column.

정답: A

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

문제5

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. Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.

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

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

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

정답: D

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

문제6

A large manufacturing company runs a dozen individual Snowflake accounts across its business divisions. The company wants to increase the level of data sharing to support supply chain optimizations and increase its purchasing leverage with multiple vendors.
The company's Snowflake Architects need to design a solution that would allow the business divisions to decide what to share, while minimizing the level of effort spent on configuration and management. Most of the company divisions use Snowflake accounts in the same cloud deployments with a few exceptions for European-based divisions.
According to Snowflake recommended best practice, how should these requirements be met?

A. Deploy to the Snowflake Marketplace making sure that invoker_share() is used in all secure views.

B. Deploy a Private Data Exchange in combination with data shares for the European accounts.

C. Migrate the European accounts in the global region and manage shares in a connected graph architecture. Deploy a Data Exchange.

D. Deploy a Private Data Exchange and use replication to allow European data shares in the Exchange.

정답: D

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

문제7

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

C. SYSTEMSGET_PRIVATELINK

D. SYSTEMSAUTHORIZE_PRIVATELINK

정답: C

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

문제8

The data share exists between a data provider account and a data consumer account. Five tables from the provider account are being shared with the consumer account. The consumer role has been granted the imported privileges privilege.
What will happen to the consumer account if a new table (table_6) is added to the provider schema?

A. The consumer role will automatically see the new table and no additional grants are needed.

B. The consumer role will see the table only after this grant is given on the provider side:
use role accountadmin;
Grant select on table EDW.ACCOUNTING.Table_6 to share PSHARE_EDW_4TEST;

C. The consumer role will see the table only after this grant is given on the consumer side:
grant imported privileges on database PSHARE_EDW_4TEST_DB to DEV_ROLE;

D. The consumer role will see the table only after this grant is given on the provider side:
use role accountadmin;
grant usage on database EDW to share PSHARE_EDW_4TEST ;

정답: D

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

문제9

What transformations are supported in the below SQL statement? (Select THREE).
CREATE PIPE ... AS COPY ... FROM (...)

A. Columns can be reordered.

B. The ON ERROR - ABORT statement command can be used.

C. Incoming data can be joined with other tables.

D. Columns can be omitted.

E. Type casts are supported.

F. Data can be filtered by an optional where clause.

정답: A,D,F

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

문제10

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

A. They can support MIN and MAX aggregates.

B. They can include context functions, such as CURRENT_TIME().

C. They can include ORDER BY clauses.

D. They cannot include nested subqueries.

E. They can support inner joins, but not outer joins.

정답: A,D

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

최신 ARA-C01 무료덤프 - Snowflake SnowPro Advanced Architect Certification

우리와 연락하기

유용한 링크

최신 업데이트