We're so confident of our products that we provide no hassle product exchange.
Snowflake ADA-C02 Exam Overview:
| Certification Vendor: | Snowflake |
| Exam Name: | SnowPro Advanced: Administrator Certification |
| Exam Number: | ADA-C02 |
| Passing Score: | 750 (scaled score) |
| Available Languages: | English |
| Certificate Validity Period: | 2 years |
| Real Exam Qty: | 65 |
| Exam Format: | Multiple Choice, Multiple Select, True/False |
| Exam Duration: | 115 minutes |
| Related Certifications: | SnowPro Core Certification |
| Exam Price: | $370 USD |
| Sample Questions: | Snowflake ADA-C02 Sample Questions |
| Exam Way: | Online proctored or onsite at a testing center |
| Pre Condition: | SnowPro Core Certification and 2+ years of hands-on experience with Snowflake in a production environment |
| Official Syllabus URL: | https://learn.snowflake.com/en/certifications/snowpro-advanced-administrator-c02 |
Snowflake ADA-C02 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Performance and Monitoring | 20% | - Query performance optimization - Query history and profiling - Resource monitoring and management - Clustering keys |
| Topic 2: Account Management and Security | 25% | - Account management and billing - Security and governance management - User management and authentication - Role-Based Access Control (RBAC) |
| Topic 3: Virtual Warehouses | 20% | - Virtual warehouse creation and management - Resource monitors - Warehouse sizing and scaling - Warehouse performance optimization |
| Topic 4: Data Protection and Disaster Recovery | 15% | - Snowflake Marketplace - Data replication - Backup and restore procedures - Disaster recovery planning |
| Topic 5: Data Management | 20% | - Data sharing and replication - Database object management - Data loading and unloading - Time Travel and Fail-safe |
Snowflake SnowPro Advanced Administrator ADA-C02 Sample Questions:
1. A large international company with many operating regions requires data to be shared bi-directionally among all offices (head office to regional offices and regional offices among themselves). This company is a Snowflake account holder with European operations deployed in Microsoft Azure (single region) while North American regional offices are using AWS (single region) as their deployment cloud. This setup is required to comply with Personal Identifiable Information (PII) regulations in some of the European countries. The corporate head office is in Europe.
How can this data be shared bi-directionally, while MINIMIZING costs?
A) Use data replication everywhere to reduce costs associated with same-region sharing.
B) Move all the Snowflake accounts to a single region, and implement data sharing.
C) Use bi-directional data sharing among offices in the same region and replication among offices across the continents.
D) Use the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an external file management application to move files within the corporate VPC.
2. An Administrator receives data from a Snowflake partner. The partner is sharing a dataset that contains multiple secure views. The Administrator would like to configure the data so that only certain roles can see certain secure views.
How can this be accomplished?
A) Individually grant imported privileges onto the schema in the share.
B) Apply RBAC directly onto the partner's shared secure views.
C) Create views over the incoming shared database and apply the desired RBAC onto these views.
D) Clone the data and insert it into a company-owned share and apply the desired RBAC on the new tables.
3. What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Choose two.)
A) SYSADMIN
B) IMPORT PRIVILEGES and SHARED DATABASE
C) ACCOUNTADMIN
D) IMPORT SHARE and CREATE DATABASE
E) SECURITYADMIN
4. In general, the monthly billing for database replication is proportional to which variables? (Choose two.)
A) The frequency of the secondary database refreshes from the primary database
B) The frequency of changes to the primary database as a result of data loading or DML operations
C) The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts
D) The amount of table data in the primary database that changes as a result of data loading or DML operations
E) The number and size of warehouses defined in the primary account
5. A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references.
What set of object references needs to be re-pointed before granting access for usage?
A) There are no object references that need to be re-pointed
B) Sequences, storage integrations, views, secure views, and materialized views
C) Sequences, views, and secure views
D) Sequences, views, secure views, and materialized views
Solutions:
| Question # 1 Answer: C | Question # 2 Answer: C | Question # 3 Answer: C,D | Question # 4 Answer: A,D | Question # 5 Answer: A |
By Audrey
