최신 SnowPro Advanced ADA-C02 무료샘플문제:

1. Which type of listing in the Snowflake Marketplace can be added and queried immediately?

A) Personalized listing
B) Standard listing
C) Regional listing
D) Monetized listing

2. 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?

A) 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.
B) 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.
C) 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.
D) 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.

3. 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?

A) To save costs on warehouse shutdowns and startups for different queries
B) To keep the data cache warm to support good performance of similar queries
C) To keep the query result cache warm for good performance on repeated queries
D) To save costs by running the warehouse as little as possible

4. The following commands were executed:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?

A) Both user A and user B can create tables in the PROD.WORKING schema.
B) All existing tables in schema PROD.WORKING will be visible to both users.
C) Tables created by either user A or user B will be visible to both users.
D) Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.

5. Which Snowflake objects can be managed using SCIM integration? (Choose two.)

A) Roles
B) Shares
C) Users
D) Stages
E) Warehouses

질문과 대답: