[Q30-Q52] Certification Training for ACA-Database Exam Dumps Test Engine [2022]

Certification Training for ACA-Database Exam Dumps Test Engine [2022]

Mar 10, 2022 Step by Step Guide to Prepare for ACA-Database Exam

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	From cloud native to cloud dedicate: MyBase database dedicated cluster Development history and future trend of database
Topic 3	Infrastructure, core functions and application scenarios of PolarDB, which is Alibaba Cloud Native database representative Mainstream tools include: ADAM, DTS, DMS, DBS
Topic 4	Database Overview Relational Database NoSQL Data Warehouse ADB database infrastructure, core functions and application scenarios
Topic 5	Core capabilities and basic operations of Alibaba Cloud database tools and utilities Fast construction of cloud native data
Topic 6	Common operation of Alibaba Cloud database (database creation, basic operation and maintenance, monitoring, connection, etc.)
Topic 7	Alibaba Cloud database products portfolio Basic concepts of database (SQL, index, view, transaction, log, etc.)

 

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

• A. False
• B. True

Answer: A

Explanation:
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

 

NEW QUESTION 31
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.

• A. True
• B. False

Answer: A

Explanation:
Explanation
Each node in a PolarDB cluster has a failover priority. The system performs the following steps to automatically elect a primary node:
Find all the read-only nodes that can be elected as the primary node.
Select one or more read-only nodes that have the highest failover priority.
If the failover to the first node fails due to reasons, such as network issues and abnormal replication status, the system tries to switch to another node until the failover succeeds.
https://www.alibabacloud.com/help/doc-detail/141229.htm?spm=a2c63.p38356.b99.113.36df231dK2DVX0

 

NEW QUESTION 32
What is the maximum storage size that PolarDB currently provides?

• A. 100TB
• B. 10TB
• C. 1TB
• D. 50TB

Answer: A

Explanation:
Explanation
Each PolarDB cluster supports to scale up to 100 TB. https://www.alibabacloud.com/product/polardb

 

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

• A. False
• B. True

Answer: A

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

 

NEW QUESTION 34
Why is ApsaraDB for PolarDB better than other traditional database engines? (The number of answer: 3)

• A. PolarDB supports both OLTP and OLAP scenarios very well
• B. ApsaraDB for PolarDB uses the pay-as-you-go billing method, therefore you only need to pay for the storage resources you actually use
• C. The PolarDB database engine won't require you to replicate data when adding read-only nodes
• D. When you purchase a PolarDB cluster, you don't need to specify the storage capacity you want to purchase

Answer: B,C,D

Explanation:
Explanation
Kernel Features: OLTP performance.
https://www.alibabacloud.com/help/doc-detail/172293.htm?spm=a2c63.p38356.b99.81.101b333ePsD0YF

 

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

• A. Performance monitoring
• B. Data structure conversion
• C. De-Oracle workload evaluation
• D. Data migration

Answer: B

 

NEW QUESTION 36
Which of the following types of data that is stored in PostgreSQL databases can support the one-to-many data model? (Number of correct answers: 3)

• A. String
• B. Array
• C. JSON
• D. Cube
• E. Range
• F. JSONB
• G. GIS

Answer: A,B,C

 

NEW QUESTION 37
Which of the following is NOT true, regarding DTS (Database Transmission Service)?

• A. DTS can migrate both data and table schema
• B. DTS works for database both on and off Alibaba Cloud
• C. DTS cannot be used for incremental database synchronization
• D. DTS supports multiple database engines

Answer: C

Explanation:
Explanation
https://www.alibabacloud.com/help/doc-detail/56776.htm?spm=a2c63.p38356.b99.181.74896b5dro6cDo

 

NEW QUESTION 38
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 Box
• B. PolarDB Oracle
• C. PolarDB PosgreSQL
• D. PolarDB MySQL

Answer: D

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

 

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

• A. DTS can migrate data from one source database to one destination database, for example, A > B.
• B. DTS can migrate data from several source databases to one destination database, for example, A > C and B > C.
• 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 in a circular way, for example, A > B > C > A.

Answer: D

 

NEW QUESTION 40
You have a client that wants to move from another cloud provider's database service to RDS. Which of these is the best way to move their database to Alibaba Cloud?

• A. Migrate the entire VM hosting the database
• B. This type of migration isn't possible
• C. Make a full physical backup of their database and copy it into OSS
• D. Use DTS (Data Transmission Service)

Answer: D

 

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

• A. Data encryption
• B. Load balancing
• C. Read/write splitting
• D. Failover strategies for high availability
• E. Health checks for nodes

Answer: B,C,D,E

 

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

• A. Business data
• B. Business structure data
• C. Database configuration data
• D. Historical performance data

Answer: A

 

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

• A. Structured data in rows and columns
• B. Large amounts of time series data
• C. Key-value (KV) data that is frequently read and written
• D. Document-oriented unstructured data

Answer: A

 

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

• A. 0
• B. 1
• C. 2
• D. 3

Answer: B

 

NEW QUESTION 45
Which type of the following logs is used to synchronize data between primary and secondary databases in RDS for MySQL?

• A. Redo log
• B. Error log
• C. Binary log
• D. Rollback log

Answer: C

 

NEW QUESTION 46
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. Express Connect DB
• B. ApsaraDB MongoDB
• C. ECS-based Databases
• D. RDS Instance

Answer: D

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

 

NEW QUESTION 47
PolarDB for MySQL allows you to deploy a cluster across multiple zones. Compared with single-zone clusters, multi-zone clusters have better disaster recovery capabilities and can withstand data centre-level faults.

• A. True
• B. False

Answer: A

 

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

• A. Standalone instance
• B. Primary/secondary instance that consists of two nodes
• C. Replica set instance that consists of six nodes
• D. Replica set instance that consists of three nodes
• E. Sharded cluster instance

Answer: A,D,E

 

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

• A. When you add a read-only node in an ApsaraDB for PolarDB cluster, you only need to pay for computing resources
• B. Millisecond-level latency in physical replication
• C. Elastic scaling within minutes
• D. Large storage space
• E. locked backup

Answer: E

Explanation:
Explanation
Lock-free backup.
https://www.alibabacloud.com/help/doc-detail/58768.htm?spm=a2c63.p38356.b99.10.1bcb7338k86bX5

 

NEW QUESTION 50
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. False
• B. True

Answer: A

Explanation:
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

 

NEW QUESTION 51
Which database utility is good for database management and DevOps?

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

Answer: E

Explanation:
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

 

NEW QUESTION 52
......

Ultimate Guide to Prepare ACA-Database Certification Exam for Alibaba Database: https://www.practicematerial.com/ACA-Database-exam-materials.html