Ensurepass

QUESTION 11

Refer to the exhibit to the right. What is the primary key of ACCOUNT_TRANS?

 

clip_image002

 

A.

ACCOUNT_ID

B.

TRANS_SEQ

C.

ACCOUNT_ID and TRANS_SEQ

D.

ACCOUNT_ID, TRANS_SEQ, and TRANS_TYPE

 

Correct Answer: C

 

 

QUESTION 12

A client has a data set with two tables.

 

The Customer table has fields CustomerID, AssignedTo, FirstName, and LastName. The Orders table has fields CustomerID, AssignedTo, Product, and Quantity.

 

The AssignedTo field holds an employee reference.

 

Users need to see Customers and Orders by employee.

 

The employee assigned to the Customer may not be the same as the employee assigned to the Order.

 

Which technique should be used in the script to meet the requirement?

 

A.

load the tables leaving the automatic associations

B.

comment out the AssignedTo from the Orders table

C.

comment out the AssignedTo from the Customer table

D.

use Rename Field syntax to alias one of the AssignedTo fields

E.

create a concatenated key of CustomerID and AssignedTo in both tables

Correct Answer: D

 

 

QUESTION 13

Refer to the exhibit.

 

clip_image003

 

A customer needs to analyze transactions across the Dimensions and Metrics identified below.

 

Required Dimensions:

 

clip_image005Project ID

clip_image005[1]Month

clip_image005[2]Year

clip_image005[3]Account ID

clip_image005[4]Transaction Type

clip_image005[5]Client ID

 

Required Metrics:

 

clip_image005[6]Number of transactions

clip_image005[7]Total Amount

clip_image005[8]Total Cost

clip_image005[9]Average Amount

clip_image005[10]Average Cost

 

Which approach will provide the most effective QlikView data model to meet the customer’s requirements while optimizing performance and maintaining accuracy?

 

A.

build a Link Table to connect the four transaction tables and add a summary table with pre-calculated counts, totals, and averages

B.

build a Link Table to connect the four transaction tables and alias fields that must be kept in their respective table

C.

concatenate the four transaction tables and add a summary table with pre-calculated counts, totals, and averages

D.

concatenate the four transaction tables and add fields to identify the record type and count flag

E.

keep the four transaction tables separate and qualify the names to control correct linkage

 

Correct Answer: D

 

 

QUESTION 14

Which action should a developer perform on a table to reduce required memory and optimize the application?

 

A.

convert numeric fields into text fields using the Text function

B.

combine multiple fields into one complex field, reducing the number of fields per table

C.

make all numeric fields a fixed length by left padding with leading 0’s using the Num function

D.

split out a single complex field into multiple fields reducing the number of distinct values per field

 

Correct Answer: D

 

 

QUESTION 15

Refer to the exhibit below.

 

clip_image007

 

Schema A displayed in the exhibit has been transformed into Schema B.

 

How can the before and after schemas be described?

 

A.

The snowflake schema has been transformed into a de-normalized schema.

B.

The snowflake 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.

 

Correct Answer: A

 

 

QUESTION 16

Which statement describes a required field characteristics that will ensure QlikView associations across multiple tables?

 

A.

The field formats (such as numeric or string) must be the same in the original data sources.

B.

The fields must be defined as primary or foreign keys in the original data sources.

C.

The fields must be aliased to the same name when loading into QlikView.

D.

The number of distinct values in each field must be the same.

 

Correct Answer: C

 

 

QUESTION 17

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

 

clip_image009

 

A.

multiple spellings of the same City

B.

the City value London is associated with two different Country values

C.

the Country values and SalesOrderID values do not relate properly

D.

the SalesAmount field name does not contain a space

E.

inconsistent Country abbreviations

F.

duplicate key values

 

Correct Answer: AE

 

 

QUESTION 18

Refer to the exhibit to the right. What is the cardinality of the relationship between CUSTOMER and ACCOUNT?

 

clip_image011

 

A.

many-to-many

B.

one-to-many

C.

one-to-none

D.

one-to-one

 

Correct Answer: A

 

 

QUESTION 19

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

D.

load the Excel data, then load the Address Book data using an If function to default Country Code to US, and then use the Peek function to retrieve the Country description

 

Correct Answer: C

 

 

 

 

QUESTION 20

Refer to the exhibit to the right. A customer has aggregated budgets for products by year and month. Actual data is stored at a more detailed transaction level and so a one-to-many relationship exists between the Budgets to Actuals table. Budgets have been assigned for all months of the current year, but there are only transactions up to the current month of October. There are transactions for products that were not assigned budgets. How can a developer remove the synthetic key automatically generated by QlikView and be able to analyze budgets and actuals by product, month, and year?

 

clip_image013

 

A.

load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table

B.

load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth

C.

load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table

D.

create a concatenated key of Product-Year-Month in both the Budgets and Actuals table and comment out the individual fields in the Budgets table

 

Correct Answer: C

 

Free VCE & PDF File for QlikView QV-Developer-01 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

Comments are closed.