QV_Developer_01無料問題集「QlikView 11 Developer Certification Examination」

質問 1

A customer needs multi-language support for a QlikView application.
The languages that need to be supported immediately are English, German, and Dutch; in the future, however, additional languages may be needed.
Which solution should a developer use to meet the customer's needs?

（A）a language definition table in the data model containing all descriptions for each language, automatically linking the business user to a language

（B）a separate document for each language

（C）a language definition table in the data model containing all descriptions for each language, and the option to select a specific language in a field

（D）variables for language-specific items and the option to select a specific language in a field

正解：C 解答を投票する

質問 2

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 the Concatenate function to append the Budgets table to the Actuals table

（B）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

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

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

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

Refer to the exhibit to the right.

When a customer reloads the script displayed in the exhibit, it fails to respond and complete, and displays an error message.
OBJECT OUT OF MEMORY.
How should the developer resolve the logic error in the script?

（A）change the Left Join command to include the name of the table being joined enclosed in parentheses

（B）change the DepartmentID field in the SalesPerson table to match the qualified field name of DepartmentID in the Department table

（C）change the QUALIFY * command to list out only the fields that need to be qualified

（D）change the script to use an Inner Join instead of Left Join

正解：C 解答を投票する

質問 4

Which object should a designer use to integrate QlikView with an interactive third-party web service for use in the AJAX Zero Footprint client?

（A）Custom Object

（B）Button Object

（C）QlikView Macro

（D）Extension Object

正解：D 解答を投票する

質問 5

How does QlikView link a fact table and dimension table in the associative data model?

（A）on an identically named field in both the fact table and the dimension table

（B）by manually setting the field property Keyfield on one field in both the fact table and the dimension table

（C）identically to all table linkages created in a relational database

（D）on a field called "<tablename>.id" created by the developer in every table

正解：A 解答を投票する

質問 6

A customer has data tables for financial results, staffing, sanitary conditions, and customer satisfaction. Each table contains a date field and a location ID. Not all dates appear in all tables.
How can a developer create a master calendar that can be used with all the tables?

（A）Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field Create a link table with a key of Location and date that contains all unique locations and dates Create a key of location and date in the other tables

（B）Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field Left join the location ID from each table into the calendar table on the date fields Drop the location and date fields from all other tables

（C）Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Rename all other date fields to match the reference field Left join the location ID from each table into the calendar table on the date fields Drop the location and date fields from all other tables

（D）Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Create a link table with a key of location and date that contains all unique locations and dates
Create a key of location and date in the other tables
Drop the location and date fields from all other tables

正解：D 解答を投票する

質問 7

A developer needs to load data for products from a database table and a text file. The database table and text file can be joined by the field ProductID.
The database table contains the master list of all available products. The text file contains additional data fields, but not for all products.
The developer loads the data from the database table first.
The developer needs to load the additional data fields from the text file into the existing table. The resulting table needs to contain the master list of all available products.
Which type of join should the developer use when loading the text file?

（A）Left Join

（B）Inner Join

（C）Outer Join

（D）Right Join

正解：A 解答を投票する

QV_Developer_01 無料問題集「QlikView 11 Developer Certification Examination」

弊社を連絡する

関連リンク

トップ試験