We're so confident of our products that we provide no hassle product exchange.
Snowflake SnowPro Advanced Administrator ADA-C02 Sample Questions:
1. 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? (Choose two.)
A) USAGE on the database and schema containing the task
B) OWNERSHIP on the task
C) OWNERSHIP on the database and schema containing the task
D) OPERATE on the task
E) EXECUTE TASK on the task
2. What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)
A) Resource monitors can be applied to more than one virtual warehouse.
B) Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.
C) The cost of running a resource monitor is only 10% of a credit, per day of operation.
D) Multiple triggers can be configured across various virtual warehouse thresholds.
E) Multiple resource monitors can be applied to a single virtual warehouse.
F) Resource monitors add no additional load to virtual warehouse compute.
3. When does auto-suspend occur for a multi-cluster virtual warehouse?
A) When the minimum number of clusters is running and there is no activity for the specified period of time.
B) Auto-suspend does not apply for multi-cluster warehouses.
C) When there has been no activity on any cluster for the specified period of time.
D) After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.
4. 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?
A) Set up the new schema as a managed-access schema.
B) Set up future grants on the newly-created schemas.
C) Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.
D) Assign ownership privilege to DEV_TEAM on the newly-created schema.
5. Which Snowflake objects can be managed using SCIM integration? (Choose two.)
A) Warehouses
B) Users
C) Shares
D) Stages
E) Roles
Solutions:
| Question # 1 Answer: A,D | Question # 2 Answer: A,D,E | Question # 3 Answer: A | Question # 4 Answer: B | Question # 5 Answer: B,E |
By Clara
