Refer to the exhibit.
A data architect meeds to resolve a synthetic key and make sure that users can see the unique department name and hospital name for each order Which action should the data architect take?

• A. Remove Departments from the LOAD statement for the Orders table
• B. Remove the Departments table from the LOAD script
• C. Remove HospitallD from the LOAD statement for the Orders table
• D. Remove the Hospitals table from the LOAD script

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. Capture the periodic information in an incremental QVD file for use in an app
• D. Use On-Demand App Generation (ODAG) to create new apps from the selected period

Refer to the exhibit.

A major healthcare organization requests a new app with the following requirements:
* Users can filter AdmissionDate and DischargeDate by all fields in the Master Calendar table
* Use an existing QVD file which includes dates 20 years into the future
* Users should not be able to filter on dates that have no associated encounters Which approach should the data architect take to meet these requirements?

• A. 1. Load the Master Calendar and Encounters tables
  2 Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Admission Date
  3 Perform a Join Load on the Encounters table to the Resident master calendar and alias the date fields appropriately for the Discharge Date
• B. 1 Load the Encounters table
  2. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Admission Date
  3. Perform a Left Join Load on the Encounters table to the master calendar and alias the date fields appropriately for the Discharge Date
• C. 1. Load the master calendar
  2. Create two mapping tables called AdmissionCalendar anADischargeCalendar from the Resident master calendar that has all fields appropriately named
  3 Load the Encounters table and use ApplyMap for the AdmissionDate and DischargeDate appropriately
• D. 1. Load the master calendar as AdmissionCalendar and alias the fields to reflect they are for Admission
  2. Load the master calendar as DischargeCalendar and alias the fields to reflect they are for Discharge
  3. Load the Encounters table

Refer to the exhibit.

A global company recently released an app that uses much more memory than similar apps have used When reviewing data in the data manager, the data architect observes that several fields use Globally Unique Identifiers (GUIDs). There is one key field. Other fields are used for different KPIs to count the number records. The data architect must reduce the memory used as much as possible. Which steps should a data architect take to meet these requirements?

• A. 1 Replace the non-key field GUIDs with RowNoQ to maintain a field that can be used to get a unique count 2. Split the linking GUID fields into five sections using the SubField function to reduce the uniqueness
• B. 1 Use the AutoNumber function to convert the linking GUIDs to numbers
  2 Replace the non-key GUID fields with a flag, and use them to get a unique count for KPIs
• C. 1 Use the AutoNumber function to convert the linking GUIDs to numbers
  2. Use Indexing for non-key GUID fields to create an Index field and use to get a unique count for KPIs
• D. 1. Use the IterNoQ function to convert the linking GUIDs to numbers
  2 Replace the non-linking GUID fields with RowNo() to create an Index field and use to get a unique count for KPI

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