Alibaba Cloud ACA-BigData1 問題集

質問 1：
In each release of E-MapReduce, the software and software version are flexible. You can select multiple software versions.
Score 1
A. False
B. True
正解：A

質問 2：
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?
A. select count(*) from t_test;
B. desc t_test
C. alter table t_test add columns (comments string);
D. truncate table t_test;
正解：A

質問 3：
Resource is a particular concept of MaxCompute. If you want to use user-defined function UDF or MapReduce, resource is needed. For example: After you have prepared UDF, you must upload the compiled jar package to MaxCompute as resource. Which of the following objects are MaxCompute resources? (Number of correct answers: 4) Score 2
A. ACL Policy
B. Files
C. Jar: Compiled Java jar package
D. Tables: Tables in MaxCompute
E. Archive: Recognize the compression type according to the postfix in the resource name
正解：A,B,C,D

質問 4：
There are multiple connection clients for MaxCompute, which of the following is the easiest way to configure workflow and scheduling for MaxCompute tasks?
Score 2
A. Use DataWorks
B. No supported tool yetc
C. Use Intelij IDEA
D. Use MaxCompute Console
正解：A

質問 5：
Your company stores user profile records in an OLTP databases. You want to join the serecords with web server logs you have already ingested into the Hadoop file system.
What is the best way to obtain and ingest these user records?
A. Ingest with Hadoop streaming
B. Ingest using Hive
C. Ingest with sqoop import
D. Ingest with Pig's LOAD command
正解：C

質問 6：
A Log table named log in MaxCompute is a partition table, and the partition key is dt. Anew partition is created daily to store the new data of that day. Now we have one month's data, starting from dt='20180101' to dt='20180131', and we may use ________ to delete the data on 20180101.
A. drop partition log (dt='20180101')
B. alter table log drop partition(dt='20180101')
C. truncate table where dt='20180101'
D. delete from log where dt='20180101'
正解：B

質問 7：
Table is a data storage unit in MaxCompute. It is a two-dimensional logical structure composed of rows and columns. All data is stored in the tables. Operating objects of computing tasks are all tables. A user can perform create table, drop table, and tunnel upload as well as update the qualified data in the table.
Score 1
A. False
B. True
正解：B

質問 8：
You are working on a project where you need to chain together MapReduce, Hive jobs.
You also need the ability to use forks, decision points, and path joins. Which ecosystem project should you use to perform these actions?
A. Apache HUE
B. Apache Zookeeper
C. Apache Spark
D. Apache Oozie
正解：D