Alibaba Cloud ACA-DATABASE Online Practice Questions and Exam Preparation

Alibaba Cloud ACA-DATABASE Online Questions & Answers

• Question 21:

  Your DTS (Data Transmission Service) migration has failed halfway through: what options do you have? (Number of correct answers: 2)

  A. Delete your DTS instance and start over
  B. Restart the migration task from the console
  C. Your database can't be migrated: you need to abandon the migration
  D. You need to switch to ADAM, as DTS cannot complete the migration
  B. Restart the migration task from the console
  D. You need to switch to ADAM, as DTS cannot complete the migration

  ---

  Explanation/Reference:

• Question 22:

  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
  A. Use DTS (Data Transmission Service)

• Question 23:

  Which of the following is the lowest recovery point objective (RPO) for Database Backup Service?

  A. Seconds
  B. Minutes
  C. Hours
  D. Days
  B. Minutes

• Question 24:

  Which database utility is used for data migration and synchronization?

  A. DMS
  B. DBS
  C. DTS
  D. DAS
  E. ADAM
  C. DTS

  ---

  Explanation/Reference:

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

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

• Question 26:

  DTS (Data Transmission Service) must have access to a database user account on both the target and source database, in order to work.

  A. True
  B. False
  A. True

  ---

  Explanation/Reference:

  https://www.alibabacloud.com/help/doc-detail/26652.htm?spm=a2c63.p38356.879954.26.2ab232664Wkc2m#concept-xng-n1b- mhb

• Question 27:

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

  ---

  Explanation/Reference:

  Each node in a PolarDB cluster has a failover priority. The system performs the following steps to automatically elect a primary node:

  Find all the read-only nodes that can be elected as the primary node. Select one or more read-only nodes that have the highest failover priority. If the failover to the first node fails due to reasons, such as network issues and abnormal

  replication status, the system tries to switch to another node until the failover succeeds.

  https://www.alibabacloud.com/help/doc-detail/141229.htm?spm=a2c63.p38356.b99.113.36df231dK2DVX0

• Question 28:

  Which of the following deployment architectures are supported by Alibaba Cloud ApsaraDB for MongoDB? (Number of correct answers: 3)

  A. Standalone instance
  B. Primary/secondary instance that consists of two nodes
  C. Replica set instance that consists of three nodes
  D. Sharded cluster instance
  E. Replica set instance that consists of six nodes
  A. Standalone instance
  C. Replica set instance that consists of three nodes
  D. Sharded cluster instance

• Question 29:

  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
  A. JSON
  B. Array
  C. String

• Question 30:

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

  A. It takes a longer time to perform operations and maintenance (OandM) on ApsaraDB for MongoDB instances than on self-installed and self-managed MongoDB.
  B. DataWorks is not supported for MongoDB data processing.
  C. 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.
  C. 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.