1. Home
  2. Alibaba Cloud
  3. Alibaba Database
  4. ACA-Database
  5. ACA Database Certification Questions and Answers

Pass the Alibaba Cloud Alibaba Database ACA-Database Questions and answers with CertsForce

 Alibaba Cloud Exams      Go to Exam Detail      Get Premium Access
Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions
Questions # 11:

Which of the following statements about Data Transmission Service (DTS) migration scenarios is NOT true?

Options:
A.

DTS can migrate data in a circular way, for example, A > B > C > A.

B.

DTS can migrate data from one source database to one destination database, for example, A > B.

C.

DTS can migrate data from one source database to several destination databases, for example, A > B and A > C.

D.

DTS can migrate data from several source databases to one destination database, for example, A > C and B > C.

Expert Solution
Questions # 12:

Which of the following are reasonable Data Transmission Service (DTS) use cases? (Number of correct answers: 4)

Options:
A.

Database migration without interrupting services / downtime

B.

Geo-disaster recovery and active geo-redundancy for databases

C.

Synchronizing data to data warehouses in real time to build data warehouses for real-time analytics.

D.

Configuring data audit rules to manage data quality.

E.

Synchronizing information about user accounts and permissions.

F.

Change tracking and data distribution.

Expert Solution
Questions # 13:

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

Options:
A.

True

B.

False

Expert Solution
Questions # 14:

Which of the followings is NOT a correct way to connect to PolarDB?

Options:
A.

Use the command line like 'mysql' to connect to a cluster

B.

Use DMS to connect to a cluster

C.

Use a client like HeidiSQL to connect to a cluster

D.

Use PolarDB console to log into a cluster

Expert Solution
Questions # 15:

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?

Options:
A.

Ganos

B.

Pase

C.

Slot failover

D.

High concurrency optimization

E.

Point-in-time restore

Expert Solution
Questions # 16:

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

Options:
A.

Basic Edition

B.

C series

C.

S series

D.

Elastic Mode

Expert Solution
Questions # 17:

PolarDB for MySQL archive databases use log-structured merge-trees (LSM trees) and the Zstandard (ZSTD) data compression algorithm to increase the data compression ratio. How much storage can be saved, at most?

Options:
A.

40%

B.

50%

C.

60%

D.

70%

Expert Solution
Questions # 18:

Which of the following statements is NOT correct about PolarDB?

Options:
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

Expert Solution
Questions # 19:

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

of correct answers: 3)

Options:
A.

MySQL

B.

SQL Server

C.

PostreSQL

D.

DB2

Expert Solution
Questions # 20:

Which of the following is the wrong statement about PolarDB design architecture?

Options:
A.

A PolarDB cluster contains one primary instance and up to 15 read-only instances

B.

PolarDB consolidate compute processes and storage processes in one box, allowing the database capacity to scale up and down to meet your

application needs in Alibaba Cloud

C.

Read/write splitting is enabled for PolarDB clusters by default, providing transparent, highly available, and self-adaptive load balancing for your

database

D.

High speed network connection is enabled between the DB server and the chunk server, and data are transferred using the Remote Direct Memory Access (RDMA) protocol

Expert Solution
Viewing page 2 out of 3 pages
Viewing questions 11-20 out of questions