QlikView QV_DEVELOPER_01 Online Practice Questions and Exam Preparation

QlikView QV_DEVELOPER_01 Online Questions & Answers

• Question 11:

  Refer to the exhibit to the right.

  

  How many rows and fields will TableA have after the script completes?

  A. five rows and three fields
  B. five rows and two fields
  C. four rows and three fields
  D. four rows and two fields
  E. two rows and three fields
  A. five rows and three fields

• Question 12:

  A developer made several changes to a 25-tab load script that normally runs for at least two hours. Which step should the developer take first to efficiently debug the script logic?

  A. place a Go To Exit statement after each block of revised script code, run the script, and comment each successive Go To Exit after a successful run
  B. move each revised tab in succession to the second tab position, place an Exit script statement at the end of the tab script, and run the script
  C. open the QlikView Debugger and use the step button to execute each line of the script
  D. open the QlikView Debugger and use Limited Load to execute the script
  D. open the QlikView Debugger and use Limited Load to execute the script

• Question 13:

  A customer has 30 target values that are used to evaluate the quality of an organization's facilities. At least half the target values are changed monthly by the business users. What is the most efficient way for the developer to store, access, and maintain the target values?

  A. save the target names and values in an external file, load them into a QlikView table, and use a FOR loop to assign the values to variables
  B. manually create a variable for each value in Expression Overview and maintain them in Expression Overview
  C. create a Variables tab in the load script and use 30 LET statements to assign the values to variables
  D. embed the target values into each expression in which they are required
  A. save the target names and values in an external file, load them into a QlikView table, and use a FOR loop to assign the values to variables

• Question 14:

  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
  D. create a variable for each expression that contains the expression text and use the variable in place of the expression in each object

• Question 15:

  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
  A. one table named Employees_US B. one table named Employees_UK

• Question 16:

  Which statement describes a required field characteristics that will ensure QlikView associations across multiple tables?

  A. The field formats (such as numeric or string) must be the same in the original data sources.
  B. The fields must be defined as primary or foreign keys in the original data sources.
  C. The fields must be aliased to the same name when loading into QlikView.
  D. The number of distinct values in each field must be the same.
  C. The fields must be aliased to the same name when loading into QlikView.

• Question 17:

  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
  A. multiple spellings of the same City
  F. duplicate key values

• Question 18:

  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
  D. split out a single complex field into multiple fields reducing the number of distinct values per field

• Question 19:

  A global sales organization needs sales figures in both the local currencies and the corporate standard of $USD. How can a developer achieve this goal and enable users to only consume a single Document CAL?

  A. create a separate QVW containing values in the data model for both the local and $USD currency amounts
  B. create a single QVW and add a table containing currency multipliers while using $USD as a baseline currency
  C. create a separate QVW for each currency ($USD is considered its own currency) and document chain them all together
  D. create a single QVW with duplicate tables for each currency in data islands and associate each data island to each user or group
  B. create a single QVW and add a table containing currency multipliers while using $USD as a baseline currency

• Question 20:

  Refer to the exhibit to the right.

  

  When the script displayed in the exhibit is reloaded, an error message is displayed.

  Table not found

  Left Join (salesPerson)

  LOAD lD

  DepartmentlD

  FROM

  [DatasourceA.xlsx]

  (ooxml, embeddedlabels, tableissalesPersonDepartment);

  What is the likely cause of the error?

  A. When loaded, the salesPerson table is auto concatenated to Customer and does not exist when referenced.
  B. The Left Join statement fails to correctly bracket the referenced table name, such as Left Join ([salesPerson]).
  C. The Left Join statement fails to correctly quote the referenced table name, such as Left Join (IsalesPersonI).
  D. There is an error in the Customer table load and it is not created in memory.
  A. When loaded, the salesPerson table is auto concatenated to Customer and does not exist when referenced.