QV-Developer-01

QV-Developer-01 practice questions, page 2 of 3, with answer review and explanations.

Question 6

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?

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

Question 7

Refer to the exhibit to the right. Which two data quality issues exist within the data set displayed in the exhibit? (Choose two.)

  1. multiple spellings of the same City
  2. the City value London is associated with two different Country values
  3. the Country values and SalesOrderID values do not relate properly
  4. the SalesAmount field name does not contain a space
  5. inconsistent Country abbreviations
  6. duplicate key values

Question 8

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 flat file and new rows are appended daily. Which two data quality issues will a developer have to resolve? (Choose two.)

  1. the Transaction ID field name contains a space
  2. one or more Product field values contain spaces
  3. the Date field values contain special characters
  4. one or more header rows are included in the file data
  5. one or more Product field values contain the file delimiter
  6. the Date field name is also a function name and is a reserved word

Question 9

Refer to the exhibit to the right and the Load Script provided below. Exhibit. LOAD ItemID, LocationID, Quantity - FROM - [inventory.txt] (txt, codepage is 1252, embedded labels, delimiter is ',', msq); When the developer runs the script, which values will the field Quantity contain?

  1. NULL
  2. 1; 2; 3
  3. 1100; 1300; 2210; 2250; 3125; 3130; 3120
  4. 1,100; 1,300; 2,210; 2,250; 3,125; 3,130; 3,120

Question 10

A customer has a set of date values in different formats. Some dates are in Julian date format; some dates are text strings. How can a developer ensure the data is loaded in a consistent format?

  1. change the default DateFormat variable assignment on the Main script tab
  2. use the Date function to format the field during load
  3. use the Alt function with different Date# functions
  4. use the Lookup function with a format table