Summer Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: s2p65

Easiest Solution 2 Pass Your Certification Exams

ACA-Database Alibaba Cloud ACA Database Certification Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Alibaba Cloud ACA-Database ACA Database Certification certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Page: 1 / 2
Total 80 questions

With ApsaraDB for MyBase, problems caused by a sudden spike in traffic are automatically resolved. How is this done?

A.

ApsaraDB for My Base allows you to deploy different types of instances in a cluster.

B.

ApsaraDB for MyBase grants you host permissions. You can log on to hosts to troubleshoot business problems in an emergency.

C.

ApsaraDB for MyBase supports the over commitment of CPU and disk resources.

D.

ApsaraDB for MyBase supports elastic upgrade policies. If the resource utilization of a database exceeds the preset threshold during a business peak, ApsaraDB for MyBase can automatically upgrade database resource specifications to respond to the business peak.

E.

ApsaraDB for MyBase allows you to specify a host when you create an instance.

Which migration modes are supported by DTS (Data Transmission Service)? (Number of correct

answer: 3)

A.

From Alibaba Cloud RDS to other database systems

B.

From RDS to an ECS-based database

C.

From a different cloud provider to Alibaba Cloud

D.

From an RDS database, back to itself

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

A.

Read/write splitting

B.

Load balancing

C.

Health checks for nodes

D.

Failover strategies for high availability

E.

Data encryption

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 statements about Alibaba Cloud ApsaraDB for MongoDB is true?

A.

It takes a longer time to perform operations and maintenance (O&M) on ApsaraDB for MongoDB instances than on self-installed and self-managed MongoDB.

B.

DataWorks is not supported for MongoDB data processing.

C.

Alibaba Cloud and MongoDB have a strategic partnership, so Alibaba Cloud Is able to provide the latest MongoDB features in our ApsaraDB for MongoDB product, in all our global regions.

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

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?

A.

Ganos

B.

Pase

C.

Slot failover

D.

High concurrency optimization

E.

Point-in-time restore

You want to migrate from MySQL to PostgreSQL: is this supported by DTS?

A.

No, this type of migration isn't supported

B.

You can migrate between MySQL and Oracle but not between PostgreSQL

C.

Yes, migration between different types of databases is supported by DTS

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

DTS (Data Transmission Service) must have access to a database user account on both the target and source database, in order to work.

A.

True

B.

False

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

A.

The single-node Basic Edition architecture, which can be used in test and non-core production environments

B.

The high-avail ability architecture, in which primary and read-only nodes are deployed to implement automatic failovers

C.

The three-node Enterprise Edition architecture, which ensures zero data loss

D.

The serverless architecture, in which computing resources are charged based on the Pay-As-You-Go (PAYG) billing method

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

A.

The source and destination database must use the same database engine

B.

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

C.

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

D.

DTS is designed for file synchronization

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

Which of the following are the core technologies behind Database Backup Service? (Number of correct answers: 3)

A.

Multi-cloud and multi-backend backup

B.

Real-time synchronization

C.

High mount speeds (a few seconds)

D.

Online query and analysis

Which of the following features is NOT supported by Data Transmission Service (DTS)?

A.

Data migration

B.

Data synchronization

C.

Data backup

D.

Change tracking

Which of the following data is not collected when database information is collected in Advanced Database & Application Migration (ADAM)?

A.

Business structure data

B.

Historical performance data

C.

Database configuration data

D.

Business data

If a database exception occurs in a PolarDB cluster because important data is deleted by mistake, how i can data be restored?

A.

Level-2 backup + Redo log

B.

Level 1 backup + Redo log

C.

Level-2 backup

D.

Level-1 backup

You need to migrate a database that has a storage capacity of 50 GB to the cloud and can tolerate a service downtime of half an hour. In this case, which of the following migration methods is the optimal choice to migrate data to the cloud in terms of stability and availability?

A.

Full backup and incremental backup

B.

Full backup only

C.

Logical migration tools

D.

Incremental backup only

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.

40%

B.

50%

C.

60%

D.

70%

What does DIM mean in data warehouse terms?

A.

Dimension table

B.

Operational data store (ODS)

C.

Common data model (CDM)

D.

Application data service (ADS)

Page: 1 / 2
Total 80 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved