ACA-Database Practice Exam Tests Latest Updated on Sep-2021 [Q13-Q34]

Share

ACA-Database Practice Exam Tests Latest Updated on Sep-2021

Pass ACA-Database Exam in First Attempt Guaranteed Dumps!

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

  • A. From a different cloud provider to Alibaba Cloud
  • B. From RDS to an ECS-based database
  • C. From an RDS database, back to itself
  • D. From Alibaba Cloud RDS to other database systems

Answer: A,B,D

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

 

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

  • A. DTS can migrate data from several source databases to one destination database, for example, A > C and B > C.
  • B. DTS can migrate data in a circular way, for example, A > B > C > A.
  • C. DTS can migrate data from one source database to one destination database, for example, A > B.
  • D. DTS can migrate data from one source database to several destination databases, for example, A > B and A > C.

Answer: B

 

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

  • A. AnalyticDB for MySQL is a NoSQL database.
  • B. AnalyticDB for MySQL can be used to build enterprise-grade data warehouse projects.
  • C. AnalyticDB for MySQL can be used to build online transaction systems.
  • D. AnalyticDB for MySQL supports transactions.

Answer: B

 

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

  • A. Logical migration tools
  • B. Incremental backup only
  • C. Full backup and incremental backup
  • D. Full backup only

Answer: A

 

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

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

Answer: D

 

NEW QUESTION 18
Which of the following is NOT true, regarding the sensitive data management feature provided by Data Management (DMS)?

  • A. After you configure de-identification algorithms, you can view the de-identified data.
  • B. The rules of field metadata and data content can be automatically recognized.
  • C. Field-level and row-level permissions are supported.
  • D. De-identification algorithms can be managed. Multiple algorithms are supported, such as algorithms for masking specific positions and replacing fixed characters.

Answer: A

 

NEW QUESTION 19
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

Answer: A

Explanation:
Explanation
https://www.alibabacloud.com/help/doc-detail/26652.htm?spm=a2c63.p38356.879954.26.2ab232664Wkc2m#co

 

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

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

Answer: B

 

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

  • A. FC Switch
  • B. SAN
  • C. RDMA
  • D. Proxy

Answer: B

 

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

Answer: C

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

 

NEW QUESTION 23
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 24
Which of the following is the wrong statement about PolarDB design architecture?

  • A. PolarDB consolidate compute processes and storage processes in one box, allowing the database capacity to scale up and down to meet your application needs in Alibaba Cloud
  • B. Read/write splitting is enabled for PolarDB clusters by default, providing transparent, highly available, and self-adaptive load balancing for your database
  • C. A PolarDB cluster contains one primary instance and up to 15 read-only instances
  • D. High speed network connection is enabled between the DB server and the chunk server, and data are transferred using the Remote Direct Memory Access (RDMA) protocol

Answer: A

Explanation:
Explanation
PolarDB decouples compute from storage.
https://www.alibabacloud.com/help/doc-detail/58766.htm?spm=a2c63.p38356.b99.11.4e333181dMpFmV

 

NEW QUESTION 25
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. Data flashback
  • C. Multithreading
  • D. Global Replica

Answer: D

 

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

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

Answer: C

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 27
Which of the following are features supported by Alibaba Cloud RDS for MySQL? (The number of

  • 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. 3)
  • 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
  • E. 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
  • F. ACD

Answer: C,F

 

NEW QUESTION 28
Which of the following statements about Data Management (DMS) permissions management is NOT true?

  • A. You cannot directly submit changes even if you have permissions to make changes.
  • B. You must create different database accounts for each Alibaba Cloud account.
  • C. The permissions of the accounts of resigned or transferred personnel can be automatically managed by using OpenAPI.
  • D. You can assign different resources and operation permissions to an Alibaba Cloud account as needed.

Answer: A

 

NEW QUESTION 29
Which of the following is not a relational database?

  • A. Oracle
  • B. DB2
  • C. Teradata
  • D. Redis

Answer: D

 

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

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

Answer: B,D,E

 

NEW 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?

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

Answer: A

 

NEW QUESTION 32
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 33
Which of the following are the core technologies behind Database Backup Service? (Number of correct answers: 3)

  • A. Online query and analysis
  • B. Real-time synchronization
  • C. High mount speeds (a few seconds)
  • D. Multi-cloud and multi-backend backup

Answer: B,C,D

 

NEW QUESTION 34
......

Alibaba Database  Free Certification Exam Material from Actual4Exams with 82 Questions: https://www.actual4exams.com/ACA-Database-valid-dump.html