QSDA2024無料問題集「Qlik Sense Data Architect Certification Exam

質問 1

Exhibit.

One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only has values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region.
Which function should the data architect implement to resolve this issue?

（A）Above

（B）Previous

（C）CrossTable

（D）IntervalMatch

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

Refer to the exhibit.

A data architect needs to build a dashboard that displays the aggregated sates for each sales representative. All aggregations on the data must be performed in the script.
Which script should the data architect use to meet these requirements?

（A）

（B）

（C）

（D）

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

Exhibit.

Refer to the exhibit.
A data architect is provided with five tables. One table has Sales Information. The other four tables provide attributes that the end user will group and filter by.
There is only one Sales Person in each Region and only one Region per Customer.
Which data model is the most optimal for use in this situation?

（A）

（B）

（C）

（D）

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

A data architect needs to load large amounts of data from a database that 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 the new and updated data from the database without the rows that have just been loaded from the QVD and 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）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.

（C）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 and concatenate with the new and updated records.
3. Use the PEEK function to remove the deleted rows.

（D）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 and 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 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

A data architect in the Enterprise Architecture team wants to develop a new application summarizing Qlik Sense usage by all company employees. They also want to gather usage metrics for other systems.
Who should the data architect contact to be granted access to the data?

（A）IT Security Vice President, Human Resources Analyst, Qlik Sense Developers

（B）IT Security Director, Human Resources Director, Qlik Sense Administrator

（C）IT Security Manager, Qlik Sense Account Manager, Enterprise Architecture Director

（D）IT Security Analyst, Qlik Sense Developers, Solutions Architect

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

A company's analytics team is migrating from QlikView to Qlik Sense. During the transition there is an opportunity to improve overall reporting.
Which set of criteria must the data architect consider while planning for the migration?

（A）Application size, application theme, storytelling, data model, IT use case

（B）Application metadata, application theme, user sessions, load script, IT use case

（C）User sessions, source data architecture, compatibility, data model, business use case

（D）QlikView archival, source data architecture, load script, data model, business use case

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

QSDA2024 無料問題集「Qlik Sense Data Architect Certification Exam - 2024」

弊社を連絡する

関連リンク

トップ試験