EMT Practice Test

1. Question Content...

---

Question1: Refer to the exhibit.

An app has been built to analyze salesperson performance by department. Salespeople often move between departments. There is a strict business rule which states 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 KPI showing the total sales shows the correct result.
How should the data architect modify the data model to correct the issue?

Question2: Refer to the exhibit.


Refer to the exhibits.
While using an app, the users report that some Sales Reps do NOT have personal details, like Division or Address Number A data architect has been called in to investigate.
The data architect uses the data model viewer to determine the relationship between the SalesRepMaster and CustomerMaster tables.
What is the cause of the issue?

Question3: Refer to the exhibit.

Question4: A data architect wants to combine data on present and historic sales performance. The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.
Which script should the data architect use?
A)

B)

C)

D)

Question5: A data architect creates a collection of large QVD files that propagate data into their apps This solution works well.
However, a new app that uses a subset of the data in a QVD takes much longer than expected to reload The LOAD statement is

Which two changes should be made to improve load performance? (Select two ) A)

B)

C)

D)

Question6: A customer has a dataset that contains latitude and longitude data for service points around the country. The data is retrieved using the following statement:

It must be clear to the end user that this is geographic dat
a. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data? (Select two.)

Question7: 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?

Question8: Refer to the exhibits.

Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.
How should the data architect resolve the errors?

Question9: A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E:\373948870. The data connection points to this folder.
The data architect plans a script which will:
1. Verify that the file exists
2. If the file exists, upload it. Otherwise, skip to the next piece of code.
The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure. Which option should the data architect use to meet these requirements?

Question10: A company needs to analyze sales data based on the exchange rate of the different countries every day About 30 reports must be produced with an average of 20r000 rows each. This process is estimated to take about three hours.
Reports will be in Excel and distributed to business users according to defined security rules Which two products should the data architect use to build this solution? (Select two.)

Question11: 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?

Question12: Refer to the exhibit.

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

Question13: Refer to the exhibit.

A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam.
The data architect selects the field "StudentID" from the Students table and sees the following:

A data architect needs to fix this anomaly.
What should the data architect do to ensure data integrity?

Question14: A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.
These systems identify employees differently. Employees in the HR system are identified with an alpha-numeric key. Employees in the Sales system are identified using an integer key The Human Resources manager creates a table which maps these keys to one another, called Associations.
The resultant data model must meet the following requirements:
* Associations must be valid
* The model must be optimized for performance
* The option must support multiple tables added from both systems now and in the future Which function should the data architect use to meet these requirements?

Question15: A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects What should the data architect do?

Question16: A data architect needs to efficiently prepare a data model for a meeting in an hour.
The data source to be used contains five date fields. The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD). The app is NOT going to be published. It will only be used for this meeting and a single user's ad-hoc analysis.
What should the data architect do to meet these requirements?

Question17: A data architect needs to load data from two different databases. Additional data will be added from a folder that contains QVDs, text files, and Excel files. What is the minimum number of data connections required?

Question18: Refer to the exhibit.

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error What should be done to make sure the script runs correctly?