[Nov 29, 2021] Get to the Top with ACA-Database Practice Exam Questions

Use Real ACA-Database Dumps Free Sample Questions and Practice Test Engine

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

• A. Simplicity in structure: presents the database as a set of virtual tables specific to particular users or groups of users
• B. Simplicity for queries
• C. Stabilization of information: presents a consistent, unchanged image of the database structure
• D. Easier for data visualization

Answer: A,B,C

 

NEW QUESTION 20
Which of the following statements is NOT correct about PolarDB?

• A. ApsaraDB for PolarDB can scale clusters within a few minutes, recover from failures within a few seconds, and guarantee data consistency
• B. ApsaraDB for PolarDB is designed to handle large amounts of sequential queries
• C. ApsaraDB for PolarDB is a cloud-native relational database service that is compatible with the MySQL, PostgreSQL, and Oracle engines
• 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. Each ApsaraDB for PolarDB cluster supports up to 100 TB of storage space and can handle up to one million queries per second (QPS)

Answer: B

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

 

NEW QUESTION 21
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 22
Which of the following tools can be used to migrate an on-premises database to Alibaba Cloud while causing minimal service downtime?

• A. pg_upgrade D.DTS
• B. pg_restore
• C. pg_basebackup
• D. pg_dump

Answer: C

 

NEW QUESTION 23
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 24
Which of the following features are provided by PolarDB-O's proxy? (Number of correct answers: 4)

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

Answer: A,B,C,D

 

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

Answer: A,B,D,E

 

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

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

Answer: B

 

NEW QUESTION 27
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 28
How can ApsaraDB for MyBase solve problems in database security and performance interferences in the multi-tenant scenario?

• A. ApsaraDB for MyBase supports resource over commitment.
• B. Isolated hosts are used. A host runs only your instances and does not run instances of other users.
• C. ApsaraDB for MyBase allows you to distribute different types of instances at a time.
• D. Instances can be migrated. You can manually migrate instances to idle hosts.

Answer: B

 

NEW QUESTION 29
Your DTS (Data Transmission Service) migration has failed halfway through: what options do you have? (Number of correct answers: 2)

• A. Your database can't be migrated: you need to abandon the migration
• B. You need to switch to ADAM, as DTS cannot complete the migration
• C. Restart the migration task from the console
• D. Delete your DTS instance and start over

Answer: B,C

 

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

• A. C series
• B. S series
• C. Basic Edition
• D. Elastic Mode

Answer: D

 

NEW QUESTION 31
What does DIM mean in data warehouse terms?

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

Answer: B

 

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

• A. True
• B. False

Answer: B

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 33
Data Management (DMS) provides features related to data warehouse development to support task orchestration and recurring scheduling. Which of the following features are being developed? (Number of correct answers: 3)

• A. Data lineage
• B. Data visualization
• C. Data directory
• D. Data service
• E. Data quality

Answer: A,D,E

 

NEW QUESTION 34
Which of the following statements about the compatibility of AnalyticDB for PostgreSQL is NOT true?

• A. Compliance with PostgreSQL and Greenplum protocols
• B. Fully compatible with Oracle syntax
• C. Support for the SQL2003 syntax standard
• D. Support for the Java Database Connectivity (JDBC) protocol

Answer: B

 

NEW QUESTION 35
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 36
Which of the following are database architectures which have emerged during the evolution of database systems? (Number of correct answers: 3)

• A. Shared Everything
• B. Dedicated
• C. Shared Nothing
• D. Single Instance

Answer: A,B,C

 

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

• A. Online transaction processing
• B. Batch processing
• C. Interactive analysis
• D. Stream or micro-batch processing

Answer: A

 

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

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

 

NEW QUESTION 39
If you have a development team with several developers working on cloud databases, which product is recommended to use for development collaboration?

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

Answer: D

Explanation:
Explanation
A series of step-based solutions for R&D processes, data security, and data development are provided in the Data Management (DMS) console to get you started with DMS.
https://www.alibabacloud.com/help/doc-detail/190124.htm?spm=a2c63.p38356.b99.40.6ad93d19Xe9h14

 

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

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

Answer: D

 

NEW QUESTION 41
Which of the following are the advantages of cloud databases over self-managed databases? (Number of correct answers: 3)

• A. Integrated operations and maintenance (O&M), as well as easier management
• B. High costs
• C. High availability and comprehensive backup and monitoring capabilities
• D. Stronger service level agreement (SLA)

Answer: A,C,D

 

NEW QUESTION 42
......

Pass Alibaba Cloud ACA-Database exam - questions - convert Tets Engine to PDF: https://www.braindumpsit.com/ACA-Database_real-exam.html