Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
 

QlikView QSDA2024 Exam Actual Questions

The questions for QSDA2024 were last updated on Nov. 5, 2024.
  • Viewing page 1 out of 13 pages.
  • Viewing questions 1-4 out of 50 questions
 

Topic 1 - Exam A

Question #1 Topic 1

Refer to the exhibit.

A data architect needs to create a data model for a new app. Users must be able to see:
• Total sales for each customer
• Total sales for a given state
• Customers that have not had any sales
• Names of salesperson and regional account managers
• Total number of sales by date
Which steps should the data architect perform to meet these requirements?

  • A. 1. Use a Mapping Load for the Employees table
    2. Load the Sales table and use ApplyMap to get the names for SalesPersonID and RegionalAcctMgrID
    3. Use a Left Join Load to add the customer details for the Sales table
  • B. 1. Load the Customers table and alias the CustID field as CustomerID
    2. Use a Mapping Load for the Employees table
    3. Load the Sales table and use ApplyMap to get the names for SalesPersonID and RegionalAcctMgrID
  • C. 1. Load the Sales table
    2. Load the Customers table
    3. Load the Employees table twice; name it and alias the EmployeeID field appropriately each time
  • D. 1. Load the Customers table and alias the CustID field as CustomerID
    2. Load the Employees table
    3. Load the Sales table and alias the SalesPersonID and RegionalAcctMgrID fields as EmployeeID
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #2 Topic 1

A data architect needs to load Table_A from an Excel file and sort the data by Field_2.
Which script should the data architect use?

  • A. Temp:

    LOAD -
    Field_1,
    Field_2,

    Field_3 -
    FROM [lib://Data/Table_A.xlsx]
    (ooxml, embedded labels, table is Sheet1);
    Table_A:
    LOAD *
    resident Temp Order by Field_2 asc;
    drop Table Temp;
  • B. Table_A:

    LOAD -
    Field_1,
    Field_2,

    Field_3 -
    FROM [lib://Data/Table_A.xlsx]
    (ooxml, embedded labels, table is Sheet1);
    Order by Field_2 asc;
  • C. Temp:

    LOAD -
    Field_1,
    Field_2,

    Field_3 -
    FROM [lib://Data/Table_A.xlsx]
    (ooxml, embedded labels, table is Sheet1);

    NoConcatenate -
    Table_A:
    LOAD *
    resident Temp Order by Field_2 asc;
    drop Table Temp;
  • D. Table_A:
    LOAD *
    Order by Field_2 asc;

    LOAD -
    Field_1,
    Field_2,

    Field_3 -
    FROM [lib://Data/Table_A.xlsx]
    (ooxml, embedded labels, table is Sheet1);
Reveal Solution Hide Solution   Discussion   1

Correct Answer: A 🗳️

Question #3 Topic 1

A data architect needs to retrieve data from a REST API. The data architect needs to loop over a series of items that are being read using the REST connection.
What should the data architect do?

  • A. Recreate the SQL Statement with the correct parameters
  • B. Use the REST Connector with pagination mechanism
  • C. Use pagination of the REST Connector to create a template of the desired data
  • D. Use With Connection to pass a parameter to the REST URL
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #4 Topic 1

A table is generated resulting from the following script:
LOAD *,
Date(OrderTime) as Date;
LOAD * INLINE [

Order, OrderTime -
‘ABC’, 2022-03-12 10:20:15
‘XYZ’, 2022-03-12 11:21:15
‘DEF’, 2022-03-12 10:21:35];
When the data architect selects a date, some, but NOT all, orders for that date are shown.
How should the data architect modify the script to show all orders for the selected date?

  • A. LOAD *,
    Floor(MakeDate(OrderTime,'YYYY-MM-DD')) as Date;
    LOAD * INLINE [

    Order, OrderTime -
    ‘ABC’, 2022-03-12 10:20:15
    ‘XYZ’, 2022-03-12 11:21:15
    ‘DEF’, 2022-03-12 10:21:35];
  • B. LOAD *,
    Date(OrderTime,'YYYY-MM-DD') as Date;
    LOAD * INLINE [

    Order, OrderTime -
    ‘ABC’, 2022-03-12 10:20:15
    ‘XYZ’, 2022-03-12 11:21:15
    ‘DEF’, 2022-03-12 10:21:35];
  • C. LOAD *,
    Date#(OrderTime,'YYYY-MM-DD') as Date;
    LOAD * INLINE [

    Order, OrderTime -
    ‘ABC’, 2022-03-12 10:20:15
    ‘XYZ’, 2022-03-12 11:21:15
    ‘DEF’, 2022-03-12 10:21:35];
  • D. LOAD *,
    Date(Floor(OrderTime),'YYYY-MM-DD') as Date;
    LOAD * INLINE [

    Order, OrderTime -
    ‘ABC’, 2022-03-12 10:20:15
    ‘XYZ’, 2022-03-12 11:21:15
    ‘DEF’, 2022-03-12 10:21:35];
Reveal Solution Hide Solution   Discussion  

Correct Answer: D 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel