Alibaba Alibaba Certifications ACA-DATABASE Questions & Answers

• Question 71:

  Which of the following statements about Data Management (DMS) permissions management is NOT true?

  A. You can assign different resources and operation permissions to an Alibaba Cloud account as needed.

  B. You must create different database accounts for each Alibaba Cloud account.

  C. You cannot directly submit changes even if you have permissions to make changes.

  D. The permissions of the accounts of resigned or transferred personnel can be automatically managed by using OpenAPI.

  Correct Answer: C

• Question 72:

  Which database utility is used for data migration and synchronization?

  A. DMS

  B. DBS

  C. DTS

  D. DAS

  E. ADAM

  Correct Answer: C

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

  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?

  A. ECS-based Databases

  B. Express Connect DB

  C. RDS Instance

  D. ApsaraDB MongoDB

  Correct Answer: C

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

• Question 74:

  Which type of the following logs is used to synchronize data between primary and secondary databases in RDS for MySQL?

  A. Redo log

  B. Rollback log

  C. Binary log

  D. Error log

  Correct Answer: C

• Question 75:

  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?

  A. PolarDB MySQL

  B. PolarDB PosgreSQL

  C. PolarDB Oracle

  D. PolarDB Box

  Correct Answer: A

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

• Question 76:

  Which of the following features is provided by Data Management (DMS)?

  A. Integrates data across multiple data sources

  B. Backs up multiple types of databases

  C. Evaluates the database migration project

  D. Enables online database management, such as data query, database and table management, and permission management

  Correct Answer: C

• Question 77:

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

  B. Array

  C. String

  D. Cube

  E. Range

  F. JSONB

  G. GIS

  Correct Answer: ABC

• Question 78:

  Which are the supported DB engine for PolarDB so far? (The number of Answer: 3)

  A. PolarDB for Mysql

  B. PolarDB for Postgres

  C. PolarDB for SQLserver

  D. PolarDB for Oracle

  Correct Answer: ABD

  PolarDB is a cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle. https://www.alibabacloud.com/product/polardb

• Question 79:

  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.

  A. True

  B. False

  Correct Answer: B

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

  Which of the following statements about Data Transmission Service (DTS) migration scenarios is NOT true?

  A. DTS can migrate data in a circular way, for example, A > B > C > A.

  B. DTS can migrate data from one source database to one destination database, for example, A > B.

  C. DTS can migrate data from one source database to several destination databases, for example, A > B and A > C.

  D. DTS can migrate data from several source databases to one destination database, for example, A > C and B > C.

  Correct Answer: A