QlikView QSDA2018 Online Practice Questions and Exam Preparation

QlikView QSDA2018 Online Questions & Answers

• Question 31:

  Refer to the exhibits.

  

  A company notices that product sales have decreased. A data architect needs to create an app to show the correlation between the decreased revenue and the latest customer survey results. Which Qlik Sense feature should the data architect use to meet this requirement?

  A. Section access
  B. On-demand App Generation
  C. Master item library
  D. Associative data model
  C. Master item library

• Question 32:

  Payroll managers need access to the payroll system to complete a quarterly report. A username and password is required to access the payroll system through an ODBC connection. Only the system administrator should have access to the credentials and make updates as needed. Each payroll manager who access the app should only see their own employees.

  Which two actions are required to set up the appropriate security? (Choose two.)

  A. Make sure that the administrator creates appropriate sync rules to access the payroll system
  B. Apply the correct section access to restrict data visibility
  C. Make sure that the administrator applies security rules to the correct stream to restrict data visibility
  D. Apply security rules to the app to restrict data visibility
  E. Make sure that the administrator applies the correct security rules to the ODBC connection
  B. Apply the correct section access to restrict data visibility
  E. Make sure that the administrator applies the correct security rules to the ODBC connection

• Question 33:

  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.
  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.
  D. The data architect performs three Left Joins to load the Customer and Employee data fields into the Sales table.

• Question 34:

  Refer to the exhibits.

  

  A business analyst must see a currency conversion rate for any given date in a chart. The currency conversion rate data is held in a separate table in the database and only contains a record when the rate changes. An existing master calendar exists in the data model that contains a full set of dates.

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

  A. Join the calendar with the currency conversion table Order by date and use the Peek function to fill in the blank values
  B. Use IterNo and autogenerate to create a new calendar max and min dates of the currency conversion table Force concatenate with the master calendar
  C. 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
  D. Use IntervalMatch to load the currency conversion rate between dates the conversion changed Inner Join the resultant table back into the master calendar
  A. Join the calendar with the currency conversion table Order by date and use the Peek function to fill in the blank values

• Question 35:

  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
  A. Right(`$(vSalesSheet)' as SalesYear
  C. SubField($(vSalesSheet)',' `,2) as SalesYear

• Question 36:

  Refer to the exhibit.

  

  The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company. As a business requirement, users must be able to drill down by department and country. Data must not be lost. Due to data quality issues, some departments are NOT included in the Sales and Budget tables. The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model.

  Which method should the data architect use?

  A. A link table to associate the two tables.
  B. A forced concatenation statement.
  C. Field aliases or comment out redundant fields.
  D. A Left Join statement in the script.
  A. A link table to associate the two tables.

• Question 37:

  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
  B. Inner Join

• Question 38:

  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
  D. In the data manager, split the region table and associate by Region.ID

• Question 39:

  A data architect uses the Qlik GeoAnalytics connector to determine the closest airports to cities in an existing app. The built location generates data for the airport locations. The data load editor runs the script and sees a circular reference and a synthetic key.

  How should the data architect fix these issues?

  A. When selecting an operation in the Qlik GeoAnalytics connector, select Only load distinct.
  B. When choosing which data to load, uncheck the non-unique field in the new data tables.
  C. Concatenate the airport table and the existing tables into one master tables.
  D. When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to "None".
  D. When selecting an operation in the Qlik GeoAnalytics connector, change the CRS to "None".

• Question 40:

  Refer to the exhibit.

  

  Each order can have multiple products. The data architect needs to make sure the Amount can be analyzed by order Type and product Category.

  The Order Number field data always contains the order Type in the first three characters. Product, Product Category, and Sales Channel data are available in an Excel spreadsheet called "Categories" in the file PaperProducts.xlsx.

  Which way can the data architect use to make additions to the existing script and meet the requirements?

  

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