Real Exam Questions ACA-Database Dumps Exam Questions in here [Oct-2021]
Get Latest Oct-2021 Conduct effective penetration tests using ACA-Database
NEW QUESTION 38
Which of the following is NOT true, regarding DTS (Database Transmission Service)?
- A. DTS works for database both on and off Alibaba Cloud
- B. DTS can migrate both data and table schema
- C. DTS supports multiple database engines
- D. DTS cannot be used for incremental database synchronization
Answer: D
Explanation:
Explanation
https://www.alibabacloud.com/help/doc-detail/56776.htm?spm=a2c63.p38356.b99.181.74896b5dro6cDo
NEW QUESTION 39
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 Box
- B. PolarDB PosgreSQL
- C. PolarDB MySQL
- D. PolarDB Oracle
Answer: C
Explanation:
Explanation
https://www.alibabacloud.com/help/doc-detail/58768.htm?spm=a2c63.l28256.b99.10.71ce3784cXj0y8
NEW QUESTION 40
Which of the following computing capabilities are supported by AnalyticDB? (Number of correct answers: 4)
- A. Simple point query
- B. Interactive analysis
- C. Complex extract, transform, load (ETL)
- D. Real-time update
- E. Machine Learning
Answer: B,C,D,E
NEW QUESTION 41
Which type of the following logs is used to synchronize data between primary and secondary databases in RDS for MySQL?
- A. Binary log
- B. Redo log
- C. Rollback log
- D. Error log
Answer: A
NEW QUESTION 42
Why is ApsaraDB for PolarDB better than other traditional database engines? (The number of answer: 3)
- A. When you purchase a PolarDB cluster, you don't need to specify the storage capacity you want to purchase
- B. ApsaraDB for PolarDB uses the pay-as-you-go billing method, therefore you only need to pay for the storage resources you actually use
- C. The PolarDB database engine won't require you to replicate data when adding read-only nodes
- D. PolarDB supports both OLTP and OLAP scenarios very well
Answer: A,B,C
Explanation:
Explanation
Kernel Features: OLTP performance.
https://www.alibabacloud.com/help/doc-detail/172293.htm?spm=a2c63.p38356.b99.81.101b333ePsD0YF
NEW QUESTION 43
Which of the following statements about MongoDB is NOT true?
- A. MongoDB supports transactions.
- B. MongoDB is a relational database.
- C. MongoDB is a document database.
- D. MongoDB can be deployed in cluster mode.
Answer: B
NEW QUESTION 44
From which of the following data sources or databases can Data Lake Analytics (DLA) read data for analysis?
(Number of correct answers: 6)
- A. OTS
- B. MongoDB
- C. AnolyticDB
- D. Oracle
- E. HOLO
- F. OSS
- G. MySQL
Answer: A,B,C,D,F,G
NEW QUESTION 45
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 46
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. RDS Instance
- B. ECS-based Databases
- C. ApsaraDB MongoDB
- D. Express Connect DB
Answer: A
Explanation:
Explanation
https://www.alibabacloud.com/help/doc-detail/96154.htm?spm=a2c63.p38356.b99.118.59de5d1aWUVErx
NEW QUESTION 47
Which of the following deployment architectures are supported by Alibaba Cloud ApsaraDB for MongoDB?
(Number of correct answers: 3)
- A. Replica set instance that consists of six nodes
- B. Replica set instance that consists of three nodes
- C. Primary/secondary instance that consists of two nodes
- D. Standalone instance
- E. Sharded cluster instance
Answer: B,D,E
NEW QUESTION 48
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 49
You have a client that wants to move from another cloud provider's database service to RDS. Which of these is the best way to move their database to Alibaba Cloud?
- A. This type of migration isn't possible
- B. Use DTS (Data Transmission Service)
- C. Make a full physical backup of their database and copy it into OSS
- D. Migrate the entire VM hosting the database
Answer: B
NEW QUESTION 50
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. Cube
- B. String
- C. Range
- D. Array
- E. JSONB
- F. JSON
- G. GIS
Answer: B,D,F
NEW QUESTION 51
Which of the following tools can be used to migrate an on-premises database to Alibaba Cloud while causing minimal service downtime?
- A. pg_dump
- B. pg_restore
- C. pg_basebackup
- D. pg_upgrade D.DTS
Answer: C
NEW QUESTION 52
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 53
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 54
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 55
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 56
Which of the following is not a component of the PolarDB-0 architecture in Apsara Stack?
- A. FC Switch
- B. SAN
- C. RDMA
- D. Proxy
Answer: B
NEW QUESTION 57
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. 70%
- B. 60%
- C. 50%
- D. 40%
Answer: A
NEW QUESTION 58
Which of the following statements about Data Management (DMS) permissions management is NOT true?
- A. You cannot directly submit changes even if you have permissions to make changes.
- B. You must create different database accounts for each Alibaba Cloud account.
- C. The permissions of the accounts of resigned or transferred personnel can be automatically managed by using OpenAPI.
- D. You can assign different resources and operation permissions to an Alibaba Cloud account as needed.
Answer: A
NEW QUESTION 59
Which of the following statements about AnalyticDB for MySQL is true?
- A. AnalyticDB for MySQL is a NoSQL database.
- B. AnalyticDB for MySQL can be used to build enterprise-grade data warehouse projects.
- C. AnalyticDB for MySQL can be used to build online transaction systems.
- D. AnalyticDB for MySQL supports transactions.
Answer: B
NEW QUESTION 60
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 61
Which of the following types of data are most suitable for storage in MySQL databases?
- A. Structured data in rows and columns
- B. Large amounts of time series data
- C. Document-oriented unstructured data
- D. Key-value (KV) data that is frequently read and written
Answer: A
NEW QUESTION 62
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 63
......
Authentic Best resources for ACA-Database Online Practice Exam: https://www.actualtestsit.com/Alibaba-Cloud/ACA-Database-exam-prep-dumps.html