QlikView QV_DEVELOPER_01 Online Practice Questions and Exam Preparation

QlikView QV_DEVELOPER_01 Online Questions & Answers

• Question 31:

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

• Question 32:

  A customer needs to measure the Amount of sales by Days sales Outstanding (DSO). Days sales Outstanding does not exist in the data model. Which technique should a developer use to meet the customer's need?

  A. on the Dimensions tab, press the Add Calculated Dimension button
  B. on the Expressions tab, add an expression using the Class function
  C. on the Expressions tab, add an expression using the Aggr function
  D. on the Dimensions tab, press the Add Dynamic Dimension button
  A. on the Dimensions tab, press the Add Calculated Dimension button

• Question 33:

  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
  B. Properties > Colors and then check the Multicolored and Persistent Colors checkboxes

• Question 34:

  Which QlikView feature should a developer use to provide information throughout the QVW application about how a field was calculated in the Load script?

  A. Field Tag
  B. Field Comment
  C. Dimension Tag
  D. Variable Comment
  E. Expression Comment
  B. Field Comment

• Question 35:

  Refer to the exhibit to the right.

  

  What is the cardinality of the relationship between CUSTOMER and ACCOUNT?

  A. many-to-many
  B. one-to-many
  C. one-to-none
  D. one-to-one
  A. many-to-many

• Question 36:

  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
  B. change the QUALlFY * command to list out only the fields that need to be qualified

• Question 37:

  A designer needs to create a chart displaying the number of patients currently checked into a hospital by age group. What is the appropriate Dimension for the chart?

  A. number of patients
  B. checked-in status
  C. hospital
  D. age group
  D. age group

• Question 38:

  A customer has a set of date values in different formats.

  Some dates are in Julian date format; Some dates are text strings.

  How can a developer ensure the data is loaded in a consistent format?

  A. change the default DateFormat variable assignment on the Main script tab
  B. use the Date function to format the field during load
  C. use the Alt function with different Date# functions
  D. use the Lookup function with a format table
  C. use the Alt function with different Date# functions

• Question 39:

  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 ProductlD

  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. lnner Join
  B. Left Join
  C. Right Join
  D. Outer Join
  B. Left Join

• Question 40:

  A developer has a Container Object with multiple charts and each chart has many different expressions. The developer needs to provide users with a method to easily obtain information related to each chart and the expressions within. How can the developer fulfill this requirement?

  A. design a help graphic for each chart and set it as the caption background
  B. create a Text Object containing help information for each chart and link each Chart Object to its corresponding Text Object using QlikView's Linked Objects feature
  C. enter a thorough description of each chart and its expressions in the Text in Chart property on the Layout tab
  D. enter a thorough description of each chart and its expressions in the Help Text property on the Caption tab
  D. enter a thorough description of each chart and its expressions in the Help Text property on the Caption tab