Winter Special Flat 65% Limited Time Discount offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Alibaba Cloud ACA-Database ACA Database Certification Exam Practice Test

ACA Database Certification Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$42  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Question 1

Which of the following data is not collected when database information is collected in Advanced Database & Application Migration (ADAM)?

Options:

A.

Business structure data

B.

Historical performance data

C.

Database configuration data

D.

Business data

Question 2

Which of the following statements is NOT correct about PolarDB?

Options:

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

Question 3

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

Options:

A.

1

B.

5

C.

10

D.

15

Question 4

When high availability switchovers occur in a database, which of the following features provided by ApsaraDB RDS for PostgreSQL can prevent the incremental data loss of logical subscriptions?

Options:

A.

Ganos

B.

Pase

C.

Slot failover

D.

High concurrency optimization

E.

Point-in-time restore

Question 5

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

Options:

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

Question 6

Alibaba Cloud DTS (Database Transmission Service) only supports MySQL databases.

Options:

A.

True

B.

False

Question 7

Which of the following architectures is not supported by ApsaraDB RDS for MySQL?

Options:

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

Question 8

Which of the following are the advantages of cloud databases over self-managed databases? (Number of correct answers: 3)

Options:

A.

Stronger service level agreement (SLA)

B.

Integrated operations and maintenance (O&M), as well as easier management

C.

High availability and comprehensive backup and monitoring capabilities

D.

High costs

Question 9

Which of the following are database architectures which have emerged during the evolution of database systems? (Number of correct answers: 3)

Options:

A.

Single Instance

B.

Shared Nothing

C.

Shared Everything

D.

Dedicated

Question 10

Which of the following is not a component of the PolarDB-0 architecture in Apsara Stack?

Options:

A.

FC Switch

B.

SAN

C.

Proxy

D.

RDMA

Question 11

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

Options:

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

Question 12

Which of the following are the benefits of database views? (Number of correct answers: 3)

Options:

A.

Simplicity for queries

B.

Simplicity in structure: presents the database as a set of virtual tables specific to particular users or groups of users

C.

Easier for data visualization

D.

Stabilization of information: presents a consistent, unchanged image of the database structure