[Jun-2022] Alibaba Cloud ACA-Database DUMPS WITH REAL EXAM QUESTIONS [Q48-Q72]

Rate this post

[Jun-2022] Alibaba Cloud ACA-Database DUMPS WITH REAL EXAM QUESTIONS

2022 New Real4exams ACA-Database PDF Recently Updated Questions

Alibaba Cloud ACA-Database Exam Syllabus Topics:

Topic	Details
Topic 1	Alibaba Cloud database products portfolio Basic concepts of database (SQL, index, view, transaction, log, etc.)
Topic 2	Infrastructure, core functions and application scenarios of Alibaba cloud database: Tair (Redis enterprise version) and Apsara DB for MongoDB
Topic 3	Database Overview Relational Database NoSQL Data Warehouse ADB database infrastructure, core functions and application scenarios
Topic 4	Infrastructure, core functions and application scenarios of PolarDB, which is Alibaba Cloud Native database representative Mainstream tools include: ADAM, DTS, DMS, DBS
Topic 5	Core capabilities and basic operations of Alibaba Cloud database tools and utilities Fast construction of cloud native data
Topic 6	From cloud native to cloud dedicate: MyBase database dedicated cluster Development history and future trend of database

Q48. Which of the following architectures is not supported by ApsaraDB RDS for MySQL?

The single-node Basic Edition architecture, which can be used in test and non-core production environments

The high-avail ability architecture, in which primary and read-only nodes are deployed to implement automatic failovers

The three-node Enterprise Edition architecture, which ensures zero data loss

The serverless architecture, in which computing resources are charged based on the Pay-As-You-Go (PAYG) billing method

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

The rules of field metadata and data content can be automatically recognized.

De-identification algorithms can be managed. Multiple algorithms are supported, such as algorithms for masking specific positions and replacing fixed characters.

Field-level and row-level permissions are supported.

After you configure de-identification algorithms, you can view the de-identified data.

Q50. Alibaba Cloud DTS (Data Transmission Service) can only migrate between databases that are hosted on RDS.

True

False

Explanation
Alibaba Cloud Data Transmission Service (DTS) helps you migrate data between data stores, such as relational databases, NoSQL databases, and data warehouses. You can use DTS to migrate your data to Alibaba Cloud or between combinations of cloud and on-premises data systems. .
https://www.alibabacloud.com/help/doc-detail/176063.htm?spm=a2c63.p38356.b99.6.2ef8c790WL4Jku

Q51. 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?

Ganos

Pase

Slot failover

High concurrency optimization

Point-in-time restore

Q52. Which of the following statements about Data Management (DMS) permissions management is NOT true?

You can assign different resources and operation permissions to an Alibaba Cloud account as needed.

You must create different database accounts for each Alibaba Cloud account.

You cannot directly submit changes even if you have permissions to make changes.

The permissions of the accounts of resigned or transferred personnel can be automatically managed by using OpenAPI.

Q53. Which type of the following logs is used to synchronize data between primary and secondary databases in RDS for MySQL?

Redo log

Rollback log

Binary log

Error log

Q54. Which of the following types of data are most suitable for storage in MySQL databases?

Structured data in rows and columns

Document-oriented unstructured data

Large amounts of time series data

Key-value (KV) data that is frequently read and written

Q55. Which of the following databases are supported by DTS (Database Transmission Service)? (Number of correct answers: 3)

MySQL

SQL Server

PostreSQL

DB2

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

Q56. lf Oracle databases need to be migrated to Alibaba Cloud, which of the following product solutions :an be recommended? (Number of correct answers: 3)

Use PolarDB-0 that is highly compatible with Oracle.

Use Advanced Database & Application Migration (ADAM) to evaluate the migration project.

Use ApsaraDB for Redis as a cache service to provide acceleration capabilities.

Use Data Transmission Service (DTS) to migrate data.

Q57. If you have a development team with several developers working on cloud databases, which product is recommended to use for development collaboration?

DMS

DBS

DTS

DAS

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

Q58. 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?

ECS-based Databases

Express Connect DB

RDS Instance

ApsaraDB MongoDB

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

Q59. Which of the following is not a feature or usage scenario of Data Lake Analytics (DLA)?

Interactive analysis

Batch processing

Online transaction processing

Stream or micro-batch processing

Q60. Which of the following are relational databases? (Number of correct answers: 5)

Oracle

MySQL

PostgreSQL

MongoDB

MariaDB

Redis

TSDB

HBase

SQL Server

Q61. Which of the following computing capabilities are supported by AnalyticDB? (Number of correct answers: 4)

Complex extract, transform, load (ETL)

Interactive analysis

Simple point query

Real-time update

Machine Learning

Q62. If a database exception occurs in a PolarDB cluster because important data is deleted by mistake, how i can data be restored?

Level-2 backup + Redo log

Level 1 backup + Redo log

Level-2 backup

Level-1 backup

Q63. 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.

True

False

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-

Q64. Which of the following is not a relational database?

Oracle

DB2

Teradata

Redis

Q65. Which of the following tasks cannot be completed by using Advanced Database & Application Migration (ADAM)?

De-Oracle workload evaluation

Data structure conversion

Data migration

Performance monitoring

Q66. 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)

JSON

Array

String

Cube

Range

JSONB

GIS

Q67. Which of the following is not a component of the PolarDB-0 architecture in Apsara Stack?

FC Switch

SAN

Proxy

RDMA

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

True

False

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

Q69. With ApsaraDB for MyBase, problems caused by a sudden spike in traffic are automatically resolved. How is this done?

ApsaraDB for My Base allows you to deploy different types of instances in a cluster.

ApsaraDB for MyBase grants you host permissions. You can log on to hosts to troubleshoot business problems in an emergency.

ApsaraDB for MyBase supports the over commitment of CPU and disk resources.

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.

ApsaraDB for MyBase allows you to specify a host when you create an instance.

Q70. 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?

PolarDB MySQL

PolarDB PosgreSQL

PolarDB Oracle

PolarDB Box

Explanation
https://www.alibabacloud.com/help/doc-detail/58768.htm?spm=a2c63.l28256.b99.10.71ce3784cXj0y8

Q71. Which of the following statements about Alibaba Cloud ApsaraDB for MongoDB is true?

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.

DataWorks is not supported for MongoDB data processing.

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.

Q72. Which of the following features determines high performance of the performance-enhanced instances of ApsaraDB for Redis Enhanced Edition (Tair)?

Extended data structure modules

Multithreading

Global Replica

Data flashback

Loading …