ACA-Database問題集、Alibaba Cloud実際の試験問題

質問 1

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

A. SQL Server

B. MySQL

C. PostreSQL

D. DB2

正解: A,B,C

解説: (PassTest メンバーにのみ表示されます)

質問 2

Which of the following features are provided by PolarDB-O's proxy? (Number of correct answers: 4)

A. Read/write splitting

B. Data encryption

C. Health checks for nodes

D. Load balancing

E. Failover strategies for high availability

正解: A,C,D,E

質問 3

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

A. 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

B. ACD

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/doc-detail/48980.html?spm=a2c5t.11065259.1996646101.searchclick

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

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

F. 3)

正解: B,F

質問 4

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?

A. 50%

B. 60%

C. 70%

D. 40%

正解: C

質問 5

Which of the following statements is NOT correct about the benefits you can gain through PolarDB?

A. Millisecond-level latency in physical replication

B. Elastic scaling within minutes

C. Large storage space

D. locked backup

E. When you add a read-only node in an ApsaraDB for PolarDB cluster, you only need to pay for computing resources

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 6

Which of the following tools can be used to migrate an on-premises database to Alibaba Cloud while causing minimal service downtime?

A. pg_dump

B. pg_upgrade D.DTS

C. pg_basebackup

D. pg_restore

正解: C

質問 7

Which of the following are NOT true, regarding DTS (Data Transmission Service)? (Number of correct answers: 2)

A. If the source database is not on Alibaba Cloud, it must be Internet accessible so that DTS can connect to it

B. The source and destination database must both have a database user which DTS can use

C. DTS is designed for file synchronization

D. The source and destination database must use the same database engine

正解: C,D

質問 8

Which of the following types of data that is stored in PostgreSQL databases can support the one-to-many data model? (Number of correct answers: 3)

A. Array

B. Range

C. GIS

D. JSONB

E. JSON

F. Cube

G. String

正解: A,E,G

質問 9

PolarDB for MySQL uses shared distributed storage and supports dual-zone deployment by default. How many data replicas are available across the two zones?

A. 3

B. 4

C. 5

D. 6

正解: D

Alibaba Cloud ACA Database Certification - ACA-Database 模擬練習