ExamGecko
Home / Snowflake / ARA-C01 / List of questions
Ask Question

Snowflake ARA-C01 Practice Test - Questions Answers, Page 5

Add to Whishlist

List of questions

Question 41

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 42

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 43

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 44

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 45

Report Export Collapse

What Snowflake features should be leveraged when modeling using Data Vault?

Become a Premium Member for full access
  Unlock Premium Member

Question 46

Report Export Collapse

A company's client application supports multiple authentication methods, and is using Okta.

What is the best practice recommendation for the order of priority when applications authenticate to Snowflake?

Become a Premium Member for full access
  Unlock Premium Member

Question 47

Report Export Collapse

What is a valid object hierarchy when building a Snowflake environment?

Become a Premium Member for full access
  Unlock Premium Member

Question 48

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 49

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 50

Report Export Collapse

An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects.

The STAGING schema has 50 days of retention.

The Architect runs the following statement:

CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00');

The Architect receives the following error: Time travel data is not available for schema STAGING. The requested time is either beyond the allowed time travel period or before the object creation time.

The Architect then checks the schema history and sees the following:

CREATED_ON|NAME|DROPPED_ON

2021-06-02 23:00:00 | STAGING | NULL

2021-05-01 10:00:00 | STAGING | 2021-06-02 23:00:00

How can cloning the STAGING schema be achieved?

Become a Premium Member for full access
  Unlock Premium Member
Total 162 questions
Go to page: of 17
Search

Related questions