ACA Database Certification (ACA-Database) Free Practice Test

Question 1

When a backup file of core sensitive data is downloaded, business systems must be protected against data breaches. Which of the following capabilities must be enabled to ensure data security?

A. Virtual private cloud (VPC)

B. Transparent Data Encryption (TDE)

C. SOL audit

D. Secure Sockets Layer (SSL) encryption

Correct Answer: D

Question 2

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. High mount speeds (a few seconds)

C. Real-time synchronization

D. Online query and analysis

Correct Answer: A,B,C

Question 3

Which of the following statements about Alibaba Cloud ApsaraDB for MongoDB is true?

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

B. DataWorks is not supported for MongoDB data processing.

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

Correct Answer: A

Question 4

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

B. JSON

C. String

D. Array

E. Cube

F. JSONB

G. GIS

Correct Answer: B,C,D

Question 5

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

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

B. Geo-disaster recovery and active geo-redundancy for databases

C. Database migration without interrupting services / downtime

D. Configuring data audit rules to manage data quality.

E. Change tracking and data distribution.

F. Synchronizing information about user accounts and permissions.

Correct Answer: B,C,E

Question 6

Which of the following is NOT true, regarding DTS (Database Transmission Service)?

A. DTS works for database both on and off Alibaba Cloud

B. DTS can migrate both data and table schema

C. DTS supports multiple database engines

D. DTS cannot be used for incremental database synchronization

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

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

A. DB2

B. SQL Server

C. MySQL

D. PostreSQL

Correct Answer: B,C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

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. Logical migration tools

C. Incremental backup only

D. Full backup only

Correct Answer: B

Question 9

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

A. From a different cloud provider to Alibaba Cloud

B. From Alibaba Cloud RDS to other database systems

C. From RDS to an ECS-based database

D. From an RDS database, back to itself

Correct Answer: A,B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Alibaba Cloud ACA Database Certification (ACA-Database) Free Practice Test