Choose QSDA2018 most accurate study material

A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.
* Encounters, lab orders, and medication data are maintained in three separate tables linked by PatientID
* PatientID values in all three tables are completely accurate
* Patients may have encounters without lab orders or medications
The data architect needs to make sure that the count of patient lab orders is correct. Which method should the data architect to meet this requirement?

• A. Load all three tables and use Count{Distinct PatientID)
• B. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(Distinct LabPatientID)
• C. Load all three tables, create a copy of PatientID in the lab orders table as LabPatientID, and use Count(LabPatientlD)
• D. Load all three tables and use Count(PatientlD)

Stock levels are stored online in a system that keeps information for the current period only.
What should the data architect do to enable analysis of the trends of the stock levels?

• A. for each period and use a binary load task to create a single app
• B. Create an app for each period as it changes and use document chaining Create an app
• C. Use On-Demand App Generation (ODAG) to create new apps from the selected period
• D. Capture the periodic information in an incremental QVD file for use in an app

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 two ways can the data architect use to make additions to the existing script and meet the requirements?
(Choose two.)
A)

B)

C)

D)

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

An enterprise data warehouse contains 700 million records. This enterprise data warehouse has a three-tiered architecture and uses QVDs The Qhk Sense server contains 24 GB RAM and contains two processors with eight cores The company needs to allow vendors to access a Qlik Sense app anonymously to review past business transactions and current year-to-date performance.
Which method should the data architect use to meet this requirement?

• A. Build a Direct Discovery app that enables users to view their individual content using Section Access
• B. Build an On-Demand Application Generation template app and a selection app, and require vendors to log into Qlik Sense to view the app.
• C. Build a Direct Discovery app that enables users to view their individual content using dynamic QVDs
• D. Build an On-Demand Application Generation template app and a selection app, and allow vendors to access anonymously

The dates are stored as strings in the database. The data architect must convert the dates to date format The reload must be as fast as possible.
Which script should the data architect use?
A)

B)

C)

D)

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