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 is the core benefit of ApsaraDB for Redis Enhanced Edition (Tair)?

A. Makes it easy to do business anywhere.

B. Makes data secure and independently managed.

C. Makes large amounts of data easier to process.

D. Makes data accessible online and in real time.

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

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

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

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/docdetail/48980.html?spm=a2c5t.11065259.1996646101.searchclickresult.75a932dfvCBnlt

D. Multi-Zone Deployment ->You can select the Single-zone Deployment or Multizone Development method. https://www.alibabacloud.com/help/docdetail/26092.htm?spm=a2c63.p38356.b99.18.118b4437l50tDl

Alibaba Cloud DTS (Data Transmission Service) is a file migration tool.

A. True

B. False

Which of the following are relational databases? (Number of correct answers: 5)

A. Oracle

B. MySQL

C. PostgreSQL

D. MongoDB

E. MariaDB

F. Redis

G. TSDB

H. HBase

I. SQL Server

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

A. MySQL

B. SQL Server

C. PostreSQL

D. DB2

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

Alibaba Cloud DTS (Database Transmission Service) only supports MySQL databases.

A. True

B. False

You can purchase more read-only nodes after you have created a cluster. If the primary node fails, the system automatically promotes the read-only node with the highest failover priority to become the new primary node while restoring the faulty node.

A. True

B. False

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