[Oct 12, 2021] ACA-Database Ultimate Study Guide - BraindumpQuiz
Ultimate Guide to Prepare ACA-Database Certification Exam for Alibaba Database in 2021
NEW QUESTION 47
lf Oracle databases need to be migrated to Alibaba Cloud, which of the following product solutions :an be recommended? (Number of correct answers: 3)
- A. Use Advanced Database & Application Migration (ADAM) to evaluate the migration project.
- B. Use Data Transmission Service (DTS) to migrate data.
- C. Use PolarDB-0 that is highly compatible with Oracle.
- D. Use ApsaraDB for Redis as a cache service to provide acceleration capabilities.
Answer: A,B,C
NEW QUESTION 48
Which of the following is not a feature or usage scenario of Data Lake Analytics (DLA)?
- A. Stream or micro-batch processing
- B. Interactive analysis
- C. Online transaction processing
- D. Batch processing
Answer: C
NEW QUESTION 49
Which of the following is not a relational database?
- A. Oracle
- B. DB2
- C. Teradata
- D. Redis
Answer: D
NEW QUESTION 50
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 51
Alibaba Cloud DTS (Database Transmission Service) only supports MySQL databases.
- A. False
- B. True
Answer: A
Explanation:
Explanation
https://www.alibabacloud.com/help/doc-detail/26618.htm?spm=a2c63.p38356.b99.53.1c2b1156hNo8v0
NEW QUESTION 52
Which of the following is the high-availability service level that is specified in the ApsaraDB RDS Service Level Agreement (SLA)?
- A. 99%
- B. 90%
- C. 99.99%
- D. 99.5%
Answer: C
NEW QUESTION 53
Which of the following is NOT supported by schema migration in Advanced Database & Application Migration (ADAM)?
- A. Re-migrate the failed schemas
- B. Customize schema migration
- C. Migrate the schemas that require a manual revision but have not been revised
- D. Re-migrate all schemas
Answer: C
NEW QUESTION 54
You want to migrate from MySQL to PostgreSQL: is this supported by DTS?
- A. No, this type of migration isn't supported
- B. Yes, migration between different types of databases is supported by DTS
- C. You can migrate between MySQL and Oracle but not between PostgreSQL
Answer: B
Explanation:
Explanation
https://www.alibabacloud.com/help/doc-detail/176064.htm?spm=a2c63.p38356.b99.7.3191591dPlcLJa
NEW QUESTION 55
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. Ganos
- B. High concurrency optimization
- C. Pase
- D. Point-in-time restore
- E. Slot failover
Answer: D
NEW QUESTION 56
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 57
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 58
Which database utility is used for data migration and synchronization?
- A. DMS
- B. DBS
- C. DTS
- D. DAS
- E. ADAM
Answer: C
Explanation:
Explanation
Data Transmission Service is charged based according to three models: Data Synchronization, Data Migration, Change Tracking. https://www.alibabacloud.com/product/data-transmission-service/pricing
NEW QUESTION 59
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 60
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 61
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 62
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 63
Which of the following architectures is not supported by ApsaraDB RDS for MySQL?
- A. The serverless architecture, in which computing resources are charged based on the Pay-As-You-Go (PAYG) billing method
- B. The high-avail ability architecture, in which primary and read-only nodes are deployed to implement automatic failovers
- C. The single-node Basic Edition architecture, which can be used in test and non-core production environments
- D. The three-node Enterprise Edition architecture, which ensures zero data loss
Answer: A
NEW QUESTION 64
If a database exception occurs in a PolarDB cluster because important data is deleted by mistake, how i can data be restored?
- A. Level-2 backup
- B. Level 1 backup + Redo log
- C. Level-1 backup
- D. Level-2 backup + Redo log
Answer: D
NEW QUESTION 65
If you have a development team with several developers working on cloud databases, which product is recommended to use for development collaboration?
- A. DTS
- B. DBS
- C. DG
- D. DMS
- E. DAS
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 66
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 67
What is the maximum storage size that PolarDB currently provides?
- A. 100TB
- B. 50TB
- C. 1TB
- D. 10TB
Answer: A
Explanation:
Explanation
Each PolarDB cluster supports to scale up to 100 TB. https://www.alibabacloud.com/product/polardb
NEW QUESTION 68
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 use the same database engine
- 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 both have a database user which DTS can use
Answer: A,B
NEW QUESTION 69
Which of the following are reasonable Data Transmission Service (DTS) use cases? (Number of correct answers: 4)
- A. Database migration without interrupting services / downtime
- B. Synchronizing data to data warehouses in real time to build data warehouses for real-time analytics.
- C. Geo-disaster recovery and active geo-redundancy for databases
- D. Change tracking and data distribution.
- E. Configuring data audit rules to manage data quality.
- F. Synchronizing information about user accounts and permissions.
Answer: A,C,D
NEW QUESTION 70
......
Alibaba Database Fundamentals-ACA-Database Exam-Practice-Dumps: https://www.braindumpquiz.com/ACA-Database-exam-material.html