Free QV-Developer-01 – QlikView 11 Developer Certification Examination (qv_developer_01) Practice Test Question

Select all that apply, then click Submit answer.

• ○

  multiple spellings of the same City

• ○

  the City value London is associated with two different Country values

• ○

  the Country values and SalesOrderID values do not relate properly

• ○

  the SalesAmount field name does not contain a space

• ○

  inconsistent Country abbreviations

• ○

  duplicate key values
  
  

Select all that apply, then click Submit answer.

• ○

  the Transaction ID field name contains a space

• ○

  one or more Product field values contain spaces

• ○

  the Date field values contain special characters

• ○

  one or more header rows are included in the file data

• ○

  one or more Product field values contain the file delimiter

• ○

  the Date field name is also a function name and is a reserved word
  
  

Select all that apply, then click Submit answer.

• ○

  convert the QVW application into a .mob document on the server

• ○

  ensure that screen resolution is appropriate for the device

• ○

  convert the QVW application into a HTML5 document

• ○

  create a specific QVW application for each device

• ○

  use only sheet objects suitable for tablet devices
  
  

Select all that apply, then click Submit answer.

• ○

  Calculation Condition of the object

• ○

  Number of major/minor units for the scale

• ○

  Show Condition of the object

• ○

  X and Y position of the object

• ○

  Auto Minimize of the object
  
  

Select an option, then click Submit answer.

• ○

  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

• ○

  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

• ○

  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

• ○

  from the script editor, on the Data tab, under Database choose 'ODBC' from the Database pull down and then click the 'Connect' button
  
  

Select an option, then click Submit answer.

• ○

  the Help Text property on the Caption tab to enter instructions directing the user to make a selection and filter their data before performing their analysis

• ○

  the Auto Minimize property on the Caption tab so that the chart will be minimized and not calculate or render until the user has first made a selection and restored the chart

• ○

  the Calculate Condition property on the General tab to create a control condition that will keep the chart from calculating until user has filtered the data

• ○

  the Size to Data property on the Layout tab to automatically size the filter criteria to the chart
  
  

Select an option, then click Submit answer.

• ○

  using a QlikView script to store an accumulation of periodic snapshots to a table in the source database

• ○

  using a QVD file to store an accumulation of periodic snapshots from the source database

• ○

  using a QVX file to store an accumulation of periodic snapshots from the source database

• ○

  using a QlikView script to store an accumulation of periodic snapshots to an XML file
  
  

Select an option, then click Submit answer.

• ○

  qualify both tables and Unqualify all shared fields

• ○

  left join the Budgeted Sales table onto the fact table using Month as the key

• ○

  concatenate Load the Budgeted Sales table into the Actual Sales table loading shared fields as NULL

• ○

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

Select an option, then click Submit answer.

• ○

  the QVD files to store the source tables

• ○

  the Partial Reload command with the append option

• ○

  the Load prefix Buffer with the incremental option

• ○

  the Load prefix Buffer and set the Keep Outdated QVD Buffers in the Document Properties