QSDA2019試験無料問題集（52題）「Qlik Sense Data Architect Certification 認定」

出題：1

Refer to the exhibit.

What are the values of the variables vLoadStart and vLoadComplete after the script executes?

A. vLoadStart; 'NOW{)'
vLoadComplete: current system date and time when the script ended

B. vLoadStart: system date when the app was opened vLoadComplete 'now()'

C. vLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended

D. vLoadStart: current system date and time when the script started vLoadComplete: 'now()'

正解：B 解答を投票する

出題：2

A data architect needs to load large amounts of data from a database which is continuously updated New records are added, and existing records get updated and deleted. Each record has a LastModified field All existing records are exported into a QVD file. The data architect wants to load the records into Qlik Sense efficiently.
Which steps should the data architect take to meet these requirements?

A. 1. Load the new and updated data from the database
2. Load the existing data from the QVD without the updated rows that have just been loaded from the database. Concatenate with the new and updated records.
3. Load all records from the key field from the database and use an Inner Join on the previous table.

B. 1. Use a partial load to load new and updated data from the database.
2. Load the existing data from the QVD without the updated rows that have just been loaded from the database. Concatenate with the new and updated records.
3. Use the Peek function to remove the deleted rows.

C. 1. Load the existing data from the QVD.
2. Load the new and updated data from the database without the rows that have just been loaded from the QVD. Concatenate with data from the QVD.
3. Load all records from the key field from the database and use an Inner Join on the previous table.

D. 1. Load the existing data from the QVD.
2. Load new and updated data from the database. Concatenate with the table loaded from the QVD.
3. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records.

正解：B 解答を投票する

出題：3

Refer to the exhibits.

A music teacher needs to know which artists are eligible to enter this year's competition.
The teacher needs to find only the artists who have a music grade rank above two and play more than one instrument.
Which expression is needed for the Number of Instruments measure in the table?

A. Count({S<Count(Instrument)={">=2"}, Grades={">2"}>}Instrument)

B. Count({$<Artist={"=Count(Instrument)>=2"}, Artist={"=Grade>2"}>}Instrument)

C. Count({$<Instrument={">=2"}, Artist={"=Grade>2"}>}Instrument)

D. Count ({S<Artist={"=Count(Instrument)>=2M}, Grades={">2"}>}Instrument)

正解：B 解答を投票する

出題：4

A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerlD and CustomerKey. Which scripts should be used to load the data while maintaining the correct associations?
A)

B)

C)

D)

A. Option D

B. Option C

C. Option A

D. Option B

正解：C 解答を投票する

出題：5

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, and remove OrderlD and LineNo from Shipments

B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field

C. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field

D. Create a composite key using OrderlD and LineNo

正解：D 解答を投票する

出題：6

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. Order patient records by patient ID and admission date

B. Calculate the days since previous discharge using admission date and discharge date

C. Sequence patient records by hospital account ID and patient ID using the Peek function

D. Sequence patient records by patient ID using the Peek function

正解：C 解答を投票する

QSDA2019試験無料問題集「Qlik Sense Data Architect Certification 認定」