Refer to the exhibit to the right and the Load script provided below. Exhibit.

LOAD ltemlD

LocationlD,

Quantity

FROM

[inventory.txt]

(txt, codepage is 1252, embedded labels, delimiter is '', msq);

When the developer runs the script, which values will the field Quantity contain?

A. NULL

B. 1; 2; 3

C. 1100; 1300; 2210; 2250; 3125; 3130; 3120

D. 1100; 1300; 2210; 2250; 3125; 3130; 3120

A customer has an Actual sales fact table aggregated at the transactional level and a Budgeted sales fact table aggregated at the monthly level. The tables share many of the same dimensional fields.

How can a developer form the data model?

A. qualify both tables and Unqualify all shared fields

B. left join the Budgeted sales table onto the fact table using Month as the key

C. concatenate Load the Budgeted sales table into the Actual sales table loading shared fields as NULL

D. create a link table containing the dimensional fields then link each fact table using a concatenated key

Refer to the exhibit to the right.

When a customer reloads the script displayed in the exhibit, it fails to respond and complete, and displays

an error message.

OBJECT OUT OF MEMORY.

How should the developer resolve the logic error in the script?

A. change the script to use an lnner Join instead of Left Join

B. change the QUALlFY * command to list out only the fields that need to be qualified

C. change the Left Join command to include the name of the table being joined enclosed in parentheses

D. change the DepartmentlD field in the salesPerson table to match the qualified field name of DepartmentlD in the Department table

A customer specified that the QlikView application should be designed to fit a screen resolution of 1280 x

800 as a standard.

Which option will assist a designer while creating the user interface?

A. Go to View menu > Reselect Window > 1280 x 800

B. Go to View menu > Fit Zoom to Window > 1280 x 800

C. Go to settings menu > User Preferences > Design Tab and select 1280 x 800

D. Go to settings menu > User Preferences > Design Tab and select Display Grid Lines

Which objects are the most appropriate for setting one or more values for use in a "what-if" scenario?

A. lnput Box Object and Chart Object

B. lnput Box Object and Calendar/slider Object

C. Button Object and Extension Object

D. Calendar/slider Object and Chart Object

E. lnput Box Object and Text Object

A customer has multiple bar charts comparing different metrics. All charts contain a single Expression all with the Dimension CustomerlD The charts are sorted by Y-Value Descending. Some Customers have Y-Values of zero for some metrics and not others. How can the designer show the same color bar for a single CustomerlD in all the charts?

A. Properties > Colors and then define colors 1 - 6 with specific RGB values

B. Properties > Colors and then check the Multicolored and Persistent Colors checkboxes

C. Properties > Visual Cues and then set the Upper and Lower colors using specific RGB values

D. Properties > Presentation and then define the Error Bars colors with a specific RGB value

Which technique should a developer use to clearly describe dimensions and measures for end users who need to use collaborative objects?

A. add field metadata tags to fields in the load script

B. put a How To sheet in the application

C. put descriptive information in each object's help text

D. add a system table to the application

When should a developer create a new tab in the Load script?

A. when the critical number of 255 lines per tab has been exceeded

B. when the tab is marked with the ///tab$ statement

C. when portions of script are logically related

D. when entering Edit script for the first time

Which chart should a designer use to display orders, sales, and average order value grouped by year, quarter, region, product, and salesperson?

A. Pivot Table

B. StraightTable

C. Grid Chart

D. Mekko Chart

E. Bar Chart

A customer who operates a large national sales organization needs to divide a sales.qvw document into

region- specificdocumentsusingtheRegionfield(North, South, East, andWest).

Each region should have access to region-specific data.

Which instruction should a developer give to the server/Publisher administrator to meet the customer's

needs?

A. create a QlikView server task to reduce the sales.qvw document based on the Region field and distribute to region- specific folders with appropriate file permissions

B. create a QlikView Publisher task to reduce the sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions

C. create four QlikView server tasks to reload data from the sales.qvw document with data only for each region and distributetoregion-specificfolderswith appropriatefilepermissions

D. create a QlikView Publisher task to reduce data from the sales.qvw document to create four QVX files with data only for each region and distribute to region-specific folders with appropriate file permissions