QSDA2018 Online Practice Questions and Answers

A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.

Encounters, lab orders, and medication data are maintained in three separate tables linked by

PatientID

PatientID values in all three tables are completely accurate

Patients may have encounters without lab orders or medications

The data architect needs to make sure that the count of patient lab orders is correct.

Which method should the data architect to meet this requirement?

A. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count (Distinct LabPatientID)

B. load all three tables and use Count(Distinct PatientID)

C. load all three tables and use Count(PatientID)

D. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use count (LabPatientID)

Refer to the exhibit.

The business analyst previews some data and notices different values for the United States in the Country field. The analyst must be able to report the total sales for the United States. The data architect must fix this issue in the LOAD script.

Which function should the data architect use to fix data quality issue?

A. Switch

B. ApplyMap

C. Case

D. Replace

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

Refer to the exhibit.

A global company recently released an app that uses mush more memory than similar apps have used. When reviewing data in the data manager, the data architect observes that several fields use Globally Unique Identifiers (GUIDs).

There is one key field. other fields are used to different KPIs to count the number records. The data architect must reduce the memory used as much as possible.

Which steps should a data architect take to meet these requirements?

A. 1. Use the AutoNumber function to convert the linking GUIDs to numbers

2. Replace the non-key GUID fields with a flag, and use them to get a unique count for KPIs

B. 1. Replace the non-key field GUIDs with RowNo() to maintain a field that can be used to get a unique count

2. Split the linking GUID fields into five sections using the SubField function to reduce the uniqueness.

C. 1. Use the AutoNumber function to convert the linking GUIDs to numbers

2. Use Indexing for non-key GUID fields to create an Index field and use to get a unique count for KPIs

D. 1. Use the IterNo() function to convert the linking GUIDs to numbers

2. Replace the non-linking GUID fields with RowNo() to create an Index field and use to get a unique count for KPI

Refer to the exhibit.

The Country field in a CRM app is a free-form text field. More spelling variations and countries are expected in the future. A data architect must create a field called CountryCode based on the value in the Country field.

Which script should the data architect create to perform this task?

A. B. C. D.

Refer the exhibit.

A new app is being developed. Users need to see:

Total sales for each customer

Total sales for given state

Customers that have not had any sales

Names of salesperson and regional manager

Total number of sales by date

The data architect constructs several data models and tests the validity of each model.

Which two data models meet these requirements? (Choose two.)

A.

The data architect aliases the MrgID field to RegionalAcctMgrID and the CustID field in the Customers table.

B.

The data architect loads two copies of the Employees table, aliases the appropriate fields, and aliases the CustID field when loading the Customers table.

C.

The data architect performs two Left Joins to the Sales table to get the Employee names and loads the Customers table aliasing the CustID field.

D.

The data architect performs three Left Joins to load the Customer and Employee data fields into the Sales table.

A data architect needs to develop three separate apps (Sales, Finance, and Operations). The three apps share numerous identical calculation expressions. The data architect wants to reduce duplicate script and stores it on a file server that Qlik Sense can access.

How should the data architect complete requirements?

A. Call batch file

B. Macro on server

C. Execute server script

D. Include script function

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')

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. Associate the Section Access table with the data model

B. Name the field for data reduced as "SectionAccess"

C. Capitalize field names and values

D. Capitalize only field values

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