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

문제1

An Architect has designed a data pipeline that Is receiving small CSV files from multiple sources. All of the files are landing in one location. Specific files are filtered for loading into Snowflake tables using the copy command. The loading performance is poor.
What changes can be made to Improve the data loading performance?

A. Create a multi-cluster warehouse and merge smaller files to create bigger files.

B. Increase the size of the virtual warehouse.

C. Create a specific storage landing bucket to avoid file scanning.

D. Change the file format from CSV to JSON.

정답: A

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

문제2

A user has activated primary and secondary roles for a session.
What operation is the user prohibited from using as part of SQL actions in Snowflake using the secondary role?

A. Insert

B. Delete

C. Truncate

D. Create

정답: D

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

문제3

Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)

A. Periodic rekeying of encrypted data

B. Customer-managed encryption keys through Tri-Secret Secure

C. AWS, Azure, or Google Cloud private connectivity to Snowflake

D. Federated authentication and SSO

E. Extended Time Travel (up to 90 days)

정답: B,C

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

문제4

An Architect is troubleshooting a query with poor performance using the QUERY_HIST0RY function. The Architect observes that the COMPILATIONJHME is greater than the EXECUTIONJTIME.
What is the reason for this?

A. The query is processing a very large dataset.

B. The query is queued for execution.

C. The query has overly complex logic.

D. The query is reading from remote storage.

정답: C

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

문제5

Consider the following COPY command which is loading data with CSV format into a Snowflake table from an internal stage through a data transformation query.

This command results in the following error:
SQL compilation error: invalid parameter 'validation_mode'
Assuming the syntax is correct, what is the cause of this error?

A. The VALIDATION_MODE parameter supports COPY statements that load data from external stages only.

B. The VALIDATION_MODE parameter does not support COPY statements with CSV file formats.

C. The VALIDATION_MODE parameter does not support COPY statements that transform data during a load.

D. The value return_all_errors of the option VALIDATION_MODE is causing a compilation error.

정답: C

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

문제6

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition.
How can this data be shared?

A. By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.

B. Contact Snowflake and they will execute the share request for the healthcare company.

C. The healthcare company will need to change the institute's Snowflake edition in the accounts panel.

D. Set the share_restriction parameter on the shared object to false.

정답: D

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

문제7

A Snowflake Architect Is working with Data Modelers and Table Designers to draft an ELT framework specifically for data loading using Snowpipe. The Table Designers will add a timestamp column that Inserts the current tlmestamp as the default value as records are loaded into a table. The Intent is to capture the time when each record gets loaded into the table; however, when tested the timestamps are earlier than the loae_take column values returned by the copy_history function or the Copy_HISTORY view (Account Usage).
Why Is this occurring?

A. The timestamps are different because there are parameter setup mismatches. The parameters need to be realigned

B. The CURRENT_TIMEis evaluated when the load operation is compiled in cloud services rather than when the record is inserted into the table.

C. The Table Designer team has not used the localtimestamp or systimestamp functions in the Snowflake copy statement.

D. The Snowflake timezone parameter Is different from the cloud provider's parameters causing the mismatch.

정답: B

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

문제8

Based on the architecture in the image, how can the data from DB1 be copied into TBL2? (Select TWO).

A.

B.

C.

D.

E.

정답: A,D

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

문제9

Which of the following are characteristics of Snowflake's parameter hierarchy?

A. Table parameters override virtual warehouse parameters.

B. Session parameters override virtual warehouse parameters.

C. Schema parameters override account parameters.

D. Virtual warehouse parameters override user parameters.

정답: D

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

문제10

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 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. 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 JavaScript stored procedure to read. join, and aggregate the data directly from the external stage, and then store the results in a table.

정답: C

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

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

우리와 연락하기

유용한 링크

최신 업데이트