Black Friday Countdown: 75% Off Exam Bundles! Use coupon code below before time runs out! - Ends in 0d 00h 00m 00s - Coupon code: 75vsure

ADA-C02 Exam Dumps - SnowPro Advanced: Administrator

Searching for workable clues to ace the Snowflake ADA-C02 Exam? You’re on the right place! ExamCert has realistic, trusted and authentic exam prep tools to help you achieve your desired credential. ExamCert’s ADA-C02 PDF Study Guide, Testing Engine and Exam Dumps follow a reliable exam preparation strategy, providing you the most relevant and updated study material that is crafted in an easy to learn format of questions and answers. ExamCert’s study tools aim at simplifying all complex and confusing concepts of the exam and introduce you to the real exam scenario and practice it with the help of its testing engine and real exam dumps

Go to page:
Question # 4

Under what condition does auto-suspend take place for a multi-cluster virtual warehouse?

A.

When there has been no activity on any cluster for the specified period of time.

B.

After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.

C.

When the minimum number of clusters is running and there is no activity for the specified period of time.

D.

Auto-suspend does not apply for multi-cluster warehouses.

Full Access
Question # 5

Which benefits result from creating and maintaining resource monitors in Snowflake?

Choose three

A.

The cost of running a resource monitor is only 10% of a credit, per day of operation.

B.

Multiple resource monitors can be applied to a single virtual warehouse.

C.

Resource monitors add no additional load to virtual warehouse compute.

D.

Multiple triggers can be configured across various virtual warehouse thresholds.

E.

Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.

F.

Resource monitors can be applied to more than one virtual warehouse.

Full Access
Question # 6

Which access-control policy takes effect when future grants are assigned to both database-level and schema-level objects?

A.

Database, privileges will take precedence over schema privileges.

B.

Schema privileges will take precedence over database privileges.

C.

An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.

D.

An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

Full Access
Question # 7

A company has many users assigned to the ANALYST role who regularly query Snowflake through a reporting tool. The Administrator observes that the ANALYST users continuously keep two small clusters busy and occasionally require three or four clusters of that same size.

B. ased on this scenario, how should the Administrator configure a virtual warehouse to MOST efficiently support this user group?

A.

Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.

B.

Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.

C.

Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.

D.

Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.

Full Access
Question # 8

Which roles or security privileges allow a consumer account to request and receive data from the Data Exchange?

Choose two

A.

SYSADMIN

B.

SECURITYADMIN

C.

ACCOUNTADMIN

D.

IMPORT SHARE and CREATE DATABASE

E.

IMPORT PRIVILEGES and SHARED DATABASE

Full Access
Go to page: