ADA-C02 무료 덤프문제 온라인 액세스

DatabaseA has a single schema called Schema1. This schema contains many tables and views. The ANALYST role has privileges to select from all objects in DatabaseA.Schema1. The SYSADMIN role clones DatabaseA to DatabaseA_clone.
What privileges does the ANALYST role have on tables and views in DatabaseA_clone? (Choose two.)

• A.SELECT on all tables, and only non-secure views in DatabaseA_clone.Schema1
• B.SELECT on all tables and views in DatabaseA_clone.Schema1
• C.SELECT on all tables, and only secure views in DatabaseA_clone.Schema1
• D.USAGE on the schema DatabaseA_clone
• E.USAGE on the database DatabaseA_clone.Schema1

A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?

• A.Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
• B.Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.
• C.Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
• D.Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.

What is a characteristic of Snowflake's transaction locking and concurrency modeling?

• A.Transaction locking in Snowflake is enforced exclusively at the row and table levels.
• 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.Queries executed within a given transaction see that transaction's uncommitted changes.
• D.A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.

A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTS rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTS that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?

• A.There should be another 2XL warehouse deployed to handle a portion of the load queries.
• B.The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.
• C.The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.
• D.The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.

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? (Choose two.)

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