Choose QV_Developer_01 most accurate study material

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

Which technique should a developer use to clearly describe dimensions and measures for end users who need to use collaborative objects?

• A. put a How To sheet in the application
• B. put descriptive information in each object's help text
• C. add field metadata tags to fields in the load script
• D. add a system table to the application

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?

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

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, rename fields Year and Month to BudgetYear and BudgetMonth
• D. load the Actuals table, and when loading the Budgets table, use Outer Join to join the BudgetAmount field to the Actuals table

A developer needs to modify the data model of a document that consumes 5GB of RAM when opened in memory.
Which type of client should the developer use?

• A. QlikView local client on a 32 bit Windows 7 operating system
• B. QlikView local client on a 64 bit Mac operating system
• C. QlikView local client on a 64 bit Windows 7 operating system
• D. Internet Explorer Plug-in client on a 64 bit Windows 7 operating system