Qlik Sense Data Architect Certification - June 2018 Release

Refer to the exhibit.

One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only was 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?

Refer to the exhibit.

A data architect needs to build a dashboard that displays the aggregated sales 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?

Refer to the exhibit.

The business analyst previews some data and notices different values for the United States in the Country field. The analyst must be able to report the total sales for the United States. The data architect must fix this issue in the LOAD script.

Which function should the data architect use to fix data quality issue?

Refer to the exhibit.

The data architect is using section access to meet the security requirements of an app. After the first draft, the data architect discovers that users can NOT see the right subset of data.

Which solution should a data architect use to fix this issue?

A data architect has a QVD file that contains data from many countries. The data architect must write a script that loads only data from France, and make sure the reload occurs as fast as possible.

Which script should the data architect use to meet these requirements?

A data architect uses the Qlik GeoAnalytics connector to determine the closest airports to cities in an existing app. The built location generates data for the airport locations. The data load editor runs the script and sees a circular reference and a synthetic key.

How should the data architect fix these issues?

Refer to the exhibit.

An organization stores sales data in SQL Server. A database administrator creates a view to show the transaction data. The data architect must:

Create a data model that shows the total sales for each salesperson by month Create an indicator that shows whether the total monthly sales meet or exceed the monthly quota, which is always $1,200

Which script should the data architect use to meet these requirements?

Refer to the exhibit.

A system creates log files and csv files daily and places these files in a folder. The log files are named automatically by the source system and charge regularly. All csv files must be loaded into Qlik Sense for analysis.

Which method should be used to meet the requirements?

Refer to the exhibits.

Executives need to see the total sales by region for the current year. The data architect inherits App1 from the former employee who tries to address this requirement. Two Microsoft 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.

Which method should the data architect use to resolve the errors?

An enterprise data warehouse contains 700 million records. This enterprise data warehouse has a three-tiered architecture and uses QVDs.

The Qlik Sense server contains 24 GB RAM and contains two processors with eight cores. The company needs to allow vendors to access a Qlik Sense app anonymously to review past business transactions and current year-to-date performance.

Which method should the data architect use to meet this requirement?