Latest [Aug 08, 2021] ACA-Database Exam with Accurate ACA Database Certification PDF Questions

Take a Leap Forward in Your Career by Earning Alibaba Cloud 82 Questions

NEW QUESTION 48
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 49
Which of the following statements about the compatibility of AnalyticDB for PostgreSQL is NOT true?

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

Answer: A

 

NEW QUESTION 50
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 service
• B. Data visualization
• C. Data lineage
• D. Data directory
• E. Data quality

Answer: A,C,E

 

NEW QUESTION 51
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. 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.
• C. DataWorks is not supported for MongoDB data processing.

Answer: A

 

NEW QUESTION 52
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 53
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 54
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 55
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 56
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 57
How can ApsaraDB for MyBase solve problems in database security and performance interferences in the multi-tenant scenario?

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

Answer: A

 

NEW QUESTION 58
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 59
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 60
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 61
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 62
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 63
Which of the following is the lowest recovery point objective (RPO) for Database Backup Service?

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

Answer: C

 

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

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

Answer: B

 

NEW QUESTION 65
Which of the following is the most efficient backup in ApsaraDB for MongoDB?

• A. Logical backup
• B. Physical backup
• C. Full backup
• D. Snapshot backup

Answer: B

 

NEW QUESTION 66
Which of the following data is not collected when database information is collected in Advanced Database & Application Migration (ADAM)?

• A. Historical performance data
• B. Business data
• C. Database configuration data
• D. Business structure data

Answer: B

 

NEW QUESTION 67
Your client is having trouble connecting DTS to their source database in their local datacenter, why might this be?

• A. Their database isn't on Alibaba Cloud already so it cannot be accessed by DTS
• B. Their database is an inverted column store, which is not supported
• C. Their database is not accessible from the Internet, so DTS cannot access it
• D. Their database must not include the special DTS compatibility mode

Answer: C

 

NEW QUESTION 68
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. Transparent Data Encryption (TDE)
• B. Secure Sockets Layer (SSL) encryption
• C. SOL audit
• D. Virtual private cloud (VPC)

Answer: B

 

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

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

Answer: B

 

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

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

Answer: B,D

 

NEW QUESTION 71
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 72
......

Authentic Best resources for ACA-Database Online Practice Exam: https://www.validexam.com/ACA-Database-latest-dumps.html