QlikView QlikView Certification QV_DEVELOPER_01 Questions & Answers

• Question 31:

  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

  Correct Answer: A

• Question 32:

  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

  Correct Answer: B

• Question 33:

  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

  Correct Answer: D

• Question 34:

  A developer needs to load an Account table and a Contact table from QVDs. The developer needs to load

  only contacts for the accounts that have already been loaded.

  There may be more than one contact for an account, so the developer needs to keep the Account and

  Contact tables separate.

  After loading the Account table, which function should the developer use in the Where clause of the

  Contact table load?

  A. Previous

  B. Match

  C. Exists

  D. ln

  Correct Answer: C

• Question 35:

  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

  Correct Answer: C

• Question 36:

  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

  Correct Answer: A

• Question 37:

  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 salesPersonlD who generated it.

  Which technique should a developer use to achieve this requirement?

  A. a Resident Load and Peek, to determine the minimum and maximum dates and then AutoGenerate to create a master calendar

  B. the today() function, to determine the required date range and use an lnline load to generate the master calendar

  C. Peek, when loading the sales data, to create records within the sales data table for dates with no sales

  D. calculated dimensions in Chart Objects and expressions in List Boxes, to generate the required dates

  Correct Answer: A

• Question 38:

  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

  Correct Answer: C

• Question 39:

  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. on a field called I.idI created by the developer in every table

  C. on an identically named field in both the fact table and the dimension table

  D. by manually setting the field property Keyfield on one field in both the fact table and the dimension table

  Correct Answer: C

• Question 40:

  A customer needs a better understanding of inventory trends over time. However, the source database

  contains only the current product inventory levels.

  Which technique will take advantage of QlikView capabilities to meet the customer's needs?

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

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

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

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

  Correct Answer: B