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

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

Add to Whishlist

List of questions

Question 21

Report Export Collapse

A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size.

Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?

Become a Premium Member for full access
  Unlock Premium Member

Question 22

Report Export Collapse

Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

Become a Premium Member for full access
  Unlock Premium Member

Question 23

Report Export Collapse

A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.

For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?

Become a Premium Member for full access
  Unlock Premium Member

Question 24

Report Export Collapse

What SCIM integration types are supported in Snowflake? (Select THREE).

Become a Premium Member for full access
  Unlock Premium Member

Question 25

Report Export Collapse

A team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements:

USE ROLE SECURITYADMIN;

CREATE ROLE DEV TEAM;

GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;

GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;

Each team member's access is set up using the following statements:

USE ROLE SECURITYADMIN;

CREATE ROLE JDOE_PROFILE;

CREATE USER JDOE LOGIN NAME = 'JDOE' DEFAULT_ROLE='JDOE_PROFILE';

GRANT ROLE JDOE_PROFILE TO USER JDOE;

GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;

New tables created by any of the developers are not accessible by the team as a whole.

How can an Administrator address this problem?

Become a Premium Member for full access
  Unlock Premium Member

Question 26

Report Export Collapse

When a role is dropped, which role inherits ownership of objects owned by the dropped role?

Become a Premium Member for full access
  Unlock Premium Member

Question 27

Report Export Collapse

.

Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis.

Company A's Administrator created a share.

What object should be added to the share to allow Company B access to the files?

Become a Premium Member for full access
  Unlock Premium Member

Question 28

Report Export Collapse

A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.

There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, ith large amounts of bytes processed by even simple queries.

Why is this occurring?

Become a Premium Member for full access
  Unlock Premium Member

Question 29

Report Export Collapse

A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references.

What set of object references needs to be re-pointed before granting access for usage?

Become a Premium Member for full access
  Unlock Premium Member

Question 30

Report Export Collapse

Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

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

Related questions