Snowflake SnowPro Advanced Architect Certification - ARA-C01 Exam Questions

QUESTION NO: 1
A company wants to configure the Client Redirect feature on their Snowflake account to ensure business continuity during failover events.
How should an Architect accomplish this?

QUESTION NO: 2
A query shows a high number of bytes spilled to remote storage. The query includes a WHERE clause that filters out a large percentage of rows.
What actions can reduce spillage and improve performance? (Select TWO).

QUESTION NO: 3
An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group's manager (ORDER_MANAGER) has full DELETE privileges on the table.
How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?

QUESTION NO: 4
When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

QUESTION NO: 5
A company has several sites in different regions from which the company wants to ingest data.
Which of the following will enable this type of data ingestion?

QUESTION NO: 6
Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives.
How can a Snowflake Architect meet this requirement with the LEAST amount of coding? (Choose two.)

QUESTION NO: 7
A company needs to have the following features available in its Snowflake account:
1. Support for Multi-Factor Authentication (MFA)
2. A minimum of 2 months of Time Travel availability
3. Database replication in between different regions
4. Native support for JDBC and ODBC
5. Customer-managed encryption keys using Tri-Secret Secure
6. Support for Payment Card Industry Data Security Standards (PCI DSS)
In order to provide all the listed services, what is the MINIMUM Snowflake edition that should be selected during account creation?

QUESTION NO: 8
A company's table, employees, was accidentally replaced with a new version.

How can the original table be recovered with the LEAST operational overhead?

QUESTION NO: 9
A table for IOT devices that measures water usage is created. The table quickly becomes large and contains more than 2 billion rows.

The general query patterns for the table are:
1. DeviceId, lOT_timestamp and Customerld are frequently used in the filter predicate for the select statement
2. The columns City and DeviceManuf acturer are often retrieved
3. There is often a count on Uniqueld
Which field(s) should be used for the clustering key?

QUESTION NO: 10
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?

QUESTION NO: 11
An event table has 150B rows and 1.5M micro-partitions, with the following statistics:
Column NDV*
A_ID 11K
C_DATE 110
NAME 300K
EVENT_ACT_0 1.1G
EVENT_ACT_4 2.2G
*NDV = Number of Distinct Values
What three clustering keys should be used, in order?