Refer to the exhibit.

The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company. As a business requirement, users must be able to drill down by department and country. Data must not be lost. Due to data quality issues, some departments are NOT included in the Sales and Budget tables. The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model.

Which method should the data architect use?

A. A link table to associate the two tables.

B. A forced concatenation statement.

C. Field aliases or comment out redundant fields.

D. A Left Join statement in the script.

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 UniCost, 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. Perform a preceding load on the Product table

2. Create a new field in the OrderDetails table: if((UnitCost ?null() or ", 0) * Quantity as COGS

C. 1. Join the Products and OrderDetails on ProductID

2. Create a new field in the OrderDetails table: Replace(Null, 0, UnitCost) * Quantity as COGS

D. 1. Create a mapping load table as the first table from the Product table

2. Create a new field to the OrderDetails table: ApplyMap (`UnitCost_Map', ProductID, 0) * Quantity as COGS

Payroll managers need access to the payroll system to complete a quarterly report. A username and password is required to access the payroll system through an ODBC connection. Only the system administrator should have access to the credentials and make updates as needed. Each payroll manager who access the app should only see their own employees.

Which two actions are required to set up the appropriate security? (Choose two.)

A. Make sure that the administrator creates appropriate sync rules to access the payroll system

B. Apply the correct section access to restrict data visibility

C. Make sure that the administrator applies security rules to the correct stream to restrict data visibility

D. Apply security rules to the app to restrict data visibility

E. Make sure that the administrator applies the correct security rules to the ODBC connection

Refer to the exhibit.

A fashion retail company needs to analyze data product inventory. The company needs to filter by attributes by such as color, material, and size.

Which strategy should a data architect use to meet these requirements?

A. Turn data rows into fields by using a generic load

B. Use the hierarchy load statement to expand hierarchy levels

C. Use crosstable in the load statement to unpivot

D. Loop through the table to transpose fields

Refer to the exhibits.

Business analytics report data issues in the Value field of a table since the latest reload of the data.

What causing this issue?

A. Null values in the source data

B. Hyphen characters (`-`) in the source data

C. Pre-aggregated data is being used

D. Some categories do NOT exist in the Category table

Refer to the exhibits.

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 EmpID=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. JOIN LOAD EmpID, ManagerID, Level

B. KEEP LOAD EmpID, ManagerID, Level

C. JOIN LOAD *

D. CONCATENATE LOAD EmpID, ManagerID, Level

Refer to the exhibit.

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data. When trying to manually reload the original script, the data architect receives an error.

What should be done to make sure the script runs correctly?

A. Add the line LIB CONNECT TO `SQL (abc_qservice)'; before the LOAD for the OrderDetail table.

B. Give the data architect the Read rights on the data connections in the QMC.

C. Make the data architect the owner of the app in the QMC.

D. Add the LIB CONNECT TO `QVD (abc_qservice/OrderData.qvd)'; before the LOAD for the OrderData table.

Refer to the exhibits.

Executives need to see the total sales by region for the current year. The data architect inherits App1 from the former employee who tries to address this requirement. Two Microsoft Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.

Which method should the data architect use to resolve the errors?

A. In the data manager, split the region table and associate by EmployeeID

B. In the data manager, concatenate the Region table and associate by Region.ID

C. In the data load editor, concatenate the region and Employee tables

D. In the data manager, split the region table and associate by Region.ID

Refer to the exhibit.

A chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis. The date format for the source data field "Common date" is M/D/YYYY. This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built.

Which expression should the data architect use to fix this issue?

A. Date (MonthsStart ([Common Date]), `MMM-YYY')

B. Date (MonthStart ([Common Date]), `MMM-YYY')

C. Date ([Common Date], `MMM-YYY')

D. Date (InMonth([Common Date]), MMM-YYYY')

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 present 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 a text file

B. Add the color codes using expressions

C. Add the color codes in the EDW

D. Add the color codes using variables