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. Option A

B. Option B

C. Option C

D. Option D

Refer to the exhibit.

A. The UserAccess table contains seven fields Year Month, Hourr AccesslD. AccessDate. UserlD, and Duration (minutes) The table is only linked to Users on the UserlD field

B. The UserAccess Table contains seven fields: Year, Month. Hour. AccessID, AccessDate. UserlD, and Duration (minutes) The table is linked to the Access table with the AccessID field and linked to Users on the UserlD field

C. The UserAccess table contains seven fields AccessYear, AccessMonth, Hour AccesslD, AccessDate, UserlD, and Duration (minutes) The table is only linked to Users on the UserlD field

D. The UserAccess table contains seven fields AccessYear. AccessMonth. Hour. AccesslD, AccessDate. UserlD. and Duration (minutes) The table is linked to the Access table on the AccesslD field and linked to Users on the UserlD field

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?

A. FilePath, IF, THEN, Drop

B. FileSize, IF, THEN, END IF

C. FilePath, FOR EACH, Peek, Drop

D. FileExists, FOR EACH, IF

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?

A. In the data manager split the Region table and associate by EmployeelD

B. In the data manager split the Region table and associate by Region.ID

C. In the data load editor, concatenate the Region and Employee tables

D. In the data manager, concatenate the Region table and associate by Region.ID

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. IntervalMatch and use variables

B. Nested IFs in a calculated dimension

C. Class function in a calculated dimension

D. Class function in the script and use variables

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({$=2"}, Artist={"=Grade>2"}>}Instrument)

B. Count({S=2"}, Grades={">2"}>}Instrument)

C. Count({$=2"}, Artist={"=Grade>2"}>}Instrument)

D. Count ({S=2M}, Grades={">2"}>}Instrument)

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. 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.

B. 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.

C. 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.

D. 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.

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.)

A. OQIikGeoAnalytics

B. ODAG

C. QIikDataMarket

D. Qlik Storytelling

E. QIik NPrinting

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?

A. Update the Students table and add 16.7% of the missing records

B. Remove records from the Exams table where StudentID is null

C. Update the Exams table and add 33.4% of the missing records

D. In the LOAD script, add DISTINCT before the Students and Exams tables

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?

A. Loop and Reduce

B. QVDs

C. In-memory

D. ODAG