Qlik QSDA2022 Exam Practice Test Instant Access

Question 1

Refer to the exhibit.

A data architect has a data model that includes historical order fulfillment centers. The order fulfillment centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per location basis.

Which scripting function should the data architect use to meet this data modeling requirement?

AIntervalMatch

BPeek

CApplyMap

DInner Join

Answer : C

In this scenario, the data architect needs to track the history of order fulfillment centers on a per center, per location basis. This means that the data architect needs to match the historical order fulfillment center data with the current order fulfillment center data, based on the center and location.

The ApplyMap function allows you to create a mapping between the data in one table and the data in another table, based on a common field. The data architect can use ApplyMap to create a mapping between the historical order fulfillment center data and the current order fulfillment center data, based on the center and location fields.

Question 2

Refer to the exhibit.

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

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

BvLoadStart: system date when the app was opened vLoadComplete 'now()'

CvLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended

DvLoadStart: current system date and time when the script started vLoadComplete: 'now()'

Answer : D

vLoadStart variable is assigned the current system date and time when the script starts, and vLoadComplete variable is assigned the current system date and time when the script ends.

Question 3

Refer to the exhibit.

A business department is forecasting revenue within an Excel spreadsheet.

A data architect needs to include this forecast into the existing data model, and without losing any data.

Which two sets of steps will meet these requirements? (Select two.)

A1. Load the Excel spreadsheet using the data load editor
2. Use the Unpivot function
3 Use the Sum function to group the forecast by date
4 Connect to the existing data model

B1. Load the Excel spreadsheet using the data load editor
2 Use the Crosstable function to unpivot the table
3 Create a composite key out of the date and region
4 Connect the new table to the data model

C1 Load the Excel spreadsheet using the data load editor
2. Change the sort order by date
3. Create a composite key out of the forecast and region 4 Connect to the existing data model

D1 Load the Excel spreadsheet into the data manager
2. Use the Unpivot function
3. Create a composite key from the date and region
4. Connect the new table to the data model
1 Load the Excel spreadsheet using the data manager
2 Rename the ForecastDate field to Date 3. Disable the Region
4 Connect to the existing data model

Answer : B, D

Option B involves loading the Excel spreadsheet using the data load editor and then using the Crosstable function to unpivot the table, creating a composite key out of the date and region, and connecting the new table to the existing data model. Option D involves loading the Excel spreadsheet using the data manager, using the Unpivot function, creating a composite key from the date and region, and connecting the new table to the existing data model.

Question 4

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?

ACount({$<Artist={'=Count(Instrument)>=2'}, Artist={'=Grade>2'}>}Instrument)

BCount({S<Count(Instrument)={'>=2'}, Grades={'>2'}>}Instrument)

CCount({$<Instrument={'>=2'}, Artist={'=Grade>2'}>}Instrument)

DCount ({S<Artist={'=Count(Instrument)>=2M}, Grades={'>2'}>}Instrument)

Answer : A

The correct expression to use for the Number of Instruments measure in the table is Option A. This expression will count the number of instruments played by artists with a music grade rank greater than two.

https://www.mckinsey.com/capabilities/mckinsey-digital/our-insights/how-to-build-a-data-architecture-to-drive-innovation-today-and-tomorrow

How to build a data architecture to drive innovation--today and ...

https://www.mckinsey.com/capabilities/mckinsey-digital/our-insights/how-to-build-a-data-architecture-to-drive-innovation-today-and-tomorrow

https://journalofbigdata.springeropen.com/articles/10.1186/s40537-019-0217-0

Big data in healthcare: management, analysis and future prospects ...

https://journalofbigdata.springeropen.com/articles/10.1186/s40537-019-0217-0

https://www.ncbi.nlm.nih.gov/books/NBK551878/

Obtaining Data From Electronic Health Records - Tools and ...

https://www.ncbi.nlm.nih.gov/books/NBK551878/

Question 5

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?

AA circular reference with one table disconnected

BA synthetic table with two synthetic keys

CA synthetic table with three synthetic keys

DA synthetic table and one synthetic key

Answer : A

Question 6

Refer to the exhibits.

An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.

The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.

How should the data architect modify the data model to correct this issue?

ACreate a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

BCreate a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship

CJoin the Departments and Salespeople tables to resolve the many-to-many relationship

DJoin the Transactions and Salespeople tables to resolve the many-to-many relationship

Answer : A

Question 7

A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.

The OrderDate and ShipmentDate are located in different tables.

The user needs to identify the data type and must be able to:

* Show trends for orders and shipments

* Use a single filter for both date fields

* Analyze data over fiscal periods

Which steps should the data architect take to build the data model?

A1. Create a link table with master calendar fields
2. Create a single filter using fields from the master calendar

B1. Load the Shipments and Orders table via the data manager
2. Create a single filter using fields from the Orders table

C1. Create a master calendar and join into the Shipments and Orders table
2. Create a single filter using fields from the Shipments table

D1. Create a master calendar table as a data island
2. Create a single filter using fields from the master calendar

Answer : A

Qlik QSDA2022 Qlik Sense Data Architect Certification Exam - 2022 Exam Practice Test