ACA-Database by Alibaba Cloud Valid Free Exam Practice Test

Question 1

Which of the following architectures is not supported by ApsaraDB RDS for MySQL?

A. The three-node Enterprise Edition architecture, which ensures zero data loss B. The serverless architecture, in which computing resources are charged based on the Pay-As-You-Go (PAYG) billing method C. The high-avail ability architecture, in which primary and read-only nodes are deployed to implement automatic failovers D. The single-node Basic Edition architecture, which can be used in test and non-core production environments

Correct Answer: B

Question 2

If you have a development team with several developers working on cloud databases, which product is recommended to use for development collaboration?

A. DTS B. DAS C. DBS D. DMS E. DG

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

What does DIM mean in data warehouse terms?

A. Operational data store (ODS) B. Common data model (CDM) C. Dimension table D. Application data service (ADS)

Correct Answer: C

Question 4

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

A. Read-Write Splitting ->
https://www.alibabacloud.com/help/doc-detail/96047.htm?spm=a2c63.p38356.b99.57.500dc3c6Kt0QLs B. Multi-Zone Deployment ->You can select the Single-zone Deployment or Multi-zone Development method.
https://www.alibabacloud.com/help/doc-detail/26092.htm?spm=a2c63.p38356.b99.18.118b4437l50tDl C. 3) D. 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/doc-detail/48980.html?spm=a2c5t.11065259.1996646101.searchclick E. Local Snapshot Backup-> Snapshot Backup is Cloud disk instance. Cross-region backup is Local disk instance. F. ACD

Correct Answer: C,F

Question 5

Which of the following statements about the compatibility of AnalyticDB for PostgreSQL is NOT true?

A. Support for the Java Database Connectivity (JDBC) protocol B. Support for the SQL2003 syntax standard C. Compliance with PostgreSQL and Greenplum protocols D. Fully compatible with Oracle syntax

Correct Answer: D

Question 6

PolarDB for MySQL allows you to deploy a cluster across multiple zones. Compared with single-zone clusters, multi-zone clusters have better disaster recovery capabilities and can withstand data centre-level faults.

A. False B. True

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

Which of the following is NOT true, regarding DTS (Database Transmission Service)?

A. DTS works for database both on and off Alibaba Cloud B. DTS supports multiple database engines C. DTS can migrate both data and table schema D. DTS cannot be used for incremental database synchronization

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

Alibaba Cloud DTS (Database Transmission Service) only supports MySQL databases.

A. False B. True

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 9

Which of the following are relational databases? (Number of correct answers: 5)

A. MySQL B. MongoDB C. Oracle D. Redis E. MariaDB F. PostgreSQL G. SQL Server H. HBase I. TSDB

Correct Answer: A,C,E,F,G

Alibaba Cloud ACA Database Certification - ACA-Database Exam Practice Test