ACA-Database Free Exam Study Guide! (Updated 82 Questions) [Q18-Q37]

ACA-Database Free Exam Study Guide! (Updated 82 Questions)

ACA-Database Dumps for Alibaba Database Certified Exam Questions & Answer

Alibaba Cloud ACA-Database Exam Syllabus Topics:

Topic	Details
Topic 1	Database Overview Relational Database NoSQL Data Warehouse ADB database infrastructure, core functions and application scenarios
Topic 2	From cloud native to cloud dedicate: MyBase database dedicated cluster Development history and future trend of database
Topic 3	Alibaba Cloud database products portfolio Basic concepts of database (SQL, index, view, transaction, log, etc.)
Topic 4	Common operation of Alibaba Cloud database (database creation, basic operation and maintenance, monitoring, connection, etc.)
Topic 5	DLA infrastructure, core functions and application scenarios Cloud database edition and engine selection how-to
Topic 6	Infrastructure, core functions and application scenarios of PolarDB, which is Alibaba Cloud Native database representative Mainstream tools include: ADAM, DTS, DMS, DBS
Topic 7	Infrastructure, core functions and application scenarios of Alibaba cloud database: Tair (Redis enterprise version) and Apsara DB for MongoDB

 

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

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

Answer: A,D

 

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

Answer: B

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

 

NEW QUESTION 21
Which of the following is the lowest recovery point objective (RPO) for Database Backup Service?

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

Answer: D

 

NEW QUESTION 22
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 23
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 24
Which of the following is NOT supported by schema migration in Advanced Database & Application Migration (ADAM)?

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

Answer: C

 

NEW QUESTION 25
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 26
Which of the following databases are supported by DTS (Database Transmission Service)? (Number of correct answers: 3)

• A. PostreSQL
• B. SQL Server
• C. DB2
• D. MySQL

Answer: A,B,D

Explanation:
Explanation
DB2 is supported, but very limited.
https://www.alibabacloud.com/help/doc-detail/176064.htm?spm=a2c63.l28256.b99.7.13c27142yYyvXz

 

NEW QUESTION 27
Which of the following features is NOT supported by Data Transmission Service (DTS)?

• A. Data synchronization
• B. Data migration
• C. Data backup
• D. Change tracking

Answer: D

 

NEW QUESTION 28
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 29
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 30
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 31
With ApsaraDB for MyBase, problems caused by a sudden spike in traffic are automatically resolved. How is this done?

• A. ApsaraDB for MyBase supports elastic upgrade policies. If the resource utilization of a database exceeds the preset threshold during a business peak, ApsaraDB for MyBase can automatically upgrade database resource specifications to respond to the business peak.
• B. ApsaraDB for My Base allows you to deploy different types of instances in a cluster.
• C. ApsaraDB for MyBase supports the over commitment of CPU and disk resources.
• D. ApsaraDB for MyBase allows you to specify a host when you create an instance.
• E. ApsaraDB for MyBase grants you host permissions. You can log on to hosts to troubleshoot business problems in an emergency.

Answer: C

 

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

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

Answer: B

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

 

NEW QUESTION 33
Alibaba Cloud DTS (Data Transmission Service) supports both full database migration and incremental synchronization.

• A. True
• B. False

Answer: A

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

 

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

Answer: C,F,G

 

NEW QUESTION 35
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. De-identification algorithms can be managed. Multiple algorithms are supported, such as algorithms for masking specific positions and replacing fixed characters.
• C. The rules of field metadata and data content can be automatically recognized.
• D. After you configure de-identification algorithms, you can view the de-identified data.

Answer: D

 

NEW QUESTION 36
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 37
......

Use Real ACA-Database Dumps - 100% Free ACA-Database Exam Dumps: https://www.exam4pdf.com/ACA-Database-dumps-torrent.html