Online Access Free ADA-C01 Practice Test

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.
An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.
What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Select TWO).

• A.OWNERSHIP
• B.MONITOR
• C.OPERATE
• D.MODIFY
• E.USAGE

A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:
use role USERADMIN;
create or replace role DEVELOPER_ROLE;
create user PTORRES PASSWORD = 'hello world!' MUST_CHANGE_PASSWORD = FALSE default_role = DEVELOPER_ROLE; The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails:
use DEVELOPER_ROLE;
Why does this command fail?

• A.USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.
• B.The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.
• C.The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.
• D.The new role can only take effect after USERADMIN has logged out.

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.Assign ownership privilege to DEV_TEAM on the newly-created schema.
• B.Set up the new schema as a managed-access schema.
• C.Set up future grants on the newly-created schemas.
• D.Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.

A Snowflake user runs a complex SQL query on a dedicated virtual warehouse that reads a large amount of data from micro-partitions. The same user wants to run another query that uses the same data set.
Which action would provide optimal performance for the second SQL query?

• A.Assign additional clusters to the virtual warehouse.
• B.Use the RESULT_SCAN function to post-process the output of the first query.
• C.Prevent the virtual warehouse from suspending between the running of the first and second queries.
• D.Increase the STATEMENT_TIMEOUT_IN_SECONDS parameter in the session.

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

• A.The role above the dropped role in the RBAC hierarchy
• B.The SYSADMIN role
• C.The SECURITYADMIN role
• D.The role executing the command