QlikView QV_DEVELOPER_01 Online Practice Questions and Exam Preparation

QlikView QV_DEVELOPER_01 Online Questions & Answers

• Question 21:

  A customer has an Actual sales fact table aggregated at the transactional level and a Budgeted sales fact table aggregated at the monthly level. The tables share many of the same dimensional fields.

  

  How can a developer form the data model?

  A. qualify both tables and Unqualify all shared fields
  B. left join the Budgeted sales table onto the fact table using Month as the key
  C. concatenate Load the Budgeted sales table into the Actual sales table loading shared fields as NULL
  D. create a link table containing the dimensional fields then link each fact table using a concatenated key
  D. create a link table containing the dimensional fields then link each fact table using a concatenated key

• Question 22:

  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 View menu > Reselect Window > 1280 x 800
  B. Go to View menu > Fit Zoom to Window > 1280 x 800
  C. Go to settings menu > User Preferences > Design Tab and select 1280 x 800
  D. Go to settings menu > User Preferences > Design Tab and select Display Grid Lines
  A. Go to View menu > Reselect Window > 1280 x 800

• Question 23:

  A customer has sales data containing a fact table, sales and dimension tables, Customer, ltem, and Vendor. After loading the data, the Entity Relationship Diagram (ERD) has a synthetic table containing the fields Name and Address from the

  Vendor and Customer tables.

  How can a developer eliminate the synthetic keys and appropriately link the data?

  A. qualify all tables
  B. alias all primary key fields
  C. left join the Customer data onto the sales table
  D. qualify all tables and then unqualify all key fields
  D. qualify all tables and then unqualify all key fields

• Question 24:

  What is the interpretation of a 98 percent subset ratio in the CustomerlD field in an Orders table when the subset ratio of the same field in the Customer table is 100 percent?

  A. 98 percent of the orders have customers in the data, but only 2 percent of the orders have been shipped
  B. 2 percent of the orders have customers in the data, but 100 percent of the customers have placed an order
  C. 100 percent of customers are defined in the Customer table, but 2 percent of the customers have not placed an order
  D. 98 percent of the customers are defined in the Customer table, but 2 percent of the customers have not placed an order
  C. 100 percent of customers are defined in the Customer table, but 2 percent of the customers have not placed an order

• Question 25:

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

• Question 26:

  Which technique should a developer use to clearly describe dimensions and measures for end users who need to use collaborative objects?

  A. add field metadata tags to fields in the load script
  B. put a How To sheet in the application
  C. put descriptive information in each object's help text
  D. add a system table to the application
  A. add field metadata tags to fields in the load script

• Question 27:

  Refer to the exhibit to the right.

  

  A customer needs the data displayed in the exhibit loaded into QlikView for analysis. The data is stored in a fat file and new rows are appended daily. Which two data quality issues will a developer have to resolve? (Choose two.)

  A. the Transaction lD field name contains a space
  B. one or more Product field values contain spaces
  C. the Date field values contain special characters
  D. one or more header rows are included in the file data
  E. one or more Product field values contain the file delimiter
  F. the Date field name is also a function name and is a reserved word
  D. one or more header rows are included in the file data
  E. one or more Product field values contain the file delimiter

• Question 28:

  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
  C. load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Booktable

• Question 29:

  A customer needs to produce formatted output as a PDF to distribute it to non-QlikView users. Each page should show sales trending for a different sales team. The number of sales teams will change frequently. What should a developer create to efficiently enable users to create the required output?

  A. a report with banding on salesTeam
  B. a report with GROUP BY on salesTeam
  C. separate reports with where clauses for each salesTeam
  D. separate reports referencing bookmarks for each salesTeam
  E. a report that uses current selections where the user selects each salesTeam in turn
  A. a report with banding on salesTeam

• Question 30:

  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 a relationship between all the tables without synthetic key tables or loosely coupled tables.
  B. There will be a relationship between four of the five tables and one table will be a data island.
  C. There will be a synthetic key table in the data model.
  D. There will be loosely coupled tables in the data model.
  D. There will be loosely coupled tables in the data model.