Black Friday VIP Hour Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple75
Pass the Snowflake SnowPro Advanced: Administrator ADA-C02 Questions and answers with Dumpstech
Exam ADA-C02 Premium Access
View all detail and faqs for the ADA-C02 exam
Which role or roles should be used to correctly create the object needed to configure an OAuth 2.0 integration?
In which scenario does using an external table simplify a data pipeline?
An Administrator must create a sample from the LINEITEM table. The sample must not be repeatable, and the sampling function must select data in blocks of rows.
Which SELECT command generates a sample of 20% of the table?
In general, monthly database-replication billing is proportional to which variables?
Choose two
Which are characteristics of data replication in Snowflake?
Choose three
An Administrator must configure a Snowflake virtual warehouse for a new use case with these details:
B. etween 50 and 100 concurrent users will run reports.
C. osts must be minimized according to the number of users active at a particular time.
The virtual warehouse must automatically suspend and resume based on user activity.
Which configuration meets these requirements?
When adding secure views to a share in Snowflake, which function is required to authorize users from another account to access rows in a base table?
A Snowflake customer is incurring higher-than-expected costs while migrating data-warehouse workloads from on premises to Snowflake. The migration workloads run on one warehouse and consist of many small INSERT statements rather than bulk-loading large extracts. That warehouse is configured as a single 2XL cluster because many parallel INSERT statements are scheduled during nightly loads.
How can the Administrator lower costs while minimizing the overall time required to load data-warehouse history?
A Snowflake Administrator needs to retain all virtual warehouse configurations for auditing and backup. A table already exists with this schema:

Which commands should be run to persist the warehouse data at execution time in JSON format in the VWH_META table?
A Snowflake Administrator uses a multi-cluster virtual warehouse in the Snowflake Business-Critical edition. The minimum cluster count is set to 2, and the maximum cluster count is set to 10. This configuration performs well for the normal workload, which seldom exceeds 5 running clusters. However, once each month, several complex long-running queries increase queue time and cause the warehouse to reach its maximum of 10 clusters.
Which solutions will resolve the issues that occur once a month?
Choose two