A data architect wants reflect a value of the variable in the script log for tracking purposes.

The variable is defined as:

Which statement should be used to track the variable’s value?

A)

B)

C)

D)

Reveal Solution Hide Solution

A data architect wants reflect a value of the variable in the script log for tracking purposes.

The variable is defined as:

Which statement should be used to track the variable’s value?

A)

B)

C)

D)

Reveal Solution Hide Solution

A data architect wants reflect a value of the variable in the script log for tracking purposes.

The variable is defined as:

Which statement should be used to track the variable’s value?

A)

B)

C)

D)

Reveal Solution Hide Solution

Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

Reveal Solution Hide Solution

Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

Reveal Solution Hide Solution

Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

The data architect has been tasked with building a sales reporting application.

• Part way through the year, the company realigned the sales territories

• Sales reps need to track both their overall performance, and their performance in their current territory

• Regional managers need to track performance for their region based on the date of the sale transaction

• There is a data table from HR that contains the Sales Rep ID, the manager, the region, and the start and end dates for that assignment

• Sales transactions have the salesperson in them, but not the manager or region.

What is the first step the data architect should take to build this data model to accurately reflect performance?

Reveal Solution Hide Solution

A startup company is about have its Initial Public Offering (IPO) on the New York Stock Exchange.

This startup company has used Qlik Sense for many years for data-based decision making for Sales and Marketing efforts, as well as for input into Financial Reporting. The startup’s Qlik Sense applications use variables that have different values at different points in time.

Due to the increased rigor required in record keeping for public companies, these variables must be clearly recorded in the script reload logs of the Qlik Sense applications. These logs are refreshed daily.

The data architect wants to have the variables names, with their current values, written into the script reload logs.

Which script statement should the data architect use?

Reveal Solution Hide Solution

A data architect needs to develop a script to export tables from a model based upon rules from an independent file.

The structure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.

The TableToExport values are already verified to exist in the model.

In addition, the format will always be QVD, and the copies will be incrementally numbered.

For example, the Customers table would be exported as:

What is the minimum set of scripting strategies the data architect must use?

Reveal Solution Hide Solution