Snowflake ARA-C01 Exam

Certification Provider: Snowflake

Exam Name: SnowPro Advanced: Architect Certification Exam

Number of questions in our database: 65

Exam Version: May. 24, 2023

ARA-C01 Exam Official Topics:

Topic 1: Single Topic

Free Snowflake ARA-C01 Exam Actual Questions

The questions for ARA-C01 were last updated On May. 24, 2023

Question #1

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

AAlter the Azure security integration to use the Private Link URLs.

BAdd the IP address in the error message to the allowed list in the network policy.

CGenerate a new SCIM access token using system$generate_scim_access_token and save it to Azure AD.

DUpdate the configuration of the Azure AD SSO to use the Private Link URLs.

EOpen a case with Snowflake Support to authorize the Private Link URLs' access to the account.

Reveal Solution

Correct Answer: B, C

Question #2

An Architect entered the following commands in sequence:

USER1 cannot find the table.

Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)

AGRANT ROLE PUBLIC TO ROLE INTERN;

BGRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;

CGRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;

DGRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;

EGRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;

Reveal Solution

Correct Answer: B, C

Question #3

A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging schem

a. One of the requirements is to have online recovery of data on a rolling 7-day basis.

After setting up the DATA_RETENTION_TIME_IN_DAYS at the database level, certain tables remain unrecoverable past 1 day.

What would cause this to occur? (Choose two.)

AThe staging schema has not been setup for MANAGED ACCESS.

BThe DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day.

CThe tables exceed the 1 TB limit for data recovery.

DThe staging tables are of the TRANSIENT type.

EThe DevOps role should be granted ALLOW_RECOVERY privilege on the staging schema.

Reveal Solution

Correct Answer: B, D

Question #4

Which steps are recommended best practices for prioritizing cluster keys in Snowflake? (Choose two.)

AChoose columns that are frequently used in join predicates.

BChoose lower cardinality columns to support clustering keys and cost effectiveness.

CChoose TIMESTAMP columns with nanoseconds for the highest number of unique rows.

DChoose cluster columns that are most actively used in selective filters.

EChoose cluster columns that are actively used in the GROUP BY clauses.

Reveal Solution

Correct Answer: A, D

Question #5

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

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

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

CUse the Internal Tokenization feature to obfuscate sensitive data.

DUse the External Tokenization feature to obfuscate sensitive data.

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

FAvoid sharing data with partner organizations.

Reveal Solution

Correct Answer: A, B, D

Unlock all ARA-C01 Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now

Disscuss Snowflake ARA-C01 Topics, Questions or Ask Anything Related

Submit Cancel