Free Practice Questions for Alibaba ACA-Database Exam

Question 1

From which of the following data sources or databases can Data Lake Analytics (DLA) read data for analysis? (Number of correct answers: 6)

AMySQL

BOracle

COTS

DMongoDB

EAnolyticDB

FHOLO

GOSS

Correct Answer: A. MySQL; B. Oracle; C. OTS; D. MongoDB; E. AnolyticDB; G. OSS

Question 2

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

A1

B5

C10

D15

Correct Answer: D. 15

Question 3

Which of the following are NOT true, regarding DTS (Data Transmission Service)? (Number of correct answers: 2)

AThe source and destination database must use the same database engine

BThe source and destination database must both have a database user which DTS can use

CIf the source database is not on Alibaba Cloud, it must be Internet accessible so that DTS can connect to it

DDTS is designed for file synchronization

Correct Answer: A. The source and destination database must use the same database engine; D. DTS is designed for file synchronization

Question 4

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

A90%

B99%

C99.5%

D99.99%

Correct Answer: D. 99.99%

Question 5

Your DTS (Data Transmission Service) migration has failed halfway through: what options do you

have? (Number of correct answers: 2)

ADelete your DTS instance and start over

BRestart the migration task from the console

CYour database can't be migrated: you need to abandon the migration

DYou need to switch to ADAM, as DTS cannot complete the migration

Correct Answer: B. Restart the migration task from the console; D. You need to switch to ADAM, as DTS cannot complete the migration

Question 6

PolarDB for MySQL uses shared distributed storage and supports dual-zone deployment by default. How many data replicas are available across the two zones?

A3

B4

C5

D6

Correct Answer: D. 6

Question 7

Which of the following types of data are most suitable for storage in MySQL databases?

AStructured data in rows and columns

BDocument-oriented unstructured data

CLarge amounts of time series data

DKey-value (KV) data that is frequently read and written

Correct Answer: A. Structured data in rows and columns

Question 8

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

AFC Switch

BSAN

CProxy

DRDMA

Correct Answer: B. SAN

Question 9

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

AStandalone instance

BPrimary/secondary instance that consists of two nodes

CReplica set instance that consists of three nodes

DSharded cluster instance

EReplica set instance that consists of six nodes

Correct Answer: A. Standalone instance; C. Replica set instance that consists of three nodes; D. Sharded cluster instance

Question 10

When a backup file of core sensitive data is downloaded, business systems must be protected against data breaches. Which of the following capabilities must be enabled to ensure data security?

AVirtual private cloud (VPC)

BSecure Sockets Layer (SSL) encryption

CTransparent Data Encryption (TDE)

DSOL audit

Correct Answer: B. Secure Sockets Layer (SSL) encryption