最新的高品質 QV_Developer_01 考試練習題庫

QlikView QV_Developer_01 考試概覽:

QlikView QV_Developer_01 考試大綱主題:

最新的 QlikView Certification QV_Developer_01 免費考試真題：

問題 #1

Refer to the exhibit.

A customer needs to analyze transactions across the Dimensions and Metrics identified below.
Required Dimensions.
------
Project ID Month Year Account ID Transaction Type Client ID
Required Metrics.
-----
Number of transactions Total Amount Total Cost Average Amount 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. keep the four transaction tables separate and qualify the names to control correct linkage
B. concatenate the four transaction tables and add a summary table with pre-calculated counts, totals, and averages
C. build a Link Table to connect 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. build a Link Table to connect the four transaction tables and alias fields that must be kept in their respective table

問題 #2

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 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
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 Address Book records and perform a Left Join of the Excel data to the Address Book table
D. load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Book table

問題 #3

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?

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, use the Concatenate function to append the Budgets table to the Actuals table
C. load the Actuals table, and when loading the Budgets table, rename fields Year and Month to BudgetYear and BudgetMonth
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

問題 #4

Refer to the exhibit to the right.

What can a developer determine from the exhibit about the values in the Fax field?

A. The Fax field has 76 percent incomplete/invalid fax numbers.
B. On average, 76 percent of the Fax field values are non-spaces.
C. The Fax field has NULL values for 24 percent of the records.
D. The longest Fax value is 76 percent of the assigned field length.
E. The Fax field has blanks for 24 percent of the records.

問題 #5

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. In
B. Exists
C. Previous
D. Match

問題與答案：