Snowflake ARA-C01 Real Exam Questions
The questions for ARA-C01 were last updated at Dec 22,2024.
- Exam Code: ARA-C01
- Exam Name: SnowPro Advanced Architect Certification
- Certification Provider: Snowflake
- Latest update: Dec 22,2024
The following DDL command was used to create a task based on a stream:
Assuming MY_WH is set to auto_suspend C 60 and used exclusively for this task, which statement is true?
- A . The warehouse MY_WH will be made active every five minutes to check the stream.
- B . The warehouse MY_WH will only be active when there are results in the stream.
- C . The warehouse MY_WH will never suspend.
- D . The warehouse MY_WH will automatically resize to accommodate the size of the stream.
Which security, governance, and data protection features require, at a MINIMUM, the Business Critical edition of Snowflake? (Choose two.)
- A . Extended Time Travel (up to 90 days)
- B . Customer-managed encryption keys through Tri-Secret Secure
- C . Periodic rekeying of encrypted data
- D . AWS, Azure, or Google Cloud private connectivity to Snowflake
- E . Federated authentication and SSO
An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously.
Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)
- A . COPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;
- B . COPY INTO tablea FROM @%tablea;
- C . COPY INTO tablea FROM @%tablea FILES = (‘file5.csv’);
- D . COPY INTO tablea FROM @%tablea FORCE = TRUE;
- E . COPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;
- F . COPY INTO tablea FROM @%tablea MERGE = TRUE;
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?
- A . Create a stored procedure that runs with caller’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
- B . Create a stored procedure that can be run using both caller’s and owner’s rights (allowing the user to specify which rights are used during execution), and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
- C . Create a stored procedure that runs with owner’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.
- D . This scenario would actually not be possible in Snowflake C any user performing a DELETE on a table requires the DELETE privilege to be granted to the role they are using.
A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy.
Which requirements will be addressed with this approach? (Choose two.)
- A . There needs to be fewer objects per tenant.
- B . Security and Role-Based Access Control (RBAC) policies must be simple to configure.
- C . Compute costs must be optimized.
- D . Tenant data shape may be unique per tenant.
- E . Storage costs must be optimized.
How is the change of local time due to daylight savings time handled in Snowflake tasks? (Choose two.)
- 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.
A table contains five columns and it has millions of records.
The cardinality distribution of the columns is shown below:
Column C4 and C5 are mostly used by SELECT queries in the GROUP BY and ORDER BY clauses.
Whereas columns C1, C2 and C3 are heavily used in filter and join conditions of SELECT queries.
The Architect must design a clustering key for this table to improve the query performance.
Based on Snowflake recommendations, how should the clustering key columns be ordered while defining the multi-column clustering key?
- A . C5, C4, C2
- B . C3, C4, C5
- C . C1, C3, C2
- D . C2, C1, C3
A company is using a Snowflake account in Azure. The account has SAML SSO set up using ADFS as a SCIM identity provider.
To validate Private Link connectivity, an Architect performed the following steps:
* Confirmed Private Link URLs are working by logging in with a username/password account
* Verified DNS resolution by running nslookups against Private Link URLs
* Validated connectivity using SnowCD
* Disabled public access using a network policy set to use the company’s IP address range However, the following error message is received when using SSO to log into the company account: IP XX.XXX.XX.XX is not allowed to access snowflake. Contact your local security administrator.
What steps should the Architect take to resolve this error and ensure that the account is accessed using only Private Link? (Choose two.)
- A . Alter the Azure security integration to use the Private Link URLs.
- B . Add the IP address in the error message to the allowed list in the network policy.
- C . Generate a new SCIM access token using system$generate_scim_access_token and save it to Azure AD.
- D . Update the configuration of the Azure AD SSO to use the Private Link URLs.
- E . Open a case with Snowflake Support to authorize the Private Link URLs’ access to the account.
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 . 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.
An Architect would like to save quarter-end financial results for the previous six years.
Which Snowflake feature can the Architect use to accomplish this?
- A . Search optimization service
- B . Materialized view
- C . Time Travel
- D . Zero-copy cloning
- E . Secure views