QSDA2018 Online Practice Questions and Answers

Refer to the exhibits.

Which corrective action should be taken to achieve the expected view?

A. Alias one of the fields in the Orders table.

B. Use distinct in the LOAD statement.

C. Use Upper () to align the SalesPerson fields.

D. Add a link table.

Refer to the exhibit.

A data architect has two tables that contain Sales and target data for employees. The tables are loaded into Qlik Sense and are associated by EmployeeID. The data architect creates a bar chart of total Sales vs. Target. The architect notices some values for target are too high, and employees with NO sales should be excluded.

Which function should the data architect use to resolve these issues?

A. Left Join

B. Inner Join

C. Left Keep

D. Outer Join

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 major healthcare organization requests a new app with the following requirements:

Users can filter AdmissionDate and DischargeDate by all fields in the master Calendar table

Use an existing QVD file, which includes dates 20 years into the future

Users should not be able to filter on dates that have no associated encounters

Which approach should the data architect take to meet these requirements?

A. 1. Load the Encounters table

2.

Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Admission Date

3.

Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Discharge Date

B. 1. Load the master calendar

2.

Create two mapping tables called AdmissionCalendar and DischargeCalendar from the Resident master calendar that has all fields appropriately named

3.

Load the Encounters and use ApplyMap for the AdmissionDate and DischangeDate appropriately.

C. 1. Load the Master Calendar and Encounters tables.

2.

Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Admission Date

3.

Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Discharge Date

D. 1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission

2.

Load the master calendar as Discharge Calendar and alias the fields to reflect they are for Discharge

3.

Load the Encounters table

An enterprise data warehouse contains 700 million records. This enterprise data warehouse has a three-tiered architecture and uses QVDs.

The Qlik Sense server contains 24 GB RAM and contains two processors with eight cores. The company needs to allow vendors to access a Qlik Sense app anonymously to review past business transactions and current year-to-date performance.

Which method should the data architect use to meet this requirement?

A. Build an On-Demand Application Generation template app and a selection app, and allow vendors to access anonymously.

B. Build an On-Demand Application Generation template app and a selection app, and require vendors to log into Qlik Sense to view the app.

C. Build a Direct Discovery app that enables users to view their individual content using dynamic QVDs.

D. Build a Direct Discovery app that enables users to view their individual content using Section Access.

The dates are stored as strings in the database. The data architect must convert the dates to date format. The reload must be as fast as possible.

Which script should the data architect use?

A.

B. C. D.

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.

A health system needs to analyze patient admission and discharges in a chart with a common date axis that looks like chart below.

The initial date table (InpatientEncounters) contains a patient admission date and discharge date for each patient encounter. The data architect will use set analysis to calculate the number of admissions and discharges in the chart.

The data architect needs to design a data model with a minimum number of tables. Which tables should the data architect create to meet these requirements?

A. AdmissionCalendar, DischargeCalendar, and CommonCalendar

B. AdmissionCalendar and DischargeCalendar

C. DateLink, AdmisiionCalendar, and Dischange Calendar

D. DateLink and CommonCalendar

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