Black Friday Grand offer - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code = drift75
Pass the Snowflake SnowPro Advanced: Administrator ADA-C02 Questions and answers with ExamsMirror
Exam ADA-C02 Premium Access
View all detail and faqs for the ADA-C02 exam
0 Students Passed
0% Average Score
0% Same Questions
Which tasks are available to the ORGADMIN role?
Choose three
A user has enrolled in multi-factor authentication (MFA) to connect to Snowflake. The user tells the Snowflake Administrator that they lost their mobile phone the prior evening.
Which action should the Administrator take to enable the user to sign in to the system without revoking the user’s MFA enrollment?
An Administrator has a warehouse that is intended to have a credit quota of 3000 for every calendar year. The Administrator must create a resource monitor that performs these tasks:
At 80% usage, notify the account Administrators.
At 100% usage, suspend the warehouse and notify the account Administrators.
At 120% usage, stop all running executions, suspend the warehouse, and notify the account Administrators.
Which SQL command meets these requirements?
In which scenario does using an external table simplify a data pipeline?
Which Snowflake objects can be managed through SCIM integration?
Choose two
A sales team at an organization runs the following Snowflake query several times each day:

What can the Snowflake Administrator do to optimize use of persisted query results whenever possible?
An Administrator receives data from a Snowflake partner. The partner shares a dataset containing multiple secure views. The Administrator wants to configure access so that only specific roles can view specific secure views.
How can this be achieved?
Which access-control policy takes effect when future grants are assigned to both database-level and schema-level objects?
TOP CODES
Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.