ACA-Database 実際試験問題と解答 - 模擬練習 - 受験自信を増やす

Question No : 1
CORRECT TEXT
Which of the following are features supported by Alibaba Cloud RDS for MySQL? (The number of Answer 3)

A.Read-Write Splitting -> https://www.alibabacloud.com/help/doc-detail/96047.htm?spm=a2c63.p38356.b99.57.500dc3c6Kt0QLs
B.Local Snapshot Backup-> Snapshot Backup is Cloud disk instance. Cross-region backup is Local disk instance.
C.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.searchclickresult.75a932dfvCBnlt
D.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

正解:

Question No : 2
Each PolarDB cluster consists of one primary node and one or more read-only nodes. The system only support manually switch over services from the primary node to a read-only node.

A.True
B.False

正解:
Explanation:
PolarDB cluster supports Manually and Automatically switch over services between primary and read-only nodes. https://www.alibabacloud.com/help/doc-detail/141229.htm?spm=a2c63.p38356.b99.113.36df231dK2DVX0

Question No : 3
Which of the following architectures are supported by ApsaraDB for Redis Enhanced Edition (Tair)? (Number of correct answers: 3)

A.Master-replica architecture in which standard master-replica instances are deployed
B.Read/write splitting architecture in which standard master-replica instances are deployed
C.Cluster master-replica instances
D.Single-node architecture

正解:

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

A.True
B.False

正解:
Explanation:
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 No : 5
Which of the following statements about MongoDB is NOT true?

A.MongoDB is a relational database.
B.MongoDB is a document database.
C.MongoDB supports transactions.
D.MongoDB can be deployed in cluster mode.

正解:

Question No : 6
What does DIM mean in data warehouse terms?

A.Dimension table
B.Operational data store (ODS)
C.Common data model (CDM)
D.Application data service (ADS)

正解:

Question No : 7
You are using DTS to migrate from a MySQL database installed on an ECS instance to a target
database on RDS.
In the DTS console, which of these is the correct "Instance Type" for the database?

A.ECS-based Databases
B.Express Connect DB
C.RDS Instance
D.ApsaraDB MongoDB

正解:
Explanation:
https://www.alibabacloud.com/help/doc-detail/96154.htm?spm=a2c63.p38356.b99.118.59de5d1aWUVErx

Question No : 8
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%

正解:

Question No : 9
Which of the following features determines high performance of the performance-enhanced instances of ApsaraDB for Redis Enhanced Edition (Tair)?

A.Extended data structure modules
B.Multithreading
C.Global Replica
D.Data flashback

正解:

Question No : 10
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

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

Question No : 11
Which database utility is good for database management and DevOps?

A.DMS
B.DBS
C.DTS
D.DAS
E.ADAM

正解:
Explanation:
Database DevOps Solutions. https://www.alibabacloud.com/product/data-management-service / https://www.alibabacloud.com/help/doc-detail/190124.htm?spm=a2c63.p38356.b99.40.6ad93d19Xe9h14

Question No : 12
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

正解:

Question No : 13
Which of the following computing capabilities are supported by AnalyticDB? (Number of correct answers: 4)

A.Complex extract, transform, load (ETL)
B.Interactive analysis
C.Simple point query
D.Real-time update
E.Machine Learning

正解:

Question No : 14
DTS (Data Transmission Service) must have access to a database user account on both the target and source database, in order to work.

A.True
B.False

正解:
Explanation:
https://www.alibabacloud.com/help/doc-detail/26652.htm?spm=a2c63.p38356.879954.26.2ab232664Wkc2m#concept-xng-n1b-mhb

Question No : 15
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?

A.PolarDB MySQL
B.PolarDB PosgreSQL
C.PolarDB Oracle
D.PolarDB Box

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

Alibaba Cloud ACA-Database 問題練習