Labour Day Special 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

ACA Database Certification Question and Answers

ACA Database Certification

Last Update May 3, 2024
Total Questions : 80

We are offering FREE ACA-Database Alibaba Cloud exam questions. All you do is to just go and sign up. Give your details, prepare ACA-Database free exam questions and then go for complete pool of ACA Database Certification test questions that will help you more.

ACA-Database pdf

ACA-Database PDF

$35  $99.99
ACA-Database Engine

ACA-Database Testing Engine

$42  $119.99
ACA-Database PDF + Engine

ACA-Database PDF + Testing Engine

$56  $159.99
Questions 1

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

Options:

A.  

Seconds

B.  

Minutes

C.  

Hours

D.  

Days

Discussion 0
Questions 2

Which of these are NOT good use cases for DTS (Data Transmission Service)? (Number of correct

answers: 2)

Options:

A.  

Incremental synchronization for disaster recovery

B.  

Full database synchronization for database migration

C.  

Undoing changes made to a database by mistake

D.  

Saving database logs

Discussion 0
Questions 3

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

Options:

A.  

Level-2 backup + Redo log

B.  

Level 1 backup + Redo log

C.  

Level-2 backup

D.  

Level-1 backup

Discussion 0
Questions 4

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.

Options:

A.  

True

B.  

False

Discussion 0
Questions 5

Which of the following is not a relational database?

Options:

A.  

Oracle

B.  

DB2

C.  

Teradata

D.  

Redis

Discussion 0
Questions 6

PolarDB for MySQL archive databases use log-structured merge-trees (LSM trees) and the Zstandard (ZSTD) data compression algorithm to increase the data compression ratio. How much storage can be saved, at most?

Options:

A.  

40%

B.  

50%

C.  

60%

D.  

70%

Discussion 0
Questions 7

Which of the following is not a feature or usage scenario of Data Lake Analytics (DLA)?

Options:

A.  

Interactive analysis

B.  

Batch processing

C.  

Online transaction processing

D.  

Stream or micro-batch processing

Discussion 0
Questions 8

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

on RDS.

Options:

A.  

True

B.  

False

Discussion 0
Questions 9

Which of the following statements about Data Transmission Service (DTS) migration scenarios is NOT true?

Options:

A.  

DTS can migrate data in a circular way, for example, A > B > C >

A.  

B.  

DTS can migrate data from one source database to one destination database, for example, A >

B.  

C.  

DTS can migrate data from one source database to several destination databases, for example, A > B and A >

C.  

D.  

DTS can migrate data from several source databases to one destination database, for example, A > C and B > C.

Discussion 0
Questions 10

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

Options:

A.  

pg_dump

B.  

pg_restore

C.  

pg_upgrade D.DTS

D.  

pg_basebackup

Discussion 0
Questions 11

Which database utility is used for data migration and synchronization?

Options:

A.  

DMS

B.  

DBS

C.  

DTS

D.  

DAS

E.  

ADAM

Discussion 0
Questions 12

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

Options:

A.  

De-Oracle workload evaluation

B.  

Data structure conversion

C.  

Data migration

D.  

Performance monitoring

Discussion 0