Alibaba Alibaba Certifications ACA-DATABASE Questions & Answers

• Question 21:

  From which of the following data sources or databases can Data Lake Analytics (DLA) read data for analysis? (Number of correct answers: 6)

  A. MySQL

  B. Oracle

  C. OTS

  D. MongoDB

  E. AnolyticDB

  F. HOLO

  G. OSS

  Correct Answer: ABCDEG

• Question 22:

  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

  Correct Answer: CD

• Question 23:

  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.

  Correct Answer: C

• Question 24:

  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

  Correct Answer: D

• Question 25:

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

  A. True

  B. False

  Correct Answer: B

  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 26:

  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

  Correct Answer: D

• Question 27:

  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

  Correct Answer: ABCEI

• Question 28:

  lf Oracle databases need to be migrated to Alibaba Cloud, which of the following product solutions :an be recommended? (Number of correct answers: 3)

  A. Use PolarDB-0 that is highly compatible with Oracle.

  B. Use Advanced Database and Application Migration (ADAM) to evaluate the migration project.

  C. Use ApsaraDB for Redis as a cache service to provide acceleration capabilities.

  D. Use Data Transmission Service (DTS) to migrate data.

  Correct Answer: ABD

• Question 29:

  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

  Correct Answer: ABC

  DB2 is supported, but very limited. https://www.alibabacloud.com/help/doc- detail/176064.htm?spm=a2c63.l28256.b99.7.13c27142yYyvXz

• Question 30:

  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

  Correct Answer: E

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