Alibaba Cloud ACA-BigData1 - ACA Big Data Certification Exam

Page: 3 / 3
Total 78 questions

Question # 21

If a MySQL database contains 100 tables, and jack wants to migrate all those tables to MaxCompute

using DataWorks Data Integration, the conventional method would require him to configure 100 data

synchronization tasks. With _______ feature in DataWorks, he can upload all tables at the same time.

Score 2

Full-Database Migration feature

Configure a MySQL Reader plug-in

Configure a MySQL Writer plug-in

Add data sources in Bulk Mode

Alibaba Cloud E-MapReduce can be easily plugged with other

Alibaba Cloud services such as Log Service, ONS, MNS that act

as data ingestion channels from real-time data streams. Which

of the following descriptions about real-time processing are

correct? (Number of correct answers: 3)

This data is streamed and processed using Apache

Flume or Kafka in integration with Apache Storm using

complex algorithmsB. Kafka is usually preferred with Apache Storm to

provide data pipeline

The final processed data can be stored in HDFS, HBase

or any other big data store service in real time.

Apache Sqoop is used to do the real-time data

transmission of structured data

MaxCompute tasks contain computational tasks and non-computational tasks. The

computational tasks require actual operations on data stored in the table. MaxCompute

parses the task to obtain its execution plan, and submits the task for execution. The noncomputational

tasks require substantial reading of and modification to metadata

information. Therefore, the task is not parsed, and no execution plan is provided. The

task is directly submitted for execution. The latter one has a faster response speed than

the former one. Which of the following operations on the table t_test is a computational

task?

desc t_test

alter table t_test add columns (comments string);

select count(*) from t_test;

truncate table t_test;