QlikView QV_DEVELOPER_01 Online Practice Questions and Exam Preparation

QlikView QV_DEVELOPER_01 Online Questions & Answers

• Question 51:

  A developer needs to add data from a Microsoft Access database to a data model intended to run on a 64 bit Windows server. How should the developer proceed?

  A. 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
  B. 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
  C. 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
  D. from the script editor, on the Data tab, under Database choose 'ODBC' from the Database pull down and then click the 'Connect' button
  A. 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

• Question 52:

  Which QlikView script should a developer add to a Load script to output the resulting number of rows from a joining Load statement to the script Execution Progress window and the script log file?

  A. LET vNumRows = NoOfRows('TableName'); ECHO 'Resulting Rows = $(vNumRows)';
  B. SET vNumRows = NoOfRows('TableName'); ECHO 'Resulting Rows = $(vNumRows)';
  C. LET vNumRows = NoOfRows('TableName'); PRlNT 'Resulting Rows = $(vNumRows)';
  D. SET vNumRows = NoOfRows('TableName'); Response.Write 'Resulting Rows = $(vNumRows)';
  E. LET vNumRows = NoOfRows('TableName'); TRACE 'Resulting Rows = $(vNumRows)';
  E. LET vNumRows = NoOfRows('TableName'); TRACE 'Resulting Rows = $(vNumRows)';

• Question 53:

  Refer to the exhibit below.

  

  A QlikView report does not match the legacy report it was designed to replace. The purpose of the report is to count the number of customers per year and in total. Why is there a difference between the Total row values in the two reports?

  A. The legacy report calculates the total customer occurrences, while the QlikView report counts only distinct customers.
  B. The legacy report calculates the total customer occurrences, while the QlikView report calculates the customer ranking.
  C. The legacy report totals the number of customers correctly, while the QlikView report is dropping records.
  D. The legacy report totals the number of customers correctly, while the QlikView total row is set to sum of rows.
  A. The legacy report calculates the total customer occurrences, while the QlikView report counts only distinct customers.

• Question 54:

  Refer to the exhibit below.

  

  Schema A displayed in the exhibit has been transformed into schema B. How can the before and after schemas be described?

  A. The snowfake schema has been transformed into a de-normalized schema.
  B. The snowfake schema has been transformed into a normalized schema.
  C. The star schema has been transformed into a de-normalized schema.
  D. The star schema has been transformed into a normalized schema.
  A. The snowfake schema has been transformed into a de-normalized schema.

• Question 55:

  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
  C. on an identically named field in both the fact table and the dimension table

• Question 56:

  A customer has an Addresses table with the fields. CustomerNumber, CustomerName, AddressLine1, AddressLine2, City, StateCode, PostalCode, and CountryCode.

  A designer needs to design a chart to show a count of distinct customers in which the customer's CountryCode is US or CA, while ignoring all selections on the Addresses table except the CustomerNumber and CustomerName fields.

  How can the designer calculate the required value?

  A. count({$} distinct CustomerNumber)
  B. count({$} distinct CustomerNumber)
  C. count({1} distinct CustomerNumber)
  D. count({$} distinct CustomerNumber)
  E. count({$} distinct CustomerNumber)
  B. count({$} distinct CustomerNumber)

• Question 57:

  Which objects are the most appropriate for setting one or more values for use in a "what-if" scenario?

  A. lnput Box Object and Chart Object
  B. lnput Box Object and Calendar/slider Object
  C. Button Object and Extension Object
  D. Calendar/slider Object and Chart Object
  E. lnput Box Object and Text Object
  B. lnput Box Object and Calendar/slider Object

• Question 58:

  A customer needs to have QlikView deployed to tablet devices.

  When creating the QVW application, which two actions must a developer take to meet the customer's need? (Choose two.)

  A. convert the QVW application into a .mob document on the server
  B. ensure that screen resolution is appropriate for the device
  C. convert the QVW application into a HTML5 document
  D. create a specific QVW application for each device
  E. use only sheet objects suitable for tablet devices
  B. ensure that screen resolution is appropriate for the device
  E. use only sheet objects suitable for tablet devices

• Question 59:

  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
  C. Exists

• Question 60:

  A developer created two QVWs. The first QVW loads data from the data source and creates QVD files. The second QVW loads the QVD files and provides the user interface for the analytics.

  The customer does not have Publisher installed.

  How should the reloads be configured on the server to ensure the first QVW reload completes before the second QVW reload begins?

  A. Only the first QVW reload can be automated. An alert will need to be sent to prompt an administrator to manually perform the second QVW reload.
  B. Only one QVW reload can occur at a time on the QlikView server. The second QVW reload will always wait until the first QVW reload completes.
  C. The second QVW reload can be scheduled to start upon the successful completion of the first QVW reload.
  D. An action can be placed on the OnPostReload trigger within the first QVW to submit the reload of the second QVW.
  C. The second QVW reload can be scheduled to start upon the successful completion of the first QVW reload.