Refer to the exhibit.
The data model shown has a synthetic key for information that contains actual sales and budget sales for a multi-national company As a business requirement, users must be able to drill down by department and country. Datajnust not be lost.
Due to data quality issues, some departments are NOT included in the Sales and Budget tables.
The data architect needs a method to eliminate synthetic keys that generates the fastest performing data model Which method should the data architect use?
A. A forced concatenation statement
B. A Left Join statement in the script
C. A link table to associate the two tables
D. Field aliases or comment out redundant fields
正解:C
質問 2:
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 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
B. 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
C. 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
D. 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
質問 3:
Refer to the exhibit.
The Country field in a CRM app is a free-form text field. More spelling variations and countries are expected in the future. A data architect must create a field called CountryCode based on the value in the Country field Which script should the data architect create to perform this task?
A)
B)
C)
D)
A. Option C
B. Option A
C. Option D
D. Option B
正解:D
質問 4:
Refer to the exhibit.
The two tables have been loaded by the script shown This script creates a synthetic key, which is not desired.
The Dept code in the Employee table is incorrect for EmplD=3
The data architect must change line 27 to create a single table in the data model that is accurate Which LOAD statement should the data architect use?
A. CONCATENATE LOAD EmpID, ManagerlD, Level
B. KEEP LOAD EmpID, ManagerlD, Level
C. JOIN LOAD *
D. JOIN LOAD EmpID, ManagerlD, Level
正解:D
質問 5:
Refer to the exhibits
A company notices that product sales have decreased. A data architect needs to create an app to show the correlation between the decreased revenue and the latest customer survey results.
Which Qlik Sense feature should the data architect use to meet this requirement?
A. Master item library
B. On-Demand App Generation
C. Associative data model
D. Section access
正解:A