[Jan-2022] Dumps Practice Exam Questions Study Guide for the ACA-Database Exam [Q36-Q59]

[Jan-2022] Dumps Practice Exam Questions Study Guide for the ACA-Database Exam

ACA-Database Dumps with Practice Exam Questions Answers

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

 

NEW QUESTION 36
Which of the following is NOT supported by schema migration in Advanced Database & Application Migration (ADAM)?

• A. Migrate the schemas that require a manual revision but have not been revised
• B. Re-migrate the failed schemas
• C. Re-migrate all schemas
• D. Customize schema migration

Answer: A

 

NEW QUESTION 37
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 38
Which of the following tasks cannot be completed by using Advanced Database & Application Migration (ADAM)?

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

Answer: A

 

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

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

Answer: C

 

NEW QUESTION 40
Which of the following features is provided by Data Management (DMS)?

• A. Evaluates the database migration project
• B. Integrates data across multiple data sources
• C. Enables online database management, such as data query, database and table management, and permission management
• D. Backs up multiple types of databases

Answer: A

 

NEW QUESTION 41
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 42
PolarDB for MySQL archive databases use log-structured merge-trees (LSM trees) and the Zstandard (ZSTD) data compression algorithm to increase the data compression ratio. How much storage can be saved, at most?

• A. 40%
• B. 70%
• C. 50%
• D. 60%

Answer: B

 

NEW QUESTION 43
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. Single-node architecture
• D. Cluster master-replica instances

Answer: A,B,D

 

NEW QUESTION 44
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 45
Which of the following is the lowest recovery point objective (RPO) for Database Backup Service?

• A. Seconds
• B. Hours
• C. Days
• D. Minutes

Answer: D

 

NEW QUESTION 46
Which of the following is the wrong statement about PolarDB design architecture?

• A. A PolarDB cluster contains one primary instance and up to 15 read-only instances
• B. Read/write splitting is enabled for PolarDB clusters by default, providing transparent, highly available, and self-adaptive load balancing for your database
• C. 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
• 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: C

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

 

NEW QUESTION 47
Which of these are NOT good use cases for DTS (Data Transmission Service)? (Number of correct answers: 2)

• A. Saving database logs
• B. Full database synchronization for database migration
• C. Incremental synchronization for disaster recovery
• D. Undoing changes made to a database by mistake

Answer: A,D

 

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

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

Answer: D

 

NEW QUESTION 49
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 50
Which of the following statements about Alibaba Cloud ApsaraDB for MongoDB is true?

• A. Alibaba Cloud and MongoDB have a strategic partnership, so Alibaba Cloud Is able to provide the latest MongoDB features in our ApsaraDB for MongoDB product, in all our global regions.
• B. DataWorks is not supported for MongoDB data processing.
• C. It takes a longer time to perform operations and maintenance (O&M) on ApsaraDB for MongoDB instances than on self-installed and self-managed MongoDB.

Answer: A

 

NEW QUESTION 51
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 52
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. Cube
• C. GIS
• D. JSON
• E. JSONB
• F. Range
• G. Array

Answer: A,D,G

 

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

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

Answer: B,C,D

 

NEW QUESTION 54
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 55
Which of the following are NOT true, regarding DTS (Data Transmission Service)? (Number of correct answers: 2)

• A. The source and destination database must use the same database engine
• B. The source and destination database must both have a database user which DTS can use
• C. DTS is designed for file synchronization
• D. If the source database is not on Alibaba Cloud, it must be Internet accessible so that DTS can connect to it

Answer: A,C

 

NEW QUESTION 56
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 Oracle
• B. PolarDB Box
• 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 57
When a backup file of core sensitive data is downloaded, business systems must be protected against data breaches. Which of the following capabilities must be enabled to ensure data security?

• A. Virtual private cloud (VPC)
• B. Secure Sockets Layer (SSL) encryption
• C. SOL audit
• D. Transparent Data Encryption (TDE)

Answer: B

 

NEW QUESTION 58
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 59
......

Free Alibaba Database ACA-Database Exam Question: https://www.testvalid.com/ACA-Database-exam-collection.html