ACA-DATABASE Online Practice Questions and Answers

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. Secure Sockets Layer (SSL) encryption

C. Transparent Data Encryption (TDE)

D. SOL audit

Which of the following statements about AnalyticDB for MySQL is true?

A. AnalyticDB for MySQL is a NoSQL database.

B. AnalyticDB for MySQL can be used to build enterprise-grade data warehouse projects.

C. AnalyticDB for MySQL can be used to build online transaction systems.

D. AnalyticDB for MySQL supports transactions.

Which of these are NOT good use cases for DTS (Data Transmission Service)? (Number of correct answers: 2)

A. Incremental synchronization for disaster recovery

B. Full database synchronization for database migration

C. Undoing changes made to a database by mistake

D. Saving database logs

You have a client that wants to move from another cloud provider's database service to RDS. Which of these is the best way to move their database to Alibaba Cloud?

A. Use DTS (Data Transmission Service)

B. Make a full physical backup of their database and copy it into OSS

C. This type of migration isn't possible

D. Migrate the entire VM hosting the database

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

Your client is having trouble connecting DTS to their source database in their local datacenter, why might this be?

A. Their database isn't on Alibaba Cloud already so it cannot be accessed by DTS

B. Their database is not accessible from the Internet, so DTS cannot access it

C. Their database must not include the special DTS compatibility mode

D. Their database is an inverted column store, which is not supported

Which of the following types of data are most suitable for storage in MySQL databases?

A. Structured data in rows and columns

B. Document-oriented unstructured data

C. Large amounts of time series data

D. Key-value (KV) data that is frequently read and written

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

A. True

B. False

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