Latest ACA-Database Practice Tests with Actual Questions

Get Complete pool of questions with Premium PDF and Test Engine

Exam Code : ACA-Database
Exam Name : ACA Database Certification
Vendor Name : "Alibaba"

DTS is a data migration, integration, synchronization and change tracking tool. https://www.alibabacloud.com/help/doc-detail/176063.htm?spm=a2c63.l28256.b99.6.490d7142CiFvPb

Question: 3

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%

1. 50%

2. 60%

3. 70%

Answer: D
Question: 4

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.

1. True

2. False

Compared with single-zone clusters, multi-zone clusters can enhance disaster recovery capabilities and withstand the breakdown of an entire data center.

https://www.alibabacloud.com/help/doc-detail/122182.htm?spm=a2c63.p38356.879954.4.6f2fa25362cz60#task- 1580301

Question: 5

Which of the following is NOT true, regarding the sensitive data management feature provided by Data Management (DMS)?

1. The rules of field metadata and data content can be automatically recognized.

2. De-identification algorithms can be managed. Multiple algorithms are supported, such as algorithms for masking specific positions and replacing fixed characters.

3. Field-level and row-level permissions are supported.

4. After you configure de-identification algorithms, you can view the de-identified data.

Answer: D
Question: 6

Which of the following is the lowest recovery point objective (RPO) for Database Backup Service?

1. Seconds

2. Minutes

3. Hours

4. Days

Answer: B
Question: 7

Why is ApsaraDB for PolarDB better than other traditional database engines? (The number of

Answer: 3)

1. When you purchase a PolarDB cluster, you don't need to specify the storage capacity you want to purchase

2. PolarDB supports both OLTP and OLAP scenarios very well

3. The PolarDB database engine won't require you to replicate data when adding read-only nodes

4. ApsaraDB for PolarDB uses the pay-as-you-go billing method, therefore you only need to pay for the storage resources you actually use

Answer: A,C,D

Explanation:

Kernel Features: OLTP performance.

https://www.alibabacloud.com/help/doc-detail/172293.htm?spm=a2c63.p38356.b99.81.101b333ePsD0YF

Question: 8

Which database utility is used for data migration and synchronization?

1. DMS

2. DBS

3. DTS

4. DAS

5. ADAM

Answer: C

Explanation:

Data Transmission Service is charged based according to three models: Data Synchronization, Data Migration, Change Tracking. https://www.alibabacloud.com/product/data-transmission-service/pricing

Question: 9

Which of the following tasks cannot be completed by using Advanced Database & Application Migration (ADAM)?

1. De-Oracle workload evaluation

2. Data structure conversion

3. Data migration

4. Performance monitoring

Answer: B
Question: 10

Which of the following is not a component of the PolarDB-0 architecture in Apsara Stack?

1. FC Switch

2. SAN

3. Proxy

4. RDMA

Answer: B
Question: 11

Suppose you are using MySQL currently, if you want to migrate to cloud native database PolarDB with little effort, which one is the best choice?

1. PolarDB MySQL

2. PolarDB PosgreSQL

3. PolarDB Oracle

4. PolarDB Box

https://www.alibabacloud.com/help/doc-detail/58768.htm?spm=a2c63.l28256.b99.10.71ce3784cXj0y8

Question: 12

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

1. True

2. False

Answer: A

Explanation:

https://www.alibabacloud.com/help/doc-detail/26652.htm?spm=a2c63.p38356.879954.26.2ab232664Wkc2m#concept- xng-n1b-mhb

Question: 13

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

1. Complex extract, transform, load (ETL)

2. Interactive analysis

3. Simple point query

4. Real-time update

5. Machine Learning

Answer: A,B,D,E
Question: 14

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

1. Level-2 backup + Redo log

2. Level 1 backup + Redo log

3. Level-2 backup

4. Level-1 backup

Answer: A
Question: 15

Which database utility is good for database management and DevOps?

1. DMS

2. DBS

1. DAS

2. ADAM

Answer: A

Explanation:

Database DevOps Solutions. https://www.alibabacloud.com/product/data-management-service / https://www.alibabacloud.com/help/doc-detail/190124.htm?spm=a2c63.p38356.b99.40.6ad93d19Xe9h14

Question: 16

Which of the following statements is NOT correct about PolarDB?

1. ApsaraDB for PolarDB is a cloud-native relational database service that is compatible with the MySQL, PostgreSQL, and Oracle engines

2. Each ApsaraDB for PolarDB cluster supports up to 100 TB of storage space and can handle up to one million queries per second (QPS)

3. ApsaraDB for PolarDB can scale clusters within a few minutes, recover from failures within a few seconds, and guarantee data consistency

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

5. ApsaraDB for PolarDB is designed to handle large amounts of sequential queries

Answer: E

Explanation:

PolarDB is 6 times faster than standard MySQL database in handling large amounts of concurrent queries. https://www.alibabacloud.com/product/polardb

Question: 17

Which of the following features determines high performance of the performance-enhanced instances of ApsaraDB for Redis Enhanced Edition (Tair)?

1. Extended data structure modules

2. Multithreading

3. Global Replica

4. Data flashback

Answer: C
Question: 18

Which of the following is the high-availability service level that is specified in the ApsaraDB RDS Service Level Agreement (SLA)?

1. 90%

2. 99%

C. 99.5%

D. 99.99%

Answer: D
Question: 19

You are using DTS to migrate from a MySQL database installed on an ECS instance to a target database on RDS.

In the DTS console, which of these is the correct "Instance Type" for the database?

1. ECS-based Databases

2. Express Connect DB

3. RDS Instance

4. ApsaraDB MongoDB

Answer: C

Explanation:

https://www.alibabacloud.com/help/doc-detail/96154.htm?spm=a2c63.p38356.b99.118.59de5d1aWUVErx

Question: 20

What does DIM mean in data warehouse terms?

1. Dimension table

2. Operational data store (ODS)

3. Common data model (CDM)

4. Application data service (ADS)

Answer: A
Question: 21

Which of the following statements about MongoDB is NOT true?

1. MongoDB is a relational database.

2. MongoDB is a document database.

3. MongoDB supports transactions.

4. MongoDB can be deployed in cluster mode.

Answer: A
Question: 22

Alibaba Cloud DTS (Data Transmission Service) can only migrate between databases that are hosted

on RDS.

1. True

2. False

Answer: B

Explanation:

Alibaba Cloud Data Transmission Service (DTS) helps you migrate data between data stores, such as relational databases, NoSQL databases, and data warehouses. You can use DTS to migrate your data to Alibaba Cloud or between combinations of cloud and on-premises data systems. .

https://www.alibabacloud.com/help/doc-detail/176063.htm?spm=a2c63.p38356.b99.6.2ef8c790WL4Jku

Question: 23

Which of the following architectures are supported by ApsaraDB for Redis Enhanced Edition (Tair)? (Number of correct answers: 3)

1. Master-replica architecture in which standard master-replica instances are deployed

2. Read/write splitting architecture in which standard master-replica instances are deployed

3. Cluster master-replica instances

4. Single-node architecture

Answer: A,B,C
Question: 24

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.

1. True

2. False

Answer: B

Explanation:

PolarDB cluster supports Manually and Automatically switch over services between primary and read-only nodes. https://www.alibabacloud.com/help/doc-detail/141229.htm?spm=a2c63.p38356.b99.113.36df231dK2DVX0

Question: 25

CORRECT TEXT

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

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

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

3. 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.searchclickresult.75a932dfvCBnlt

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

Answer: A,C,D