Online Access Free QSDA2021 Exam Questions

Refer to the exhibit.

Which changes on the database will the script capture?

• A.Insert and Remove rows
• B.Update and Remove rows
• C.Insert. Update, and Remove rows
• D.Insert and Update rows

Refer to the exhibit.

A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments. To understand the table structure, the business has given the following summary:
* Every order creates a unique orderlD and an order date in the Orders table
* An order can contain one or more order lines one for each product ID in the order details table
* Products in the order are shipped (shipment date) as soon as tliey are ready and can be shipped separately
* The dates need to be analyzed separately by Year Month, and Quarter
The data architect realizes the data model has issues that must be fixed.
Which steps should the data architect perform?

• A.1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
  2. Delete the ShipmentID in the Orders table
  3 Delete the ProductID and OrderlD in the Shipments table
  4. Concatenate Orders and OrderDetails
• B.1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table
  2. Delete the ShipmentID in the Shipments table
  3. Delete the ProductID and OrderlD in the OrderDetails table
  4. Concatenate Orders and OrderDetails
  5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate
• C.1. Create a key with OrderlD and ProductID in the OrderDetails tab e and in the Orders table
  2. Delete the ShipmentID in the Shipments table
  3. Delete the ProductID and OrderlD in the OrderDetails
  4. Left join Orders and OrderDetails
  5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate
• D.1. Create a key with OrderlD and ProductID in the OrderDeta Is table and in the Shipments table
  2. Delete the ShipmentID in the Orders table
  3. Delete the ProductID and OrderlD in the Shipmi
  4. Left join Orders and OrderDetails
  5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

A company has a stream with multiple apps One of the apps is a multi-regional sales app.
A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.
Which features should the data architect use to meet these requirements?

• A.Section access and set analysis
• B.QMC security rules and section access
• C.Section access and sheet properties
• D.QMC security rules and custom properties

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 CustomerlD and CustomerKey.
Which script is valid to load the tables and maintain the correct association?
A)

B)

C)

D)

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

A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.
The OrderDate and ShipmentDate are located in different tables.
The user needs to identify the data type and must be able to:
* Show trends for orders and shipments
* Use a single filter for both date fields
* Analyze data over fiscal periods
Which steps should the data architect take to build the data model?

• A.1. Create a master calendar table as a data island
  2. Create a single filter using fields from the master calendar
• B.1. Load the Shipments and Orders table via the data manager
  2. Create a single filter using fields from the Orders table
• C.1. Create a master calendar and join into the Shipments and Orders table
  2. Create a single filter using fields from the Shipments table
• D.1. Create a link table with master calendar fields
  2. Create a single filter using fields from the master calendar