ACA-DATABASE Online Practice Questions and Answers

Which of the following are the advantages of cloud databases over self-managed databases? (Number of correct answers: 3)

A. Stronger service level agreement (SLA)

B. Integrated operations and maintenance (OandM), as well as easier management

C. High availability and comprehensive backup and monitoring capabilities

D. High costs

Which of the following is the core benefit of ApsaraDB for Redis Enhanced Edition (Tair)?

A. Makes it easy to do business anywhere.

B. Makes data secure and independently managed.

C. Makes large amounts of data easier to process.

D. Makes data accessible online and in real time.

Which of the following computing capabilities are supported by AnalyticDB? (Number of correct answers: 4)

A. Complex extract, transform, load (ETL)

B. Interactive analysis

C. Simple point query

D. Real-time update

E. Machine Learning

From which of the following data sources or databases can Data Lake Analytics (DLA) read data for analysis? (Number of correct answers: 6)

A. MySQL

B. Oracle

C. OTS

D. MongoDB

E. AnolyticDB

F. HOLO

G. OSS

Which of the following specifications of AnalyticDB supports tiered storage of cold and hot data?

A. Basic Edition

B. C series

C. S series

D. Elastic Mode

Which of the following databases are supported by DTS (Database Transmission Service)? (Number of correct answers: 3)

A. MySQL

B. SQL Server

C. PostreSQL

D. DB2

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 is NOT supported by schema migration in Advanced Database and Application Migration (ADAM)?

A. Re-migrate all schemas

B. Re-migrate the failed schemas

C. Migrate the schemas that require a manual revision but have not been revised

D. Customize schema migration

Which are the supported DB engine for PolarDB so far? (The number of Answer: 3)

A. PolarDB for Mysql

B. PolarDB for Postgres

C. PolarDB for SQLserver

D. PolarDB for Oracle

Each PolarDB cluster consists of one primary node and one or more read-only nodes. The system only support manually switch over services from the primary node to a read-only node.

A. True

B. False