A health system needs to analyze patient admissions and discharges in a chart with a common date axis that looks like the chart below.

The initial data table (InpatientEncounters) contains a patient admission date and a discharge date for each patient encounter. The data architect will use set analysis to calculate the number of admissions and discharges in the chart.

The data architect needs to design a data model with a minimum number of tables. Which tables should the data architect create to meet these requirements?

• A. DateLink and CommonCalendar
• B. DateLink, AdmissionCalendar. and DischargeCalendar
• C. AdmissionCalendar, DischargeCalendar, and CommonCalendar
• D. AdmissionCalendar and DischargeCalendar

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 a Direct Discovery app that enables users to view their individual content using dynamic QVDs
• C. Build an On-Demand Application Generation template app and a selection app, and allow vendors to access anonymously
• D. Build an On-Demand Application Generation template app and a selection app, and require vendors to log into Qlik Sense to view the app.

A data architect must br*ak down a 13-character ShipmentID code in the following format, #-###-##-##-#.
Separate fields must be created from the numeric values separated by the hyphen (-). The data architect must extract five sub-fields (ShipmentLoc, Quantity. CategorylD. StoreLoc. and Division) from the 13-character code How should the data architect meet this requirement?

• A. In the data manager, use the data profiling card to replace the'-' characters in the ShipmentID
• B. In the data load editor, load the ShipmentID field and apply the KeepCharQ and Trim() functions
• C. In the data manager, use the data profiling card to split the ShipmentID by the'-' character
• D. In the data load editor, load the ShipmentID field and apply the PurgeChar(ShipmentlD,'-') function

A customer must create a production app that pulls data from two sources Source 1 is a large legacy system It takes more than one hour to read and save the data to a QVD Reading from the QVD only takes 20 seconds The data only needs to be refreshed every month because it does not change very often Source 2 is a small online data source Reloading this data takes less than one minute The production app must be refreshed every hour to see the most updated data and needs both data sets to meet the analysis requirements How should the data architect set up the data reload?

• A. 1 Create two QVD generation apps
  2- Create two scheduled tasks one runs every month and one runs every hour
  3. Load the data in the production app from the QVDs
  4. Create a task to run every hour to reload the production app
• B. 1. Create a QVD generation app to pull both data sources in different script sections
  2. Create two reload schedules from the QVD app based on the script section
  3. Build the production app using the QVD files
  4. Create a task to run every hour to reload the production app
• C. 1 Create the productioff app to connect to both data sources
  2. Create a variable and set this to the last reload time using ReloadTimeQ function
  3. Use an IF() statement and only load the legacy data when TodayO > 30 days from last reload 4 Create a task to run every hour to reload the production app
• D. 1. Create a QVD generation app for the legacy system only
  2. Create a scheduled task to generate the QVD every month
  3 Build the production app using the QVD and use ADD LOAD prefix to connect to the online data source
  4. Create a task to run every hour to perform a partial reload on the production app