ACA-Database Premium Exam Engine – Download Free PDF Questions [Q11-Q31]

4/5 - (1 vote)

ACA-Database Premium Exam Engine – Download Free PDF Questions

Instant Download ACA-Database Free Updated Test Dumps

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

Seconds

Minutes

Hours

Days

QUESTION 12
Which of the following features are provided by PolarDB-O’s proxy? (Number of correct answers: 4)

Read/write splitting

Load balancing

Health checks for nodes

Failover strategies for high availability

Data encryption

QUESTION 13
Which of the following are relational databases? (Number of correct answers: 5)

Oracle

MySQL

PostgreSQL

MongoDB

MariaDB

Redis

TSDB

HBase

SQL Server

QUESTION 14
Which of the following are the core technologies behind Database Backup Service? (Number of correct answers: 3)

Multi-cloud and multi-backend backup

Real-time synchronization

High mount speeds (a few seconds)

Online query and analysis

QUESTION 15
Which of the following statements about AnalyticDB for MySQL is true?

AnalyticDB for MySQL is a NoSQL database.

AnalyticDB for MySQL can be used to build enterprise-grade data warehouse projects.

AnalyticDB for MySQL can be used to build online transaction systems.

AnalyticDB for MySQL supports transactions.

QUESTION 16
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?

Ganos

Pase

Slot failover

High concurrency optimization

Point-in-time restore

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

The single-node Basic Edition architecture, which can be used in test and non-core production environments

The high-avail ability architecture, in which primary and read-only nodes are deployed to implement automatic failovers

The three-node Enterprise Edition architecture, which ensures zero data loss

The serverless architecture, in which computing resources are charged based on the Pay-As-You-Go (PAYG) billing method

QUESTION 18
Which migration modes are supported by DTS (Data Transmission Service)? (Number of correct answer: 3)

From Alibaba Cloud RDS to other database systems

From RDS to an ECS-based database

From a different cloud provider to Alibaba Cloud

From an RDS database, back to itself

Explanation
For database backup use DBS.
https://www.alibabacloud.com/help/doc-detail/59133.htm?spm=a2c63.l28256.b99.3.467e7530gZ9M6o

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

Structured data in rows and columns

Document-oriented unstructured data

Large amounts of time series data

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

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

True

False

Explanation
https://www.alibabacloud.com/help/doc-detail/26618.htm?spm=a2c63.p38356.b99.53.1c2b1156hNo8v0

QUESTION 21
Which of the following specifications of AnalyticDB supports tiered storage of cold and hot data?

Basic Edition

C series

S series

Elastic Mode

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

Simplicity for queries

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

Easier for data visualization

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

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

Level-2 backup + Redo log

Level 1 backup + Redo log

Level-2 backup

Level-1 backup

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

FC Switch

SAN

Proxy

RDMA

QUESTION 25
Which of the following are features supported by Alibaba Cloud RDS for MySQL? (The number of

Read-Write Splitting ->
https://www.alibabacloud.com/help/doc-detail/96047.htm?spm=a2c63.p38356.b99.57.500dc3c6Kt0QLs

Local Snapshot Backup-> Snapshot Backup is Cloud disk instance. Cross-region backup is Local disk instance.

Computing nodes and Storage totally seperated-> In the Basic Edition, your database system consists of only one primary RDS instance, and computing is separated from storage. This edition is cost-effective.
https://www.alibabacloud.com/help/doc-detail/48980.html?spm=a2c5t.11065259.1996646101.searchclick

Multi-Zone Deployment ->You can select the Single-zone Deployment or Multi-zone Development method.
https://www.alibabacloud.com/help/doc-detail/26092.htm?spm=a2c63.p38356.b99.18.118b4437l50tDl

ACD

QUESTION 26
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?

Full backup and incremental backup

Full backup only

Logical migration tools

Incremental backup only

QUESTION 27
Suppose you are using MySQL currently, if you want to migrate to cloud native database PolarDB with little effort, which one is the best choice?

PolarDB MySQL

PolarDB PosgreSQL

PolarDB Oracle

PolarDB Box

Explanation
https://www.alibabacloud.com/help/doc-detail/58768.htm?spm=a2c63.l28256.b99.10.71ce3784cXj0y8

QUESTION 28
Which of the following statements about MongoDB is NOT true?

MongoDB is a relational database.

MongoDB is a document database.

MongoDB supports transactions.

MongoDB can be deployed in cluster mode.

QUESTION 29
Alibaba Cloud DTS (Data Transmission Service) is a file migration tool.

True

False

Explanation
DTS is a data migration, integration, synchronization and change tracking tool.
https://www.alibabacloud.com/help/doc-detail/176063.htm?spm=a2c63.l28256.b99.6.490d7142CiFvPb

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

Interactive analysis

Batch processing

Online transaction processing

Stream or micro-batch processing

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

Loading …

Alibaba Cloud ACA-Database Exam Syllabus Topics:

Topic	Details
Topic 1	Infrastructure, core functions and application scenarios of Alibaba cloud database: Tair (Redis enterprise version) and Apsara DB for MongoDB
Topic 2	Database Overview Relational Database NoSQL Data Warehouse ADB database infrastructure, core functions and application scenarios
Topic 3	Core capabilities and basic operations of Alibaba Cloud database tools and utilities Fast construction of cloud native data
Topic 4	Common operation of Alibaba Cloud database (database creation, basic operation and maintenance, monitoring, connection, etc.)
Topic 5	Alibaba Cloud database products portfolio Basic concepts of database (SQL, index, view, transaction, log, etc.)
Topic 6	From cloud native to cloud dedicate: MyBase database dedicated cluster Development history and future trend of database
Topic 7	DLA infrastructure, core functions and application scenarios Cloud database edition and engine selection how-to