QLIKVIEW-QV-Developer-01 - QlikView 11 Developer Certification

Question - 26 Maximum mark : - 50

Home
All Exams
QLIKVIEW-QV-Developer-01 - QlikView 11 Developer Certification Online Mock Tests
QLIKVIEW-QV-Developer-01 - QlikView 11 Developer Certification

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?

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

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

The field formats (such as numeric or string) must be the same in the original data sources. ✘ The fields must be defined as primary or foreign keys in the original data sources. ✘ The fields must be aliased to the same name when loading into QlikView. ✘ The number of distinct values in each field must be the same. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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

convert numeric fields into text fields using the Text function ✘ combine multiple fields into one complex field, reducing the number of fields per table ✘ make all numeric fields a fixed length by left padding with leading 0's using the Num function ✘ split out a single complex field into multiple fields reducing the number of distinct values per field ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

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

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A customer needs to analyze Products by Product Grouping. The relationship between Product and Product Group is undefined in the original data source. How can the Product Grouping be defined within the QlikView script?

by using Input Box to enter the lookup table ✘ by using AutoGenerate to load the lookup table ✘ by generating a lookup table using the Inline wizard ✘ by loading the lookup table using an Include statement ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A customer has sales data containing a fact table, Sales and dimension tables, Customer, Item, 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?

qualify all tables ✘ alias all primary key fields ✘ left join the Customer data onto the Sales table ✘ qualify all tables and then unqualify all key fields ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

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?

qualify both tables and Unqualify all shared fields ✘ left join the Budgeted Sales table onto the fact table using Month as the key ✘ concatenate Load the Budgeted Sales table into the Actual Sales table loading shared fields as NULL ✘ create a link table containing the dimensional fields then link each fact table using a concatenated key ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A customer has 30 target values that are used to evaluate the quality of an organization's facilities. At least half the target values are changed monthly by the business users. What is the most efficient way for the developer to store, access, and maintain the target values?

save the target names and values in an external file, load them into a QlikView table, and use a FOR loop to assign the values to variables ✘ manually create a variable for each value in Expression Overview and maintain them in Expression Overview ✘ create a Variables tab in the load script and use 30 LET statements to assign the values to variables ✘ embed the target values into each expression in which they are required ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A customer created 20 expressions that will be used repetitively throughout a QlikView application. These expressions could appear in more than 50 objects located on 15 tabs. How can a developer efficiently apply and maintain these expressions?

create the required expression in each object as needed and edit them in the Expression Overview ✘ load the text for each expression from a text file into a table in the data model and link it to the fact table ✘ create a table of indices and expression text and use the index value in place of the expression text in each object ✘ create a variable for each expression that contains the expression text and use the variable in place of the expression in each object ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

A developer made several changes to a 25-tab load script that normally runs for at least two hours. Which step should the developer take first to efficiently debug the script logic?

place a Go To Exit statement after each block of revised script code, run the script, and comment each successive Go To Exit after a successful run ✘ move each revised tab in succession to the second tab position, place an Exit Script statement at the end of the tab script, and run the script ✘ open the QlikView Debugger and use the Step button to execute each line of the script ✘ open the QlikView Debugger and use Limited Load to execute the script ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

QLIKVIEW-QV-Developer-01 - QlikView 11 Developer Certification

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner