QlikView QSDA2018 Online Practice Questions and Exam Preparation

QlikView QSDA2018 Online Questions & Answers

• Question 1:

  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
  B. IntervalMatch

• Question 2:

  The data model from an existing Qlik Sense app needs to be reused in another Qlik Sense app. Which load strategy should a data architect use to transfer this data in the most efficient way?

  A. Generic load
  B. Preceding load
  C. Binary load
  D. QVD load
  C. Binary load

• Question 3:

  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.
  A. Alias one of the fields in the Orders table.

• Question 4:

  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. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

• Question 5:

  Refer to the exhibit.

  

  A data architect is reviewing an app that is under development. The app as NOT been published. All data has been validated in all charts and KPIs. The data architect notices that the data model has two fact tables with common field names that cause a synthetic join.

  Which step should the data architect take to correct the data model without affecting the app?

  A. Concatenate LOAD the data from the Sales and Budget tables to combine into a single table.
  B. Create a composite key in the Sales and Budget tables that consists of the Year, EmployeeID, and ProductID
  C. Perform a composite key in the Sales and Budget tables instead of loading Year, EmployeeID, and ProductID
  D. Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables.
  D. Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables.

• Question 6:

  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. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 7:

  Refer to the exhibit.

  

  A data architect loads order data for a global sales organization. The Order Details contains 100 million rows. The data architect must load only the data for the North America division. Which WHERE clause should the data architect use in the Order Details LOAD script?

  A. WHERE Division = `North America";
  B. WHERE Exists(OrderNum);
  C. WHERE OrderNum = [Order Header].[OrderNum];
  D. WHERE Exists(`North America');
  B. WHERE Exists(OrderNum);

• Question 8:

  Refer to the exhibits.

  

  Which values of the REGION field will be visible for User C when the user opens the app?

  A. EAST, WEST, and SOUTH
  B. NORTH, EAST, and WEST
  C. NORTH, EAST, WEST, and SOUTH
  D. EAST and WEST
  C. NORTH, EAST, WEST, and SOUTH

• Question 9:

  Refer to the exhibit.

  

  A data architect needs to build a sales dashboard. Data is stored in a legacy database. The extracted data contains the date in the format, `YYYDDMM'. Due to the source date format, the dates are being loaded as numbers. Which function should the data architect use to fix this issue?

  A. Timestamp
  B. Date
  C. Date#
  D. Timestamp#
  C. Date#

• Question 10:

  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
  B. ApplyMap