DA01-20_在线真题试卷与模拟练习_DA01-20

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Multiple department fields in a dataset require a description NOT have a description Which strategy should the data architect use to meet these requirements?

Refer to the exhibits. （含图） contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the data model that contains a full set of dates. Which technique should the data architect use to meet this requirement?

Refer to the exhibit （含图） examines the LOAD script and wants to place the breakpoint in the script to check the field name. Which line number should the data architect use?

Refer to the exhibit. （含图） Which changes on the database will the script capture?

independent file.The structure of the text file with the export rules is as follows: （含图） These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.The TableToExport values are already verified to existin the model. In addition, the format will always be QVD, and the copies will be incrementally numbered. For example, the Customer table would be exported as: What is the minimum set of scripting strategies the data architect must use?

A data architect wants to combine data on present and historic sales performance. The historic data isstored in a de-normalized archive, and the present data is maintained in a database. The output must becontained in a single table.Which script should the data architect use?

Refer to the exhibit. （含图） data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam. The data architect selects the field "StudentID" from the Students table and sees the following: （含图） What should the data architect do to ensure data integrity?

A data architect needs to upload different data sources. To properly handle null values,the data architect decides to set all of these values to "Missing Value".Which syntax should the data architect use?

A data architect executes the following script:

（含图） What will be the result of Table A?

Refer to the exhibit. （含图）

A data architect loads sales data and creates a table which shows only customers who made purchasesin 2018 and 2019. The data architect applies the following set analysis expression on the sales measure.Count<{<Year={'2018'}, CustomerID=P({<Year={'2019*}>})>} Customer ID)Which option shows the resulting table after the expression is applied?

the highest sales. The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people Which expression should the data architect use?

Refer to the exhibit. （含图）

A global sales organization operates in three regions: AMERICAS, EMEA: and APAC. Each region stores its sales transactions in a separate database in which the employees update customer data through a third-party app. The data is extracted into three QVDs. A data architect sets up a two-tier architecture for the data load. The data architect needs to add the region to the data model. Which technique should the data architect use to create the Region field?

• The medical record system does NOT calculate re-admission data • The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission" • Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge date Which action should the data architect perform first to meet these requirements?

A data architect needs to load Table_A from an Excel file and sort the data by Field_2.Which script should the data architect use?

permissions to colleague to help the HR team publish apps. Which action(s) should the manager assign to the colleague before going on leave?

A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails. Which statement should the data architect use?

Refer to the exhibit.

A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey. Which script is valid to load the tables and maintain the correct association?

Refer to the exhibit. （含图） How should the data architect resolve the synthetic key?

The data is retrieved using the following statement: （含图） It must be clear to the end user that this is geographic data. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data? (Select two.)