ACA-DATABASE Online Practice Questions and Answers

When a backup file of core sensitive data is downloaded, business systems must be protected against data breaches. Which of the following capabilities must be enabled to ensure data security?

A. Virtual private cloud (VPC)

B. Secure Sockets Layer (SSL) encryption

C. Transparent Data Encryption (TDE)

D. SOL audit

What is the maximum storage size that PolarDB currently provides?

A. 1TB

B. 10TB

C. 50TB

D. 100TB

Data Management (DMS) provides features related to data warehouse development to support task orchestration and recurring scheduling. Which of the following features are being developed? (Number of correct answers: 3)

A. Data lineage

B. Data quality

C. Data visualization

D. Data directory

E. Data service

When high availability switchovers occur in a database, which of the following features provided by ApsaraDB RDS for PostgreSQL can prevent the incremental data loss of logical subscriptions?

A. Ganos

B. Pase

C. Slot failover

D. High concurrency optimization

E. Point-in-time restore

Which of the following are the benefits of database views? (Number of correct answers: 3)

A. Simplicity for queries

B. Simplicity in structure: presents the database as a set of virtual tables specific to particular users or groups of users

C. Easier for data visualization

D. Stabilization of information: presents a consistent, unchanged image of the database structure

Alibaba Cloud DTS (Data Transmission Service) supports both full database migration and incremental synchronization.

A. True

B. False

Which of the following is not a feature or usage scenario of Data Lake Analytics (DLA)?

A. Interactive analysis

B. Batch processing

C. Online transaction processing

D. Stream or micro-batch processing

Which of the following are the core technologies behind Database Backup Service? (Number of correct answers: 3)

A. Multi-cloud and multi-backend backup

B. Real-time synchronization

C. High mount speeds (a few seconds)

D. Online query and analysis

If a database exception occurs in a PolarDB cluster because important data is deleted by mistake, how i can data be restored?

A. Level-2 backup + Redo log

B. Level 1 backup + Redo log

C. Level-2 backup

D. Level-1 backup

Suppose you are using MySQL currently, if you want to migrate to cloud native database PolarDB with little effort, which one is the best choice?

A. PolarDB MySQL

B. PolarDB PosgreSQL

C. PolarDB Oracle

D. PolarDB Box