QUESTION 14
A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze dat a. Some fields must NOT appear in any field list.
How should a data architect meet these requirements?

QUESTION 15
Refer to the exhibit.

QUESTION 16
A data architect executes the following script:
What will Field_1 contain after this script is executed?

QUESTION 17
Refer to the exhibit.

USER1 has an app protected using this Section Access statement.
Which countries can USER1 see in the app”

QUESTION 18
Refer to the exhibits.

A business analyst needs to see the currency conversion rate for any given date in a chart The currency conversion rate data comes from Qlik DataMarket and only contains a record when the rate changes An existing master calendar exists in the data model which contains a full set of dates Which technique should the data architect use to meet this requirement?

QUESTION 19
Refer to the exhibit.

A data architect needs to analyze the number of orders by customer. The data is stored in two Excel files: Orders and Customers The data architect creates a bar chart, but the data is obviously incorrect. What should the data architect do to resolve this issue?

QUESTION 20
Refer to the exhibit.

A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A.
(For example, only the row containing A. 1. 456 should be loaded from Table_B ) Which script should the data architect use?
A)

B)

C)

D)

QUESTION 21
Refer to the exhibit.

A data architect has a data model that includes historical order fulfillment centers. The order fulfillment centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per location basis.
Which scripting function should the data architect use to meet this data modeling requirement?

QUESTION 22
Refer to the exhibit.

This table contains information about the number of admissions and discharges of patients in a hospital. The values can be positive or negative. The data architect needs to create an extra column that contains the number of patients that are currently in the hospital.
Which script should the data architect use ?
A)

B)

C)

D)

QUESTION 23
Refer to the exhibits.

Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two 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.
How should the data architect resolve the errors?

QUESTION 24
Refer to the exhibit.

A business department is forecasting revenue within an Excel spreadsheet.
A data architect needs to include this forecast into the existing data model, and without losing any data.
Which two sets of steps will meet these requirements? (Select two.)

QUESTION 25
Refer to the exhibit.

A business analyst reports that the ‘CompanyAge’ field does NOT display for users The data architect 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?

QUESTION 26
A data architect needs to create an app to analyze 30-day re-admissions at a hospital.
* 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 dateWhich action should the data architect perform first to meet these requirements?

QUESTION 27
A data architect creates a collection of large QVD files that propagate data into their apps This solution works well.
However, a new app that uses a subset of the data in a QVD takes much longer than expected to reload The LOAD statement is

Which two changes should be made to improve load performance? (Select two ) A)

B)

C)

D)

QUESTION 28
Refer to the exhibit.

An app has been built to analyze salesperson performance by department. Salespeople often move between departments. There is a strict business rule which states a salesperson must be associated with ONLY one department at all times.
The data architect creates a summary of department performance and notices the values are incorrect. The KPI showing the total sales shows the correct result.
How should the data architect modify the data model to correct the issue?

QUESTION 29
Refer to the exhibit.

The data architect needs to build a model that contains Sales and Budget data for each customer. Some customers have Sales without a Budget, and other customers have a Budget with no Sales During loading, the data architect resolves a synthetic key by creating the composite key For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.
What does the data architect see when selecting a month?