Valentine Day Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

SnowPro Advanced: Architect Certification Exam Question and Answers

SnowPro Advanced: Architect Certification Exam

Last Update Feb 26, 2024
Total Questions : 134

We are offering FREE ARA-C01 Snowflake exam questions. All you do is to just go and sign up. Give your details, prepare ARA-C01 free exam questions and then go for complete pool of SnowPro Advanced: Architect Certification Exam test questions that will help you more.

ARA-C01 pdf

ARA-C01 PDF

$35  $99.99
ARA-C01 Engine

ARA-C01 Testing Engine

$42  $119.99
ARA-C01 PDF + Engine

ARA-C01 PDF + Testing Engine

$56  $159.99
Questions 1

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?

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Questions 2

An Architect is troubleshooting a query with poor performance using the QUERY function. The Architect observes that the COMPILATION_TIME Is greater than the EXECUTION_TIME.

What is the reason for this?

Options:

A.  

The query is processing a very large dataset.

B.  

The query has overly complex logic.

C.  

The query Is queued for execution.

D.  

The query Is reading from remote storage

Discussion 0
Questions 3

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?

Options:

A.  

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

B.  

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

C.  

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

D.  

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

Discussion 0
Questions 4

Consider the following scenario where a masking policy is applied on the CREDICARDND column of the CREDITCARDINFO table. The masking policy definition Is as follows:

Sample data for the CREDITCARDINFO table is as follows:

NAME EXPIRYDATE CREDITCARDNO

JOHN DOE 2022-07-23 4321 5678 9012 1234

if the Snowflake system rotes have not been granted any additional roles, what will be the result?

Options:

A.  

The sysadmin can see the CREDICARDND column data in clear text.

B.  

The owner of the table will see the CREDICARDND column data in clear text.

C.  

Anyone with the Pl_ANALYTICS role will see the last 4 characters of the CREDICARDND column data in dear text.

D.  

Anyone with the Pl_ANALYTICS role will see the CREDICARDND column as*** 'MASKED* **'.

Discussion 0
Questions 5

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

Options:

A.  

An external table can be created with a row access policy, and the policy can be applied to the VALUE column.

B.  

A row access policy can be applied to the VALUE column of an existing external table.

C.  

A row access policy cannot be directly added to a virtual column of an external table.

D.  

External tables are supported as mapping tables in a row access policy.

E.  

While cloning a database, both the row access policy and the external table will be cloned.

F.  

A row access policy cannot be applied to a view created on top of an external table.

Discussion 0
Questions 6

How can the Snowpipe REST API be used to keep a log of data load history?

Options:

A.  

Call insertReport every 20 minutes, fetching the last 10,000 entries.

B.  

Call loadHistoryScan every minute for the maximum time range.

C.  

Call insertReport every 8 minutes for a 10-minute time range.

D.  

Call loadHistoryScan every 10 minutes for a 15-minutes range.

Discussion 0
Questions 7

How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)

Options:

A.  

A task scheduled in a UTC-based schedule will have no issues with the time changes.

B.  

Task schedules can be designed to follow specified or local time zones to accommodate the time changes.

C.  

A task will move to a suspended state during the daylight savings time change.

D.  

A frequent task execution schedule like minutes may not cause a problem, but will affect the task history.

E.  

A task schedule will follow only the specified time and will fail to handle lost or duplicated hours.

Discussion 0
Questions 8

What is a characteristic of event notifications in Snowpipe?

Options:

A.  

The load history is stored In the metadata of the target table.

B.  

Notifications identify the cloud storage event and the actual data in the files.

C.  

Snowflake can process all older notifications when a paused pipe Is resumed.

D.  

When a pipe Is paused, event messages received for the pipe enter a limited retention period.

Discussion 0
Questions 9

A healthcare company is deploying a Snowflake account that may include Personal Health Information (PHI). The company must ensure compliance with all relevant privacy standards.

Which best practice recommendations will meet data protection and compliance requirements? (Choose three.)

Options:

A.  

Use, at minimum, the Business Critical edition of Snowflake.

B.  

Create Dynamic Data Masking policies and apply them to columns that contain PHI.

C.  

Use the Internal Tokenization feature to obfuscate sensitive data.

D.  

Use the External Tokenization feature to obfuscate sensitive data.

E.  

Rewrite SQL queries to eliminate projections of PHI data based on current_role().

F.  

Avoid sharing data with partner organizations.

Discussion 0
Questions 10

A retail company has 2000+ stores spread across the country. Store Managers report that they are having trouble running key reports related to inventory management, sales targets, payroll, and staffing during business hours. The Managers report that performance is poor and time-outs occur frequently.

Currently all reports share the same Snowflake virtual warehouse.

How should this situation be addressed? (Select TWO).

Options:

A.  

Use a Business Intelligence tool for in-memory computation to improve performance.

B.  

Configure a dedicated virtual warehouse for the Store Manager team.

C.  

Configure the virtual warehouse to be multi-clustered.

D.  

Configure the virtual warehouse to size 4-XL

E.  

Advise the Store Manager team to defer report execution to off-business hours.

Discussion 0
Questions 11

What Snowflake system functions are used to view and or monitor the clustering metadata for a table? (Select TWO).

Options:

A.  

SYSTEMSCLUSTERING

B.  

SYSTEMSTABLE_CLUSTERING

C.  

SYSTEMSCLUSTERING_DEPTH

D.  

SYSTEMSCLUSTERING_RATIO

E.  

SYSTEMSCLUSTERING_INFORMATION

Discussion 0
Questions 12

What transformations are supported in the below SQL statement? (Select THREE).

CREATE PIPE ... AS COPY ... FROM (...)

Options:

A.  

Data can be filtered by an optional where clause.

B.  

Columns can be reordered.

C.  

Columns can be omitted.

D.  

Type casts are supported.

E.  

Incoming data can be joined with other tables.

F.  

The ON ERROR - ABORT statement command can be used.

Discussion 0