Latest [Jan 25, 2022] Alibaba Cloud ACA-Database Exam Practice Test To Gain Brilliante Result
Take a Leap Forward in Your Career by Earning Alibaba Cloud ACA-Database
NEW QUESTION 37
Which of the following are database architectures which have emerged during the evolution of database systems? (Number of correct answers: 3)
- A. Single Instance
- B. Dedicated
- C. Shared Everything
- D. Shared Nothing
Answer: B,C,D
NEW QUESTION 38
Which are the supported DB engine for PolarDB so far? (The number of answer: 3)
- A. PolarDB for Postgres
- B. PolarDB for Oracle
- C. PolarDB for Mysql
- D. PolarDB for SQLserver
Answer: A,B,C
Explanation:
Explanation
PolarDB is a cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle.
https://www.alibabacloud.com/product/polardb
NEW QUESTION 39
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 40
Which of the following are reasonable Data Transmission Service (DTS) use cases? (Number of correct answers: 4)
- A. Geo-disaster recovery and active geo-redundancy for databases
- B. Configuring data audit rules to manage data quality.
- C. Synchronizing data to data warehouses in real time to build data warehouses for real-time analytics.
- D. Change tracking and data distribution.
- E. Synchronizing information about user accounts and permissions.
- F. Database migration without interrupting services / downtime
Answer: A,D,F
NEW QUESTION 41
Which of the following is NOT true, regarding DTS (Database Transmission Service)?
- A. DTS supports multiple database engines
- B. DTS cannot be used for incremental database synchronization
- C. DTS can migrate both data and table schema
- D. DTS works for database both on and off Alibaba Cloud
Answer: B
Explanation:
Explanation
https://www.alibabacloud.com/help/doc-detail/56776.htm?spm=a2c63.p38356.b99.181.74896b5dro6cDo
NEW QUESTION 42
How can ApsaraDB for MyBase solve problems in database security and performance interferences in the multi-tenant scenario?
- A. Instances can be migrated. You can manually migrate instances to idle hosts.
- B. ApsaraDB for MyBase allows you to distribute different types of instances at a time.
- C. Isolated hosts are used. A host runs only your instances and does not run instances of other users.
- D. ApsaraDB for MyBase supports resource over commitment.
Answer: C
NEW QUESTION 43
Which of the following is the high-availability service level that is specified in the ApsaraDB RDS Service Level Agreement (SLA)?
- A. 99%
- B. 99.99%
- C. 99.5%
- D. 90%
Answer: B
NEW QUESTION 44
Which of the following types of data are most suitable for storage in MySQL databases?
- A. Document-oriented unstructured data
- B. Large amounts of time series data
- C. Structured data in rows and columns
- D. Key-value (KV) data that is frequently read and written
Answer: C
NEW QUESTION 45
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
Explanation:
Explanation
Compared with single-zone clusters, multi-zone clusters can enhance disaster recovery capabilities and withstand the breakdown of an entire data center.
https://www.alibabacloud.com/help/doc-detail/122182.htm?spm=a2c63.p38356.879954.4.6f2fa25362cz60#task-
NEW QUESTION 46
Which of the following computing capabilities are supported by AnalyticDB? (Number of correct answers: 4)
- A. Interactive analysis
- B. Simple point query
- C. Real-time update
- D. Machine Learning
- E. Complex extract, transform, load (ETL)
Answer: A,C,D,E
NEW QUESTION 47
Which of the following are the benefits of database views? (Number of correct answers: 3)
- A. Stabilization of information: presents a consistent, unchanged image of the database structure
- B. Simplicity in structure: presents the database as a set of virtual tables specific to particular users or groups of users
- C. Easier for data visualization
- D. Simplicity for queries
Answer: A,B,D
NEW QUESTION 48
Which of the following are relational databases? (Number of correct answers: 5)
- A. SQL Server
- B. Redis
- C. Oracle
- D. HBase
- E. MySQL
- F. MongoDB
- G. MariaDB
- H. PostgreSQL
- I. TSDB
Answer: A,C,E,G,H
NEW QUESTION 49
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 50
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?
- A. High concurrency optimization
- B. Ganos
- C. Pase
- D. Point-in-time restore
- E. Slot failover
Answer: D
NEW QUESTION 51
Which of the following statements about the compatibility of AnalyticDB for PostgreSQL is NOT true?
- A. Support for the Java Database Connectivity (JDBC) protocol
- B. Fully compatible with Oracle syntax
- C. Support for the SQL2003 syntax standard
- D. Compliance with PostgreSQL and Greenplum protocols
Answer: B
NEW QUESTION 52
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 53
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 54
Why is ApsaraDB for PolarDB better than other traditional database engines? (The number of answer: 3)
- A. The PolarDB database engine won't require you to replicate data when adding read-only nodes
- B. PolarDB supports both OLTP and OLAP scenarios very well
- C. ApsaraDB for PolarDB uses the pay-as-you-go billing method, therefore you only need to pay for the storage resources you actually use
- D. When you purchase a PolarDB cluster, you don't need to specify the storage capacity you want to purchase
Answer: A,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 55
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. ApsaraDB MongoDB
- C. Express Connect DB
- D. RDS Instance
Answer: D
Explanation:
Explanation
https://www.alibabacloud.com/help/doc-detail/96154.htm?spm=a2c63.p38356.b99.118.59de5d1aWUVErx
NEW QUESTION 56
Which of the following scheduling tools are supported by AnalyticDB for MySQL? (Number of correct answers: 2)
- A. QuickBl
- B. DMS
- C. Data Works
- D. MaxCompute
Answer: B,C
NEW QUESTION 57
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 58
......
Alibaba Cloud ACA-Database Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
Authentic Best resources for ACA-Database Online Practice Exam: https://www.examboosts.com/Alibaba-Cloud/ACA-Database-practice-exam-dumps.html