Power Up Your Study Prep: Black Friday 75% Discount! Use coupon code below to save! - Ends in 0d 00h 00m 00s - Coupon code: big75certs

Complete ADA-C02 Snowflake Materials

Page: 5 / 5
Total 60 questions

SnowPro Advanced: Administrator Questions and Answers

Question 17

What is one characteristic of Snowflake’s transaction locking and concurrency model?

Options:

A.

A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.

B.

If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.

C.

Transaction locking in Snowflake is enforced exclusively at the row and table levels.

D.

Queries executed within a given transaction see that transaction's uncommitted changes.

Question 18

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?

Options:

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.

Page: 5 / 5
Total 60 questions