Alibaba Cloud ACA-DATABASE Online Practice Questions and Exam Preparation

Alibaba Cloud ACA-DATABASE Online Questions & Answers

• Question 1:

  Which of the following is not a relational database?

  A. Oracle
  B. DB2
  C. Teradata
  D. Redis
  D. Redis

• Question 2:

  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
  D. The serverless architecture, in which computing resources are charged based on the Pay-As-You-Go (PAYG) billing method

• Question 3:

  Alibaba Cloud DTS (Data Transmission Service) can only migrate between databases that are hosted on RDS.

  A. True
  B. False
  B. False

  ---

  Explanation/Reference:

  Alibaba Cloud Data Transmission Service (DTS) helps you migrate data between data stores, such as relational databases, NoSQL databases, and data warehouses. You can use DTS to migrate your data to Alibaba Cloud or between combinations of cloud and on-premises data systems. https://www.alibabacloud.com/help/doc-detail/176063.htm?spm=a2c63.p38356.b99.6.2ef8c790WL4Jku

• Question 4:

  If a database exception occurs in a PolarDB cluster because important data is deleted by mistake, how i can data be restored?

  A. Level-2 backup + Redo log
  B. Level 1 backup + Redo log
  C. Level-2 backup
  D. Level-1 backup
  A. Level-2 backup + Redo log

• Question 5:

  What is the maximum number of read-only nodes in a PolarDB cluster?

  A. 1
  B. 5
  C. 10
  D. 15
  D. 15

• Question 6:

  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
  E. ApsaraDB for PolarDB is designed to handle large amounts of sequential queries

  ---

  Explanation/Reference:

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

• Question 7:

  Which of the following features are provided by PolarDB-O's proxy? (Number of correct

  A. Read/write splitting
  B. Load balancing
  C. Health checks for nodes
  D. Failover strategies for high availability
  E. Data encryption
  A. Read/write splitting
  B. Load balancing
  C. Health checks for nodes
  D. Failover strategies for high availability

  ---

  Explanation/Reference:

• Question 8:

  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.
  A. Use PolarDB-0 that is highly compatible with Oracle.
  B. Use Advanced Database and Application Migration (ADAM) to evaluate the migration project.
  D. Use Data Transmission Service (DTS) to migrate data.

• Question 9:

  Which of the following is the high-availability service level that is specified in the ApsaraDB RDS Service Level Agreement (SLA)?

  A. 90%
  B. 99%
  C. 99.5%
  D. 99.99%
  D. 99.99%

• Question 10:

  What is the maximum storage size that PolarDB currently provides?

  A. 1TB
  B. 10TB
  C. 50TB
  D. 100TB
  D. 100TB

  ---

  Explanation/Reference:

  Each PolarDB cluster supports to scale up to 100 TB. https://www.alibabacloud.com/product/polardb