최신 Qlik Sense Data Architect QSDA2018 무료샘플문제:

1. Refer to the exhibit.

In the data load editor, the tables are loaded in the following sequence;
1 OrderHeader
2. OrderDetails
3. Products
The three tables CANNOT be modified as all fields are required.
A data architect must create a Cost of Goods Sold (COGS) field calculated as UnitCost * Quantity. Some products may NOT have UnitCost so the COGS value must be zero for these products.
How should the data architect meet this requirement?

A) 1. Load the Products table as the first table
2. Create a new field in the OrderDetails table: Quantity * isNull (unitcost) as cogs
B) 1 Join the Products and OrderDetails tables on ProductID
2. Create a new field in the OrderDetails table: Replace (Null, o, unitcost) * Quantity as cogs
C) 1. Create a mapping load table as the first table from the Products table
2. Create a new field to the OrderDetails table: toplyMap('unitcos^Map', ProductID, 0) * Quantity as cogs
D) 1. Perform a preceding load on the Products table
2. Create a new field in the OrderDetails table, if (Unitcost = nulio or *', 0) * Quantity as cogs

2. A company builds several apps to help analyze product performance
* Each app is for a specific business area: Marketing, Sales, or Production
* Users must see updated data daily
* Data is taken from the enterprise data warehouse (EDW)
* Change requests for the data warehouse take approximately 6 weeks
* One of the dimensions used across all of the apps is product group
* There are six different product groups
To provide users with an intuitive way of working with data, the colors that represent the product groups must be the same in all apps The RGB color codes for each product group will be provided to the data architect by e-mail How should the data architect add consistent colors for the product group dimension that are easy to maintain?

A) Add the color codes using variables
B) Add the color codes using expressions
C) Add the color codes using a text file
D) Add the color codes in the EDW

3. Refer to the exhibit.

The two tables have been loaded by the script shown This script creates a synthetic key, which is not desired.
The Dept code in the Employee table is incorrect for EmplD=3
The data architect must change line 27 to create a single table in the data model that is accurate Which LOAD statement should the data architect use?

A) CONCATENATE LOAD EmpID, ManagerlD, Level
B) KEEP LOAD EmpID, ManagerlD, Level
C) JOIN LOAD EmpID, ManagerlD, Level
D) JOIN LOAD *

4. Refer to the exhibit.

Each order can-have multiple products The data architect needs to make sure the Amount can be analyzed by Order Type and Product Category.
The Order Number field data always contains the Order Type in the first three characters Product. Product Category, and Sales Channel data are available in an Excel spreadsheet called "Categories" in the file PaperProducts xlsx.
Which two ways can the data architect use to make additions to the existing script and meet the requirements?
(Choose two.)
A)

B)

C)

D)

A) Option C
B) Option B
C) Option A
D) Option D

5. Refer to the exhibit.

The data architect is using section access to meet the security requirements of an app After the first draft, the data architect discovers that users can NOT see the right subset of data Which solution should a data architect use to fix this issue?

A) Capitalize field names and values
B) Name the field for data reduced as SectionAccess'
C) Associate the Section Access table with the data model
D) Capitalize only field values

질문과 대답: