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 data architect plans to build an app that contains geographically diverse data that must be specific to user run-time selections. The source contains transactional dat
a. The app must have minimal impact on already limited server resources.
Which approach should the data architect use?
Using QVDs is the best approach for this scenario, as it allows the data to be stored in a highly compressed format, which will have minimal impact on server resources. Additionally, QVDs can be loaded quickly, which allows for faster access to the data based on user run-time selections. The other options, Loop and Reduce, In-memory, and ODAG, are not valid strategies for this scenario.
Refer to the exhibit
A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe
The script runs successfully, but the Stores table does not have any values.
What should the data architect do?
A data architect needs to revise an existing app.
The number of data rows has grown rapidly recently. While the app is in production, users are becoming increasingly unhappy about the response times when they make selections
Which two methods should be used to improve performance? (Select two.)
Refer to the exhibit.
The data architect needs to build a model that contains Sales and Budget data for each customer. Some customers have Sales without a Budget, and other customers have a Budget with no Sales
During loading, the data architect resolves a synthetic key by creating the composite key
For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.
What does the data architect see when selecting a month?
