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
Refer to the exhibit below.
Schema A displayed in the exhibit has been transformed into schema B. How can the before and after schemas be described?
A. The snowfake schema has been transformed into a de-normalized schema.
B. The snowfake schema has been transformed into a normalized schema.
C. The star schema has been transformed into a de-normalized schema.
D. The star schema has been transformed into a normalized schema.
A customer needs to analyze Products by Product Grouping. The relationship between Product and
Product Group is undefined in the original data source.
How can the Product Grouping be defined within the QlikView script?
A. by using lnput Box to enter the lookup table
B. by using AutoGenerate to load the lookup table
C. by generating a lookup table using the lnline wizard
D. by loading the lookup table using an lnclude statement
Refer to the exhibit to the right.
Which technique should be used by a developer to eliminate the circular reference in the data model displayed in the exhibit?
A. qualify all the fields in the data model ending with 'lD'
B. qualify the fields Name, Address, City, and Country in the shippers and suppliers tables
C. rename the fields shipperlD in the shippers table and supplierlD in the suppliers table
D. rename the fields OrderlD in the OrderDetails table and supplierlD in the Products table
A customer created 20 expressions that will be used repetitively throughout a QlikView application. These expressions could appear in more than 50 objects located on 15 tabs.
How can a developer efficiently apply and maintain these expressions?
A. create the required expression in each object as needed and edit them in the Expression Overview
B. load the text for each expression from a text file into a table in the data model and link it to the fact table
C. create a table of indices and expression text and use the index value in place of the expression text in each object
D. create a variable for each expression that contains the expression text and use the variable in place of the expression in each object
Refer to the exhibit to the right.
What can a developer determine from the exhibit about the values in the Fax field?
A. The Fax field has NULL values for 24 percent of the records.
B. The Fax field has blanks for 24 percent of the records.
C. The Fax field has 76 percent incomplete invalid fax numbers.
D. On average, 76 percent of the Fax field values are non-spaces.
E. The longest Fax value is 76 percent of the assigned field length.
A project to develop a QlikView application for a customer requires splitting developers into two teams.
One team will focus on developing source database query knowledge to create a reusable data layer.
There are several application-specific business rules for this project. The customer needs to incrementally
accumulate history for the QlikView application over time.
The second team will focus on developing the presentation layer. This team also has data modeling and
scripting expertise, but does not have source database query knowledge.
Which data loading strategy should the developers use on the project?
A. create a series of QVWs that apply the business rules and then binary load them into the presentation layer QVW
B. create the presentation layer QVW and connect directly to the source data and apply the business rules in the script
C. create QVDs of the source data and load them into the presentation layer QVW and apply the business rules in the script
D. create QVDs of the source data, apply the business rules and store a second layer of QVDs, and then load these QVDs into the presentation layer QVW
A customer needs a better understanding of inventory trends over time. However, the source database
contains only the current product inventory levels.
Which technique will take advantage of QlikView capabilities to meet the customer's needs?
A. using a QlikView script to store an accumulation of periodic snapshots to a table in the source database
B. using a QVD file to store an accumulation of periodic snapshots from the source database
C. using a QVX file to store an accumulation of periodic snapshots from the source database
D. using a QlikView script to store an accumulation of periodic snapshots to an XML file
Refer to the exhibit to the right.
A customer has two databases containing employee data for different regions. Based on the script displayed in the exhibit, what will be the resulting table schema?
A. one table named Employees_US
B. one table named Employees_UK
C. two tables named Employees_US and Employees_UK with no associations
D. two tables named Employees_US and Employees_UK with a synthetic key
An Address Book table has a Country Code field. A standard lookup table exists in Excel to translate the
Country Code to a Country description.
The Country Code will be US for any Address Book record with no Country Code value.
Which technique should a developer use to ensure a Country description is loaded for all Address Book
records?
A. load the Address Book records and perform a Left Join of the Excel data to the Address Book table
B. load the Excel data and then load the Address Book data ensuring the Country Code field has the same name in both tables
C. load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Booktable
D. load the Excel data, then load the Address Book data using an lf function to default Country Code to US, and then use the Peek function to retrieve the Country description
A customer has data tables for financial results, staffing, sanitary conditions, and customer satisfaction.
Each table contains a date field and a location lD. Not all dates appear in all tables.
How can a developer create a master calendar that can be used with all the tables?
A. Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field Left join the location lD from each table into the calendar table on the date fields Drop the location and date fields from all other tables
B. Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Rename all other date fields to match the reference field Left join the location lD from each table into the calendar table on the date fields Drop the location and date fields from all other tables
C. Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field Create a link table with a key of Location and date that contains all unique locations and dates Create a key of location and date in the other tables
D. Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Create a link table with a key of location and date that contains all unique locations and dates Create a key of location and date in the other tables Drop the location and date fields from all other tables
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 needs an application to reload in a short time period. The source tables are log files that are
appended to on a daily basis.
Which performance tuning option should a developer use?
A. the QVD files to store the source tables
B. the Partial Reload command with the append option
C. the Load prefix Buffer with the incremental option
D. the Load prefix Buffer and set the Keep Outdated QVD Buffers in the Document Properties
A developer needs to modify the data model of a document that consumes 5GB of RAM when opened in
memory.
Which type of client should the developer use?
A. lnternet Explorer Plug-in client on a 64 bit Windows 7 operating system
B. QlikView local client on a 32 bit Windows 7 operating system
C. QlikView local client on a 64 bit Mac operating system
D. QlikView local client on a 64 bit Windows 7 operating system
Refer to the exhibit to the right.
Which two data quality issues exist within the data set displayed in the exhibit? (Choose two.)
A. multiple spellings of the same City
B. the City value London is associated with two different Country values
C. the Country values and salesOrderlD values do not relate properly
D. the salesAmount field name does not contain a space
E. inconsistent Country abbreviations F. duplicate key values