最新なAlibaba Cloud ACA-BigData1問題集（77題）、真実試験の問題を全部にカバー！

質問 1：
Which node type in DataWorks can edit the Python code to operate data in MaxCompute?
Score 2
A. ODPS MR Node
B. ODPS Script Node
C. SHELL node
D. PyODPS
正解：D

質問 2：
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 sqoop import
B. Ingest with Pig's LOAD command
C. Ingest using Hive
D. Ingest with Hadoop streaming
正解：A

質問 3：
In MaxCompute command line, if you want to view all tables in a project, you can execute command:
______.
Score 2
A. desc tables;
B. show tables;
C. select tables;
D. use tables;
正解：B

質問 4：
In order to ensure smooth processing of tasks in the Dataworks data development kit, you must create an AccessKey. An AccessKey is primarily used for access permission verification between various Alibaba Cloud products. The AccessKey has two parts, they are ____. (Number of correct answers: 2) Score 2
A. Access Username
B. Access Password
C. Access Key ID
D. Access Key Secret
正解：C,D

質問 5：
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. delete from log where dt='20180101'
B. drop partition log (dt='20180101')
C. truncate table where dt='20180101'
D. alter table log drop partition(dt='20180101')
正解：D

質問 6：
Where is the meta data(e.g.,table schemas) in Hive?
Score 2
A. Stored along with the data in HDFS
B. Stored in the RDBMS like MySQL
C. Stored in ZooKeeper
D. Stored as metadata on the NameNode
正解：B

質問 7：
In order to improve the processing efficiency when using
MaxCompute, you can specify the partition when creating a
table. That is, several fields in the table are specified as
partition columns. Which of the following descriptions aboutMaxCompute partition table are correct?
(Number of correct
answers: 4)
A. If the partition columns to be accessed are specified
when using data, then only corresponding partitions are
read and full table scan is avoided, which can improve the
processing efficiency and save costs
B. User can specify multiple partitions, that is, multiple
fields of the table are considered as the partitions of the
table, and the relationship among partitions is similar to
that of multiple directories
C. MaxCompute partition only supports string type and the
conversion of any other types is not allowed
D. The partition value cannot have a double byte characters
(such as ChinesE.
E. In most cases, user can consider the partition to be the
directory under the file system
正解：A,B,D,E

質問 8：
MaxCompute is a general purpose, fully managed, multi-tenancy data processing platform for largescale data warehousing, and it is mainly used for storage and computing of batch structured data. Which of the following is not a use case for MaxCompute?
Score 2
A. User profile
B. Date Warehouse
C. Social networking analysis
D. Order management
正解：D