QlikView QSDA2019 Online Practice Questions and Exam Preparation

QlikView QSDA2019 Online Questions & Answers

• Question 21:

  A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies: Source 1 Contains frequently updated data and must be refreshed hourly Source 2 Contains data that is transferred from a partner and must be refreshed weekly

  Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs.

  Which tasks should be created to meet these requirements?

  A. 1. ScheduleTask 1 to run hourly and refresh data from Source 1 2. ScheduleTask 2 to run weekly and refresh data from Source 2 3. Schedule a task for the app that is dependent on completion ofTasks 1 or 2 that loads the two QVDs
  B. 1. ScheduleTask 1 to run hourly and refresh data from Source 1 2. ScheduleTask 2 that is dependent onTask 1 to refresh data from Source 2 3. Schedule a task for the app that is dependent on completion ofTask 2 that loads the two QVDs
  C. 1. ScheduleTask 1 to run hourly and refresh data from Source 1 2. ScheduleTask 2 that is dependent onTask 1 to refresh data from Source 2 3. Schedule a task for the app that is dependent on completion ofTasks 1 and 2 that loads the two QVDs
  D. 1. ScheduleTask 1 to run hourly and refresh data from Source 1 2. ScheduleTask 2 to run weekly and refresh data from Source 2 3. Schedule a task for the app that is dependent on completion ofTask 2 that loads the two QVDs
  D. 1. ScheduleTask 1 to run hourly and refresh data from Source 1 2. ScheduleTask 2 to run weekly and refresh data from Source 2 3. Schedule a task for the app that is dependent on completion ofTask 2 that loads the two QVDs

• Question 22:

  Refer to the exhibit.

  

  A data architect is loading the tables and a synthetic key is generated. How should the data architect resolve the synthetic key?

  A. Create a composite key using OrderlD and LineNo
  B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
  C. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field
  D. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments
  A. Create a composite key using OrderlD and LineNo

• Question 23:

  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?

  A. All Customers, all Budget and all Sales records
  B. Customer and Sales records for that month, but missing values for Budget
  C. Customer and Budget records for that month, but missing values for Sales
  D. Customer, Sales, and Budget records for that month
  C. Customer and Budget records for that month, but missing values for Sales

• Question 24:

  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?

  A. Outer Join the calendar with the currency conversion table Order by the date and use the Peek function to fill in blank values
  B. Use a FOR loop between the start date and end date of the master calendar Use the Match function to add the currency conversion rates to the master calendar
  C. Use IntervalMatch to load the currency conversion rate between dates the conversion changed Inner Join the resultant table back into the master calendar
  D. Use IterNo and AutoGenerate to create a new calendar from max and mm dates of the currency conversion table Force concatenate with the master calendar
  A. Outer Join the calendar with the currency conversion table Order by the date and use the Peek function to fill in blank values

• Question 25:

  Refer to the exhibit.

  

  A global sales organization operates in three regions: AMERICAS, EMEA: and APAC. Each region stores its sales transactions in a separate database in which the employees update customer data through a third-party app. The data is

  extracted into three QVDs.

  A data architect sets up a two-tier architecture for the data load. The data architect needs to add the region to the data model.

  Which technique should the data architect use to create the Region field?

  A. Create a Region field in the SalesTransaction table and populate using fixed region values while loading from each source
  B. Create a Region field in the Employee table and populate using the LTrim function on the EmployeelD
  C. Create a Region field in the Employee table and populate using the SubField function on the EmployeelD
  D. Create a Region field in the SalesTransaction table and create a mapping table based on the Country field in the Customer table
  D. Create a Region field in the SalesTransaction table and create a mapping table based on the Country field in the Customer table

• Question 26:

  A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system. These systems identify employees differently. Employees in the HR system are identified with an alpha-numeric key. Employees in the Sales system are identified using an integer key The Human Resources manager creates a table which maps these keys to one another, called Associations. The resultant data model must meet the following requirements: Associations must be valid The model must be optimized for performance The option must support multiple tables added from both systems now and in the future

  Which function should the data architect use to meet these requirements?

  A. APPLYMAP { 'Associations' , EmployeeKey) AS EmployeeKey;
  B. MAP EmployeeKey USING Associations;
  C. RENAME FIELDS USING Associations;
  D. MapSubString('Associations', EmployeeKey) AS EmployeeKey;
  A. APPLYMAP { 'Associations' , EmployeeKey) AS EmployeeKey;

• Question 27:

  Multiple department fields in a dataset require a description. A data architect needs to add the department descriptions or a default value when the department does NOT have a description. Which strategy should the data architect use to meet these requirements?

  A. ApplyMap with two parameters after the Mapping load
  B. Left Join between tables and Description.xlsx in every Department table
  C. Enter "Missing description" in the blank rows for Description.xlsx, then use Mapping Load
  D. ApplyMap with three parameters after the Mapping load
  A. ApplyMap with two parameters after the Mapping load

• Question 28:

  Refer to the exhibit.

  

  The Section Access security table for an app is shown User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns.

  What is the result?

  A. The user gets an "Invalid visualization" error
  B. The table is displayed without the LEVEL column
  C. The table is removed from the user interface
  D. The user gets a "Field not found" error
  A. The user gets an "Invalid visualization" error

• Question 29:

  A data architect needs to efficiently prepare a data model for a meeting in an hour. The data source to be used contains five date fields. The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD). The app is NOT going to be published. It will only be used for this meeting and a single user's ad-hoc analysis. What should the data architect do to meet these requirements?

  A. Create a canonical calendar
  B. Load a calendar island
  C. Use the data manager
  D. Create five master calendars
  C. Use the data manager

• Question 30:

  Refer to the exhibit.

  

  The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table. Which script should the data architect use?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C