Alibaba Alibaba Certifications ACA-DATABASE Questions & Answers

• Question 51:

  Which of the following statements is NOT correct about the benefits you can gain through PolarDB?

  A. Large storage space

  B. Elastic scaling within minutes

  C. When you add a read-only node in an ApsaraDB for PolarDB cluster, you only need to pay for computing resources

  D. Millisecond-level latency in physical replication

  E. locked backup

  Correct Answer: E

  Lock-free backup. https://www.alibabacloud.com/help/doc- detail/58768.htm?spm=a2c63.p38356.b99.10.1bcb7338k86bX5

• Question 52:

  Which of the following tools can be used to migrate an on-premises database to Alibaba Cloud while causing minimal service downtime?

  A. pg_dump

  B. pg_restore

  C. pg_upgrade D.DTS

  D. pg_basebackup

  Correct Answer: D

• Question 53:

  Alibaba Cloud DTS (Data Transmission Service) supports both full database migration and incremental synchronization.

  A. True

  B. False

  Correct Answer: A

  https://www.alibabacloud.com/help/doc- detail/176633.htm?spm=a2c63.p38356.b99.32.3e751a4dtHm9cr https://www.alibabacloud.com/help/doc-detail/56776.htm?spm=a2c63.p38356.b99.181.74896b5dro6cDo

• Question 54:

  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

  Correct Answer: B

• Question 55:

  Which of the following tasks cannot be completed by using Advanced Database and Application Migration (ADAM)?

  A. De-Oracle workload evaluation

  B. Data structure conversion

  C. Data migration

  D. Performance monitoring

  Correct Answer: B

• Question 56:

  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

  Correct Answer: ACD

• Question 57:

  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

  Correct Answer: A

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

• Question 58:

  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

  Correct Answer: A

• Question 59:

  You want to migrate from MySQL to PostgreSQL: is this supported by DTS?

  A. No, this type of migration isn't supported

  B. You can migrate between MySQL and Oracle but not between PostgreSQL

  C. Yes, migration between different types of databases is supported by DTS

  Correct Answer: C

  https://www.alibabacloud.com/help/doc- detail/176064.htm?spm=a2c63.p38356.b99.7.3191591dPlcLJa

• Question 60:

  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

  Correct Answer: C