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. Calculate the days since previous discharge using admission date and discharge date
B. Sequence patient records by patient ID using the Peek function
C. Sequence patient records by hospital account ID and patient ID using the Peek function
D. Order patient records by patient ID and admission date
正解:D
質問 2:
Refer to the exhibits.
While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data What should the data architect do?
A. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
B. Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character
C. In the SUBFIELDfunction, replace the '- with a '|' or '-' character
D. In the SUBFIELD function, replace the '_' with a '|' or '_' character.
While debugging an app, a developer loads data from an application layer QVD file.
In theprocess of separating a concatenated key into two parts, some split results are missing data What should the data architect do?
E. Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components
F. Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values
G. Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components
H. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
正解:C
質問 3:
Refer to the exhibits.
A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?
A. Utilize INTERVALMATCH to load the currency conversion rate between dates theconversation changed INNER JOIN the resultant table back into the master calendar
B. OUTER JOIN the calendar with the currency conversion table
ORDER BY the date and use the PEEK function to fill in blank values
C. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
D. Leverage a FOR loop between the start date and end date of the master calendar Use the MATCH function to add the currency conversion rates to the master calendar
正解:B
質問 4:
Refer to the exhibit.
An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error What should be done to make sure the script runs correctly?
A. Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data table
B. Make the data architect the owner of the app in the QMC
C. Give the data architect the Read rights on the data connections in the QMC
D. Add the line lib connect to ' SQL (abc_qs9rvi.es) ' ;before the LOAD for the Order Detail table
正解:C
質問 5:
On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue.
What should the data architect do?
A. Create two different mapping tables
B. Use a LEFT JOIN instead of the APPLYMAP
C. Review the values of the source mapping table
D. Use LOAD DISTINCT on the mapping table
正解:C
質問 6:
A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails.
Which statement should the data architect use?
A. $(Must_Include=lib://TextFiles/Variables.txt);
B. (Must_Include=lib://TextFiies/Variables.txt);
C. (Includs=lib://TextFiles/Variables.txt);
D. $<Include=lib://TextFiles/Variables.txt);
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping data. There are three different date fields within the data:
* OrderDate
* InvoiceDate
* ShippingDate
The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.
What should the data architect do?
A. Create a Month field for each of the three dates in the fact table and use that in the chart
B. Left Join the three date fields onto one bridge table using the key field containing KeyField and Date
C. Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
正解:C
質問 8:
Refer to the exhibit.
A data architect needs to add a Budget table to the current Qlik Sense app. A Budget table with the fields Budget, CustomerlD, and ProductlD is loaded into the model. What will be created?
A. A synthetic table and one synthetic key
B. A synthetic table with two synthetic keys
C. A circular reference with one table disconnected
D. A synthetic table with three synthetic keys
正解:C
Kinoshita -
ボリュームをあって内容も充実しています。
丁寧でわかりやすい解説で理解しやすいです。