March Sale Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

QSDA2022 PDF

$38.5

$109.99

3 Months Free Update

  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

QSDA2022 PDF + Testing Engine

$61.6

$175.99

3 Months Free Update

  • Exam Name: Qlik Sense Data Architect Certification Exam-2022
  • Last Update: Mar 28, 2024
  • Questions and Answers: 77
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

QSDA2022 Engine

$46.2

$131.99

3 Months Free Update

  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

QSDA2022 Qlik Sense Data Architect Certification Exam-2022 Questions and Answers

Question # 6

A data architect needs to create an app to analyze 30-day re-admissions at a hospital.

• The medical record system does NOT calculate re-admission data

• The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission"

• Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge date

Which action should the data architect perform first to meet these requirements?

A.

Sequence patient records by hospital account ID and patient ID using the Peek function

B.

Sequence patient records by patient ID using the Peek function

C.

Calculate the days since previous discharge using admission date and discharge date

D.

Order patient records by patient ID and admission date

Full Access
Question # 7

Refer to the exhibit.

QSDA2022 question answer

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 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

B.

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

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 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

Full Access
Question # 8

The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.

Which method should the data architect use to manage the modifications in all apps?

A.

Create a variable repository and load them using INCLUDE statements in the apps where needed

B.

Create a selection app with all the master items and use an on-demand app generation method.

C.

Create a core app with all the master items needed and use a BINARY load in the other apps.

D.

Create only a single app with all the master items needed and protect it with SECTION ACCESS.

Full Access
Question # 9

Refer to the exhibit.

QSDA2022 question answer

This table contains information about the number of admissions and discharges of patients in a hospital. The values can be positive or negative. The data architect needs to create an extra column that contains the number of patients that are currently in the hospital.

Which script should the data architect use ?

A)

QSDA2022 question answer

B)

QSDA2022 question answer

C)

QSDA2022 question answer

D)

QSDA2022 question answer

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 10

A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people

Which expression should the data architect use?

A.

FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )

B.

Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')

C.

FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )

D.

Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')

Full Access
Question # 11

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.

QMC security rules and custom properties

D.

Section access and sheet properties

Full Access