最新なQlik QSDA2019問題集（52題）、真実試験の問題を全部にカバー！

質問 1：
A human resources (HR) team manager is due to go on leave. The manager needs to assign permissions to colleague to help the HR team publish apps. Which action(s) should the manager assign to the colleague before going on leave?
A. Publish, Read
B. Owner Publish
C. Owner Publish, Read
D. Publish
正解：A

質問 2：
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({$<Artist={"=Count(Instrument)>=2"}, Artist={"=Grade>2"}>}Instrument)
B. Count({$<Instrument={">=2"}, Artist={"=Grade>2"}>}Instrument)
C. Count({S<Count(Instrument)={">=2"}, Grades={">2"}>}Instrument)
D. Count ({S<Artist={"=Count(Instrument)>=2M}, Grades={">2"}>}Instrument)
正解：A

質問 3：
Refer to the exhibit.

A clothing retailer wants to review their product pricing strategy.
A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.
Which feature should the data architect use to meet these requirements?
A. Class function in the script and use variables
B. Class function in a calculated dimension
C. Nested IFs in a calculated dimension
D. IntervalMatch and use variables
正解：B

質問 4：
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 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. 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 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.
D. 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.
正解：B

質問 5：
Refer to the exhibit.

A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A.
(For example, only the row containing A. 1. 456 should be loaded from Table_B ) Which script should the data architect use?
A)

B)

C)

D)

A. Option C
B. Option A
C. Option D
D. Option B
正解：C