AliCloud ACA-BIGDATA1 問題練習

Question No : 1
If a task node of DataWorks is deleted from the recycle bin, it can still be restored.

• A.True
• B.False

答えを確認する

正解:

Question No : 2
In MaxCompute, you can use Tunnel command line for data upload and download.
Which of the following description of Tunnel command is NOT correct: Score 2

• A.Upload: Supports file or directory (level-one) uploading. Data can only be uploaded to a single table or table partition each time.
• B.Download: You can only download data to a single file. Only data in one table or partition can be downloaded to one file each time. For partitioned tables, the source partition must be specified.
• C.Resume: If an error occurs due to the network or the Tunnel service, you can resume transmission of the file or directory after interruption.
• D.Purge: Clears the table directory. By default, use this command to clear information of the last three days.

答えを確認する

正解:

Question No : 3
When we use the MaxCompute tunnel command to upload the log.txt file to the t_log table, the t_log is a partition table and the partitioning column is (p1 string, p2 string).
Which of the following commands is correct?

• A.tunnel upload log.txt t_log/p1="b1”, p2="b2"
• B.tunnel upload log.txt t_log/(p1="b1”, p2="b2")
• C.tunnel upload log.txt t_log/p1="b1"/p2="b2"

答えを確認する

正解:

Question No : 4
There are various methods for accessing to MaxCompute, for example, through management console, client command line, and Java API. Command line tool odpscmd can be used to create, operate, or delete a table in a project. Score 1

• A.True
• B.False

答えを確認する

正解:

Question No : 5
There are three types of node instances in an E-MapReducecluster: master, core, and _____ . Score 2

• A.task
• B.zero-load
• C.gateway
• D.agent

答えを確認する

正解:

Question No : 6
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.Use Intelij IDEA
• C.Use MaxCompute Console
• D.No supported tool yetc

答えを確認する

正解:

Question No : 7
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.truncate table where dt='20180101'
• C.drop partition log (dt='20180101')
• D.alter table log drop partition(dt='20180101')

答えを確認する

正解:

Question No : 8
DataV is a powerful yet accessible data visualization tool, which features geographic information systems allowing for rapid interpretation of data to understand relationships, patterns, and trends.
When a DataV screen is ready, it can embed works to the existing portal of the enterprise through ______. Score 2

• A.URL after the release
• B.URL in the preview
• C.MD5 code obtained after the release
• D.Jar package imported after the release

答えを確認する

正解:

Question No : 9
DataService Studio in DataWorks aims to build a data service bus to help enterprises centrally manage private and public APIs. DataService Studio allows you to quickly create APIs based on data tables and register existing APIs with the DataService Studio platform for centralized management and release.
Which of the following descriptions about DataService Studio in DataWorks is INCORRECT? Score 2

• A.DataService Studio is connected to API Gateway. Users can deploy APIs to API Gateway with oneclick.
• B.DataService Studio adopts the serverless architecture. All you need to care is the query logic of APIs, instead of the infrastructure such as the running environment.
• C.To meet the personalized query requirements of advanced users, DataService Studio provides the custom Python script mode to allow you compile the API query by yourself. It also supports multi-table association, complex query conditions, and aggregate functions.
• D.Users can deploy any APIs created and registered in DataService Studio to API Gateway for management, such as API authorization and authentication, traffic control, and metering

答えを確認する

正解:

Question No : 10
Machine Learning Platform for Artificial Intelligence (PAI) node is one of the node types in DataWorks business flow. It is used to call tasks created on PAI and schedule production activities based on the node configuration. PAI nodes can be added to DataWorks only _________. Score 2

• A.after PAI experiments are created on PAI
• B.after PAI service is activated
• C.after MaxCompute service is activated
• D.Spark on MaxCompute Machine Learning project is created

答えを確認する

正解:

Question No : 11
MaxCompute takes Project as a charged unit. The bill is charged according to three aspects: the usage of storage, computing resource, and data download respectively. You pay for compute and
storage resources by the day with no long-term commitments. Score 1

• A.True
• B.False

答えを確認する

正解:

Question No : 12
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.In most cases, user can consider the partition to be the directory under the file system
• 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.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
• D.MaxCompute partition only supports string type and the conversion of any other types is not allowed
• E.The partition value cannot have a double byte characters (such as Chinese.

答えを確認する

正解:

Question No : 13
Alibaba Cloud Quick BI reporting tools support a variety of data sources, facilitating users to analyze
and present their data from different data sources. ______ is not supported as a data source yet. Score 2

• A.Results returned from the API
• B.MaxCompute
• C.Local Excel files
• D.MySQL RDS

答えを確認する

正解:

Question No : 14
Synchronous development in DataWorks provides both wizard and script modes. Score 1

• A.True
• B.False

答えを確認する

正解:

Question No : 15
Which of the following is not proper for granting the permission on a L4 MaxCompute table to a user. (L4 is a level in MaxCompute Label-based security (LabelSecurity), it is a required MaxCompute Access Control (MAC) policy at the project space level. It allows project administrators to control the user access to column-level sensitive data with improved flexibility.) Score 2

• A.If no permissions have been granted to the user and the user does not belong to the project, add the user to the project. The user does not have any permissions before they are added to the project.
• B.Grant a specific operation permission to the user.
• C.If the user manages resources that have labels, such as datasheets and packages with datasheets, grant label permissions to the user.
• D.The user need to create a project in simple mode

答えを確認する

正解: