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.

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

Refer to the exhibit.

A data architect needs to transform the values for SalesYear from `Sales 2016' to display only the year values `2016' and `2017' in the table.

Which two functions can the data architect use to accomplish this in the script? (Choose two.)

A. Right(`$(vSalesSheet)' as SalesYear

B. Left($(vSalesSheet)' 4) as SalesYear

C. SubField($(vSalesSheet)',' `,2) as SalesYear

D. LTrim(`$(vSalesSheet)') as SalesYear

E. SubField($(vSalesSheet)',' `,1 ) as SalesYear

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.

A data architect is working on a time and expense app for an organization that has Sales, Marketing, and Finance departments/ Department managers should only be able to view the data for their department's team members.

Where should the data architect apply this security restriction?

A. Data load editor

B. Qlik Management Console

C. Expression editor

D. Data manager

Refer to the exhibit.

One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only was values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region.

Which function should the data architect implement to resolve this issue?

A. CrossTable

B. IntervalMatch

C. Above

D. Previous

Stocks levels are stored online in a system that keeps information for the current period only.

What should the data architect do to enable analysis of the trends of the stock levels?

A. Use On-Demand App Generation (ODAG) to create new apps from the selected period

B. Capture the periodic information in an incremental QVD file for use in an app

C. Create an app for each period as it changes and use document chaining

D. Create an app for each period and use a binary load task to create a single app

Refer to the exhibit.

A system creates log files and csv files daily and places these files in a folder. The log files are named automatically by the source system and charge regularly. All csv files must be loaded into Qlik Sense for analysis.

Which method should be used to meet the requirements?

A. B. C. D.

Refer to the exhibits.

A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum ([Budgeted Sales]) are calculated correctly.

Which load script meets these requirements?

A.

B. C.

D.

Sales managers need to see an overview of historical performance and highlight the current year's metrics.

App requirements:

Display the current year's total sales

Total sales displayed must respond to the user's selections

Which variables should a data architect create to meet these requirements?

A. B. C. D.

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

A customer must create a production app that pulls data from two sources.

Source 1 is large legacy system. It takes more than one hour to read and save the data to QVD. reading from the QVD only takes 20 seconds. The data only needs to be refreshed every month because it does not change very often.

Source 2 is small online data source. reloading this data takes less than one minute. The production app must be refreshed every hour to see the most updated data and needs both data sets to meet te analysis requirements.

How should the data architect set up the data reload?

A. 1. Create two QVD generation apps

2.

Create two scheduled tasks: one runs every month and one runs every hour

3.

Load the data in the production app from the QVDs

4.

Create a task to run every hour to reload the production app

B. 1. create a QVD generation app to pull both data sources in different script sections

2.

Create two reload schedules from the QVD app based on the script section

3.

Build the production app using the QVD files

4.

Create a task to run every hour to reload the production app.

C. 1. Create the production app to connect to both data sources

2.

Create a variable and set this to the last reload time using ReloadTime() function

3.

Use an IF() statement and only load the legacy data when Today() > 30 days from last reload

4.

Create a task to run every hour to reload the production app

D. 1. Create a QVD generation app for the legacy system only

2.

Create a scheduled task to generate the QVD every month

3.

Build the production app using the QVD and use ADD LOAD prefix to connect to the online data source

4.

Create a task to run every hour to perform a partial reload on the production app