Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home QlikView QSDA2024

QlikView QSDA2024 Exam Practice Questions (P. 2)

  • Full Access (50 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
Refer to the exhibit.

The salesperson ID and the office to which the salesperson belongs is stored for each transaction. The data model also contains the current office for the salesperson. The current office of the salesperson and the office the salesperson was in when the transaction occurred must be visible. The current source table view of the model is shown. A data architect must resolve the synthetic key.
How should the data architect proceed?
  1. A
    Comment out the Office in the Transaction table
  2. B
    Inner Join the Transaction table to the CurrentOffice table
  3. C
    Alias Office to CurrentOffice in the CurrentOffice table
  4. D
    Force concatenation between the tables

Correct Answer: C ?️

Question #7
Refer to the exhibit.

A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerID and CustomerKey.
Which script should the data architect use?
  1. A
    OrderDetails:
    LOAD OrderKey, CustomerKey AS CustomerID, LineTotal, ProductKey;
    SQL SELECT * FROM OrderDetails;
    Customers:
    LOAD CustomerID, AccountNumber, CustomerName;
    SQL SELECT * FROM Customers;
  2. B
    OrderDetails:
    LOAD OrderKey, AUTONUMBER(CustomerKey), LineTotal, ProductKey;
    SQL SELECT * FROM OrderDetails;
    Customers:
    LOAD AUTONUMBER (CustomerID) AS CustomerKey, AccountNumber, CustomerName;
    SQL SELECT * FROM Customers;
  3. C
    OrderDetails:
    LOAD OrderKey, CustomerKey, LineTotal, ProductKey;
    SQL SELECT * FROM OrderDetails;
    ALIAS CustomerKey AS CustomerID;
    Customers:
    LOAD CustomerID AS CustomerKey, AccountNumber, CustomerName;
    SQL SELECT * FROM Customers;
  4. D
    OrderDetails:
    LOAD OrderKey, CustomerKey, LineTotal, ProductKey;
    SQL SELECT * FROM OrderDetails;
    Customers:
    LOAD CustomerID, AccountNumber, CustomerName;
    RENAME FIELD CustomerKey TO CustomerID;

Correct Answer: A ?️

Question #8
Refer to the exhibit.

A data architect wants to transform the input data set to the output data set. Which prefix to the Qlik Sense LOAD command should the data architect use?
  1. A
    HierarchyBelongsTo
  2. B
    Peek
  3. C
    Generic
  4. D
    PivotTable

Correct Answer: C ?️

Question #9
A data architect receives an error while running script.
What will happen to the existing data model?
  1. A
    The data model will be removed from the application.
  2. B
    The latest error-free data model will be maintained.
  3. C
    Newly loaded tables will be merged with the existing data model until the error is resolved.
  4. D
    The data model will be replaced with the tables that were successfully loaded before the error.

Correct Answer: B ?️

Question #10
Refer to the exhibit.

The Orders table contains a list of orders and associated details. A data architect needs to replace the SupplierID with the SupplierName using the second table as the source.
The output must be a single table.
Which script should the data architect use?
  1. A
    SuppliersMap:
    MAPPING LOAD SupplierName, SupplierID;
    SQL SELECT SupplierID, SupplierName FROM Suppliers;
    LOAD *, APPLYMAP('SupplierName', SupplierID) AS SupplierName RESIDENT Orders;
    DROP TABLE Orders;
  2. B
    LEFT JOIN(Products)
    LOAD SupplierID,
    SupplierName;
    SQL SELECT SupplierID, SupplierName FROM Suppliers;
  3. C
    LEFT JOIN (Products)
    LOAD DISTINCT SupplierID,
    SupplierName;
    SQL SELECT SupplierID, SupplierName FROM Suppliers;
  4. D
    SuppliersNames:
    MAPPING LOAD ID, SupplierName as Name;
    SQL SELECT SupplierID as ID, SupplierName FROM Suppliers;
    LOAD *, APPLYMAP('SupplierNames', SupplierID) AS SupplierName RESIDENT Orders;
    DROP TABLE Orders;

Correct Answer: D ?️

Previous Questions Next Questions

All Pages