http://https://www.newpassleader.com/QlikView/QV_Developer_01-exam-preparation-materials.html (70 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 7
A customer has a Sales data table and needs a chart to display sales figures by date, including dates without sales.
The Sales table is sorted by the primary key which is generated based on the type of order and the SalesPersonID who generated it.
Which technique should a developer use to achieve this requirement?
A. the today() function, to determine the required date range and use an Inline load to generate the master calendar
B. calculated dimensions in Chart Objects and expressions in List Boxes, to generate the required dates
C. Peek, when loading the Sales data, to create records within the Sales data table for dates with no sales
D. a Resident Load and Peek, to determine the minimum and maximum dates and then AutoGenerate to create a master calendar
Answer: D

NEW QUESTION NO: 8
How does QlikView link a fact table and dimension table in the associative data model?
A. identically to all table linkages created in a relational database
B. by manually setting the field property Keyfield on one field in both the fact table and the dimension table
C. on an identically named field in both the fact table and the dimension table
D. on a field called "<tablename>.id" created by the developer in every table
Answer: C

NEW QUESTION NO: 9
A client has a data set with two tables.
The Customer table has fields CustomerID, AssignedTo, FirstName, and LastName. The
Orders table has fields CustomerID, AssignedTo, Product, and Quantity.
The AssignedTo field holds an employee reference.
Users need to see Customers and Orders by employee.
The employee assigned to the Customer may not be the same as the employee assigned
to the Order.
Which technique should be used in the script to meet the requirement?
A. comment out the AssignedTo from the Customer table
B. load the tables leaving the automatic associations
C. use Rename Field syntax to alias one of the AssignedTo fields
D. comment out the AssignedTo from the Orders table
E. create a concatenated key of CustomerID and AssignedTo in both tables
Answer: C

NEW QUESTION NO: 10
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 the fields Name, Address, City, and Country in the Shippers and Suppliers tables
B. rename the fields ShipperID in the Shippers table and SupplierID in the Suppliers table
C. rename the fields OrderID in the OrderDetails table and SupplierID in the Products table
D. qualify all the fields in the data model ending with 'ID'
Answer: A

NEW QUESTION NO: 11
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 Settings menu > User Preferences > Design Tab and select Display Grid Lines
B. Go to View menu > Resize Window > 1280 x 800
C. Go to Settings menu > User Preferences > Design Tab and select 1280 x 800
D. Go to View menu > Fit Zoom to Window > 1280 x 800
Answer: B

NEW QUESTION NO: 12
Which action should a developer perform on a table to reduce required memory and optimize the application?
A. convert numeric fields into text fields using the Text function
B. combine multiple fields into one complex field, reducing the number of fields per table
C. make all numeric fields a fixed length by left padding with leading 0's using the Num function
D. split out a single complex field into multiple fields reducing the number of distinct values per field
Answer: D

NEW QUESTION NO: 13
Refer to the exhibit below.

The tables displayed in the exhibit need to be loaded into QlikView.
How will the data model appear once the load is complete?
A. There will be loosely coupled tables in the data model.
B. There will be a synthetic key table in the data model.
C. There will be a relationship between four of the five tables and one table will be a data island.
D. There will be a relationship between all the tables without synthetic key tables or loosely coupled tables.
Answer: A

NEW QUESTION NO: 14
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 DepartmentID field in the SalesPerson table to match the qualified field name of DepartmentID in the Department table
B. change the script to use an Inner Join instead of Left Join
C. change the Left Join command to include the name of the table being joined enclosed in parentheses
D. change the QUALIFY * command to list out only the fields that need to be qualified
Answer: D

NEW QUESTION NO: 15
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 a variable for each expression that contains the expression text and use the variable in place of the expression in each object
B. create the required expression in each object as needed and edit them in the Expression Overview
C. load the text for each expression from a text file into a table in the data model and link it to the fact table
D. create a table of indices and expression text and use the index value in place of the expression text in each object
Answer: A

NEW QUESTION NO: 16
A developer needs to add data from a Microsoft Access database to a data model intended to run on a 64 bit Windows Server.
How should the developer proceed?
A. from the script editor, on the Data tab, click on the 'database conversion' button and convert the database from a 32 bit to 64 bit database
B. from the script editor, on the Data tab, under Database, choose 'ODBC' from the Database pull down, assure the 'Force 32 bit' check box is selected, and then click the 'Connect' button
C. from the script editor, on the Data tab, under Database, choose 'ODBC 32 bit' from the Database pull down and then click the 'Connect' button
D. from the script editor, on the Data tab, under Database choose 'ODBC' from the Database pull down and then click the 'Connect' button
Answer: B

NEW QUESTION NO: 17
A developer needs to load data for products from a database table and a text file. The database table and text file can be joined by the field ProductID.
The database table contains the master list of all available products. The text file contains additional data fields, but not for all products.
The developer loads the data from the database table first.
The developer needs to load the additional data fields from the text file into the existing table. The resulting table needs to contain the master list of all available products.
Which type of join should the developer use when loading the text file?
A. Right Join
B. Inner Join
C. Outer Join
D. Left Join
Answer: D