767 お客様のコメント
質問 1：
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 data.
The app must have minimal impact on already limited server resources.
Which approach should the data architect use?
A. ODAG
B. QVDs
C. In-memory
D. Loop and Reduce
正解：D
質問 2：
Refer to the exhibit.
A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?
A. Create a composite key using OrderlD and LineNo
B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
C. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments
D. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field
正解：A
質問 3：
Refer to the exhibit.
A. * The UserAccess table contains seven fields AccessYear. AccessMonth. Hour. AccesslD, AccessDate. UserlD. and Duration (minutes)
* The table is linked to the Access table on the AccesslD field and linked to Users on the UserlD field
B. * The UserAccess table contains seven fields Year Month, Hourr AccesslD. AccessDate. UserlD, and Duration (minutes)
* The table is only linked to Users on the UserlD field
C. * The UserAccess Table contains seven fields: Year, Month. Hour. AccessID, AccessDate. UserlD, and Duration (minutes)
* The table is linked to the Access table with the AccessID field and linked to Users on the UserlD field
D. * The UserAccess table contains seven fields AccessYear, AccessMonth, Hour AccesslD, AccessDate, UserlD, and Duration (minutes)
* The table is only linked to Users on the UserlD field
正解：A
質問 4：
A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze dat a. Some fields must NOT appear in any field list.
How should a data architect meet these requirements?
A. Use security rules
B. Add fields to master items
C. Use HideField variable
D. Use HidePrefix variable
正解：D
質問 5：
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 dateWhich 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
正解：C
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 data.
The app must have minimal impact on already limited server resources.
Which approach should the data architect use?
A. ODAG
B. QVDs
C. In-memory
D. Loop and Reduce
正解：D
質問 2：
Refer to the exhibit.
A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?
A. Create a composite key using OrderlD and LineNo
B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
C. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments
D. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field
正解：A
質問 3：
Refer to the exhibit.
A. * The UserAccess table contains seven fields AccessYear. AccessMonth. Hour. AccesslD, AccessDate. UserlD. and Duration (minutes)
* The table is linked to the Access table on the AccesslD field and linked to Users on the UserlD field
B. * The UserAccess table contains seven fields Year Month, Hourr AccesslD. AccessDate. UserlD, and Duration (minutes)
* The table is only linked to Users on the UserlD field
C. * The UserAccess Table contains seven fields: Year, Month. Hour. AccessID, AccessDate. UserlD, and Duration (minutes)
* The table is linked to the Access table with the AccessID field and linked to Users on the UserlD field
D. * The UserAccess table contains seven fields AccessYear, AccessMonth, Hour AccesslD, AccessDate, UserlD, and Duration (minutes)
* The table is only linked to Users on the UserlD field
正解：A
質問 4：
A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze dat a. Some fields must NOT appear in any field list.
How should a data architect meet these requirements?
A. Use security rules
B. Add fields to master items
C. Use HideField variable
D. Use HidePrefix variable
正解：D
質問 5：
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 dateWhich 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
正解：C
七生** -
この1冊に詰まっています。QSDA2019合格に必要な力を手に入れました。ゼロから丁寧に解説されていて解りやすい。