ExamGecko
Home / Snowflake / ADA-C01
Ask Question

Snowflake ADA-C01 Practice Test - Questions Answers, Page 7

Question list
Search

List of questions

Search

Related questions











Question 61

Report
Export
Collapse

What are characteristics of data replication in Snowflake? (Select THREE).

Become a Premium Member for full access
  Unlock Premium Member

Question 62

Report
Export
Collapse

An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.

What privileges should be granted to the user to meet these requirements? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 63

Report
Export
Collapse

A large international company with many operating regions requires data to be shared bi-directionally among all offices (head office to regional offices and regional offices among themselves). This company is a Snowflake account holder with European operations deployed in Microsoft Azure (single region) while North American regional offices are using AWS (single region) as their deployment cloud. This setup is required to comply with Personal Identifiable Information (PII) regulations in some of the European countries. The corporate head office is in Europe.

How can this data be shared bi-directionally, while MINIMIZING costs?

Become a Premium Member for full access
  Unlock Premium Member

Question 64

Report
Export
Collapse

What are benefits of using Snowflake organizations? (Select TWO).

Become a Premium Member for full access
  Unlock Premium Member

Question 65

Report
Export
Collapse

What access control policy will be put into place when future grants are assigned to both database and schema objects?

Become a Premium Member for full access
  Unlock Premium Member

Question 66

Report
Export
Collapse

An Administrator is evaluating a complex query using the EXPLAIN command. The Globalstats operation indicates 500 partitionsAssigned.

The Administrator then runs the query to completion and opens the Query Profile. They notice that the partitions scanned value is 429.

Why might the actual partitions scanned be lower than the estimate from the EXPLAIN output?

Become a Premium Member for full access
  Unlock Premium Member

Question 67

Report
Export
Collapse

Review the output of the SHOW statement below which displays the current grants on the table DB1. S1. T1:

Snowflake ADA-C01 image Question 67 72982 09232024004351000000

This statement is executed:

USE ROLE ACCOUNTADMIN;

DROP ROLE A;

What will occur?

Become a Premium Member for full access
  Unlock Premium Member

Question 68

Report
Export
Collapse

A company's Snowflake account has multiple roles. Each role should have access only to data that resides in the given role's specific region.

When creating a row access policy, which code snippet below will provide privileges to the role ALL_ACCESS_ROLE to see all rows regardless of region, while the other roles can only see rows for their own regions?

Become a Premium Member for full access
  Unlock Premium Member

Question 69

Report
Export
Collapse

An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.

What select command will generate a sample of 20% of the table?

Become a Premium Member for full access
  Unlock Premium Member

Question 70

Report
Export
Collapse

How should an Administrator configure a Snowflake account to use AWS PrivateLink?

Become a Premium Member for full access
  Unlock Premium Member
Total 72 questions
Go to page: of 8