[Jun-2022] Updated Alibaba Database ACA-Database Exam Questions BUNDLE PACK [Q46-Q68]

June 2, 2022 ACA-Database, Alibaba Cloud 0 Comments

[Jun-2022] Updated Alibaba Database ACA-Database Exam Questions BUNDLE PACK [Q46-Q68]

4.8/5 - (13 votes)

[Jun-2022] Updated Alibaba Database ACA-Database Exam Questions BUNDLE PACK

Master The Alibaba Cloud Content ACA-Database EXAM DUMPS WITH GUARANTEED SUCCESS!

Alibaba Cloud ACA-Database Exam Syllabus Topics:

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

NO.46 Which of the following statements about AnalyticDB for MySQL is true?

AnalyticDB for MySQL is a NoSQL database.

AnalyticDB for MySQL can be used to build enterprise-grade data warehouse projects.

AnalyticDB for MySQL can be used to build online transaction systems.

AnalyticDB for MySQL supports transactions.

NO.47 Which of the following is not a relational database?

Oracle

DB2

Teradata

Redis

NO.48 Which of the following are reasonable Data Transmission Service (DTS) use cases? (Number of correct answers: 4)

Database migration without interrupting services / downtime

Geo-disaster recovery and active geo-redundancy for databases

Synchronizing data to data warehouses in real time to build data warehouses for real-time analytics.

Configuring data audit rules to manage data quality.

Synchronizing information about user accounts and permissions.

Change tracking and data distribution.

NO.49 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

NO.50 Which of the followings is NOT a correct way to connect to PolarDB?

Use the command line like ‘mysql’ to connect to a cluster

Use DMS to connect to a cluster

Use a client like HeidiSQL to connect to a cluster

Use PolarDB console to log into a cluster

Explanation
Use the PolarDB console to log on to Database.
https://www.alibabacloud.com/help/doc-detail/68511.htm?spm=a2c63.p38356.879954.7.7c2855b1aLLHjb#task-

NO.51 Which of the following features is provided by Data Management (DMS)?

Integrates data across multiple data sources

Backs up multiple types of databases

Evaluates the database migration project

Enables online database management, such as data query, database and table management, and permission management

NO.52 Which of these are NOT good use cases for DTS (Data Transmission Service)? (Number of correct answers: 2)

Incremental synchronization for disaster recovery

Full database synchronization for database migration

Undoing changes made to a database by mistake

Saving database logs

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

FC Switch

SAN

Proxy

RDMA

NO.54 Which of the following specifications of AnalyticDB supports tiered storage of cold and hot data?

Basic Edition

C series

S series

Elastic Mode

NO.55 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

NO.56 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

NO.57 Which of the following are features supported by Alibaba Cloud RDS for MySQL? (The number of

Read-Write Splitting ->
https://www.alibabacloud.com/help/doc-detail/96047.htm?spm=a2c63.p38356.b99.57.500dc3c6Kt0QLs

Local Snapshot Backup-> Snapshot Backup is Cloud disk instance. Cross-region backup is Local disk instance.

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

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

ACD

NO.58 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.

True

False

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

NO.59 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.

NO.60 Your client is having trouble connecting DTS to their source database in their local datacenter, why might this be?

Their database isn’t on Alibaba Cloud already so it cannot be accessed by DTS

Their database is not accessible from the Internet, so DTS cannot access it

Their database must not include the special DTS compatibility mode

Their database is an inverted column store, which is not supported

NO.61 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

NO.62 Which of the following is the core benefit of ApsaraDB for Redis Enhanced Edition (Tair)?

Makes it easy to do business anywhere.

Makes data secure and independently managed.

Makes large amounts of data easier to process.

Makes data accessible online and in real time.

NO.63 From which of the following data sources or databases can Data Lake Analytics (DLA) read data for analysis?
(Number of correct answers: 6)

MySQL

Oracle

OTS

MongoDB

AnolyticDB

HOLO

OSS

NO.64 Which of the following deployment architectures are supported by Alibaba Cloud ApsaraDB for MongoDB?
(Number of correct answers: 3)

Standalone instance

Primary/secondary instance that consists of two nodes

Replica set instance that consists of three nodes

Sharded cluster instance

Replica set instance that consists of six nodes

NO.65 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

NO.66 Which of the following architectures are supported by ApsaraDB for Redis Enhanced Edition (Tair)? (Number of correct answers: 3)

Master-replica architecture in which standard master-replica instances are deployed

Read/write splitting architecture in which standard master-replica instances are deployed

Cluster master-replica instances

Single-node architecture

NO.67 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

NO.68 What does DIM mean in data warehouse terms?

Dimension table

Operational data store (ODS)

Common data model (CDM)

Application data service (ADS)

Loading …