ACA-DATABASE Online Practice Questions and Answers

Which database utility is good for database management and DevOps?

A. DMS

B. DBS

C. DTS

D. DAS

E. ADAM

Which of the following are features supported by Alibaba Cloud RDS for MySQL? (The number of Answer: 3)

A. Read-Write Splitting -> https://www.alibabacloud.com/help/docdetail/96047.htm?spm=a2c63.p38356.b99.57.500dc3c6Kt0QLs

B. Local Snapshot Backup-> Snapshot Backup is Cloud disk instance. Cross-region backup is Local disk instance.

C. Computing nodes and Storage totally seperated-> In the Basic Edition, your database system consists of only one primary RDS instance, and computing is separated from storage. This edition is cost-effective. https://www.alibabacloud.com/help/docdetail/48980.html?spm=a2c5t.11065259.1996646101.searchclickresult.75a932dfvCBnlt

D. Multi-Zone Deployment ->You can select the Single-zone Deployment or Multizone Development method. https://www.alibabacloud.com/help/docdetail/26092.htm?spm=a2c63.p38356.b99.18.118b4437l50tDl

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

Alibaba Cloud DTS (Data Transmission Service) is a file migration tool.

A. True

B. False

Which of the following statements is NOT correct about PolarDB?

A. ApsaraDB for PolarDB is a cloud-native relational database service that is compatible with the MySQL, PostgreSQL, and Oracle engines

B. Each ApsaraDB for PolarDB cluster supports up to 100 TB of storage space and can handle up to one million queries per second (QPS)

C. ApsaraDB for PolarDB can scale clusters within a few minutes, recover from failures within a few seconds, and guarantee data consistency

D. An ApsaraDB for PolarDB cluster can also be scaled out to a maximum of 16 nodes, and provide up to 6 times of performance improvement traditional MySQL clusters at a 30% to 50% cost reduction

E. ApsaraDB for PolarDB is designed to handle large amounts of sequential queries

Which of the following scheduling tools are supported by AnalyticDB for MySQL? (Number of correct answers: 2)

A. DMS

B. Data Works

C. MaxCompute

D. QuickBl

Which of the following tasks cannot be completed by using Advanced Database and Application Migration (ADAM)?

A. De-Oracle workload evaluation

B. Data structure conversion

C. Data migration

D. Performance monitoring

Which type of the following logs is used to synchronize data between primary and secondary databases in RDS for MySQL?

A. Redo log

B. Rollback log

C. Binary log

D. Error log