Business And Customer Service Quiz

1. 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?

Exists

In

The developer should use the "Exists" function in the Where clause of the Contact table load. This function checks if a certain condition is true for any record in a specified table. In this case, the developer wants to load only the contacts for the accounts that have already been loaded. By using the "Exists" function, the developer can check if there is a matching account in the Account table for each contact record being loaded, and only load the contacts that have a corresponding account.

Explanation

The developer should use the "Exists" function in the Where clause of the Contact table load. This function checks if a certain condition is true for any record in a specified table. In this case, the developer wants to load only the contacts for the accounts that have already been loaded. By using the "Exists" function, the developer can check if there is a matching account in the Account table for each contact record being loaded, and only load the contacts that have a corresponding account.

2. LOAD ItemID, LocationID, Quantity FROM [inventory.txt] (txt, codepage is 1252, embedded labels, delimiter is ',', msq); When the developer runs the script, which values will the field Quantity contain?

NULL

1; 2; 3

1100; 1300; 2210; 2250; 3125; 3130; 3120

1,100; 1,300; 2,210; 2,250; 3,125; 3,130; 3,120

The field Quantity will contain the values 1, 2, and 3.

Explanation

The field Quantity will contain the values 1, 2, and 3.

3. Which QlikView script should a developer add to a Load script to output the resulting numberof rows from a joining Load statement to the Script Execution Progress window and the script logfile?

LET vNumRows = NoOfRows('TableName'); ECHO 'Resulting Rows = $(vNumRows)';

SET vNumRows = NoOfRows('TableName'); ECHO 'Resulting Rows = $(vNumRows)';

LET vNumRows = NoOfRows('TableName'); PRINT 'Resulting Rows = $(vNumRows)';

SET vNumRows = NoOfRows('TableName'); Response.Write 'Resulting Rows = $(vNumRows)';

LET vNumRows = NoOfRows('TableName'); TRACE 'Resulting Rows = $(vNumRows)';

The correct answer is LET vNumRows = NoOfRows('TableName'); TRACE 'Resulting Rows = $(vNumRows)'. This script will assign the number of rows resulting from the joining Load statement to the variable vNumRows and then use the TRACE statement to output the number of rows to the Script Execution Progress window and the script logfile.

Explanation

The correct answer is LET vNumRows = NoOfRows('TableName'); TRACE 'Resulting Rows = $(vNumRows)'. This script will assign the number of rows resulting from the joining Load statement to the variable vNumRows and then use the TRACE statement to output the number of rows to the Script Execution Progress window and the script logfile.

4. A designer needs to create a chart displaying the number of patients currently checked into a hospital by age group. What is the appropriate Dimension for the chart?

Age group

Number of patients

Checked-in status

Hospital

The appropriate dimension for the chart is "age group" because the designer wants to display the number of patients currently checked into a hospital categorized by their age group. By using "age group" as the dimension, the designer can easily group and compare the number of patients in different age groups, providing a clear visualization of the distribution of patients in the hospital.

Explanation

The appropriate dimension for the chart is "age group" because the designer wants to display the number of patients currently checked into a hospital categorized by their age group. By using "age group" as the dimension, the designer can easily group and compare the number of patients in different age groups, providing a clear visualization of the distribution of patients in the hospital.

5. A customer needs to produce formatted output as a PDF to distribute it to non-QlikView users. Each page should show sales trending for a different sales team. The number of sales teams will change frequently. What should a developer create to efficiently enable users to create the required output?

A report with banding on SalesTeam

A report with GROUP BY on SalesTeam

Separate reports with where clauses for each SalesTeam

Separate reports referencing bookmarks for each SalesTeam

A report that uses current selections where the user selects each SalesTeam in turn

To efficiently enable users to create the required output, a developer should create a report with banding on SalesTeam. This means that the report will have a specific formatting applied to each section or band that represents a different sales team. This allows for easy differentiation and organization of the sales data for each team. By using banding, the report can dynamically adjust to the changing number of sales teams, ensuring that each team's sales trending is displayed on a separate page in the PDF output.

Explanation

To efficiently enable users to create the required output, a developer should create a report with banding on SalesTeam. This means that the report will have a specific formatting applied to each section or band that represents a different sales team. This allows for easy differentiation and organization of the sales data for each team. By using banding, the report can dynamically adjust to the changing number of sales teams, ensuring that each team's sales trending is displayed on a separate page in the PDF output.

6. A customer needs to build a QlikView application using data in text files. A new data file iscreated every day and stored in a folder on the customer's network named s. \userfiles.The file name is in the form dataYYYYMMDD.txt, where YYYYMMDD represents the current date,such as data20111231.txt.Which data load strategy should a developer use to load all of the customer's data files each day?

The statement 'Directory s. \userfiles\*;' preceding the Load statement

The 'Wildcard Load' feature by setting the 'File Location' in Document Properties

'Load * From [s. \userfiles\data*.txt] (ansi, txt, delimiter is '\t', embedded labels);'

'Load * From_Field (s. \userfiles\, 'data*.txt') (ansi, txt, delimiter is '\t', embedded labels);'

The correct answer is 'Load * From [s. \userfiles\data*.txt] (ansi, txt, delimiter is '\t', embedded labels);'. This strategy uses a wildcard in the file location to load all data files that match the pattern 'data*.txt' in the specified directory. The wildcard allows the developer to load all the customer's data files each day without having to specify the exact file name or date. The other options either do not use a wildcard or do not include the necessary file location and wildcard pattern to load all the data files.

Explanation

The correct answer is 'Load * From [s. \userfiles\data*.txt] (ansi, txt, delimiter is '\t', embedded labels);'. This strategy uses a wildcard in the file location to load all data files that match the pattern 'data*.txt' in the specified directory. The wildcard allows the developer to load all the customer's data files each day without having to specify the exact file name or date. The other options either do not use a wildcard or do not include the necessary file location and wildcard pattern to load all the data files.

7. A customer with a complex chart is experiencing performance issues when the organization's users view the chart without first applying several filters.A designer needs to place a restriction on the chart so that the users are forced to make a selection before QlikView will calculate and render the chart. Which common object property can the designer use to accomplish this?

The Help Text property on the Caption tab to enter instructions directing the user to make a selection and filter their data before performing their analysis

The Auto Minimize property on the Caption tab so that the chart will be minimized and not calculate or render until the user has first made a selection and restored the chart

The Calculate Condition property on the General tab to create a control condition that will keep the chart from calculating until user has filtered the data

The Size to Data property on the Layout tab to automatically size the filter criteria to the chart

The designer can use the Calculate Condition property on the General tab to create a control condition that will prevent the chart from calculating until the user has filtered the data. This means that the chart will only be rendered and displayed once the user has made a selection, helping to improve performance by avoiding unnecessary calculations and rendering.

Explanation

The designer can use the Calculate Condition property on the General tab to create a control condition that will prevent the chart from calculating until the user has filtered the data. This means that the chart will only be rendered and displayed once the user has made a selection, helping to improve performance by avoiding unnecessary calculations and rendering.

8. What must a developer consider when loading a table after the Section Access statement and before the Section Application statement?

All field names must start with a $ sign.

All field names must be written in uppercase.

The field Access must be the first field loaded.

The fields Access, User, and Password must be loaded.

When loading a table after the Section Access statement and before the Section Application statement, the developer must consider that all field names must be written in uppercase. This means that the names of the fields should be in capital letters. This is important because QlikView is case-sensitive when it comes to field names, so if the field names are not in uppercase, they may not be recognized correctly by the system. Therefore, it is necessary to ensure that all field names are written in uppercase to avoid any issues with data loading and analysis.

Explanation

When loading a table after the Section Access statement and before the Section Application statement, the developer must consider that all field names must be written in uppercase. This means that the names of the fields should be in capital letters. This is important because QlikView is case-sensitive when it comes to field names, so if the field names are not in uppercase, they may not be recognized correctly by the system. Therefore, it is necessary to ensure that all field names are written in uppercase to avoid any issues with data loading and analysis.

9. A customer needs the data displayed in the exhibit loaded into QlikView for analysis. The data is stored in a flat-file and new rows are appended daily. Which two data quality issues will a developer have to resolve? (Choose two.)

The Transaction ID field name contains a space

One or more Product field values contain spaces

The Date field values contain special characters

One or more header rows are included in the file data

One or more Product field values contain the file delimiter

The Date field name is also a function name and is a reserved word

The developer will have to resolve the issue of one or more header rows being included in the file data. This is because header rows are not actual data and can cause inaccuracies in analysis. Additionally, they will also have to resolve the issue of one or more Product field values containing the file delimiter. This is because the file delimiter is used to separate different fields in the data, and if it is present within a field value, it can cause incorrect parsing of the data.

Explanation

The developer will have to resolve the issue of one or more header rows being included in the file data. This is because header rows are not actual data and can cause inaccuracies in analysis. Additionally, they will also have to resolve the issue of one or more Product field values containing the file delimiter. This is because the file delimiter is used to separate different fields in the data, and if it is present within a field value, it can cause incorrect parsing of the data.

Submit

10. 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?

Load the Address Book records and perform a Left Join of the Excel data to the Address Book table

Load the Excel data and then load the Address Book data ensuring the Country Code field has the same name in both tables

Load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Book table

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

The developer should load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Book table. This technique allows the developer to map the Country Code field in the Address Book table to the corresponding Country description in the Excel data using Applymap. If a Country Code value is missing in the Address Book table, the default mapping value can be used to ensure that a Country description is still loaded for all Address Book records.

Explanation

The developer should load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Book table. This technique allows the developer to map the Country Code field in the Address Book table to the corresponding Country description in the Excel data using Applymap. If a Country Code value is missing in the Address Book table, the default mapping value can be used to ensure that a Country description is still loaded for all Address Book records.

11. 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?

Inner Join

Left Join

Right Join

Outer Join

The developer should use a Left Join when loading the text file. A Left Join will return all records from the left table (in this case, the database table) and the matching records from the right table (the text file) based on the specified join condition (ProductID). This means that all products from the master list in the database table will be included in the resulting table, and any additional data fields from the text file will be added if there is a match on ProductID.

Explanation

The developer should use a Left Join when loading the text file. A Left Join will return all records from the left table (in this case, the database table) and the matching records from the right table (the text file) based on the specified join condition (ProductID). This means that all products from the master list in the database table will be included in the resulting table, and any additional data fields from the text file will be added if there is a match on ProductID.

12. 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 language definition table in the data model containing all descriptions for each language, and the option to select a specific language in a field

A separate document for each language

Variables for language-specific items and the option to select a specific language in a field

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

The correct solution for the customer's multi-language support needs is to use 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. This solution allows for flexibility in supporting additional languages in the future and provides a centralized location for all language descriptions. Additionally, the option to select a specific language in a field ensures that the application can display the content in the chosen language.

Explanation

The correct solution for the customer's multi-language support needs is to use 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. This solution allows for flexibility in supporting additional languages in the future and provides a centralized location for all language descriptions. Additionally, the option to select a specific language in a field ensures that the application can display the content in the chosen language.

13. A customer needs to have QlikView deployed to tablet devices. When creating the QVW application, which two actions must a developer take to meet the customer's need? (Choose two.)

Convert the QVW application into a .mob document on the server

Ensure that screen resolution is appropriate for the device

Convert the QVW application into a HTML5 document

Create a specific QVW application for each device

Use only sheet objects suitable for tablet devices

To meet the customer's need of deploying QlikView to tablet devices, the developer must take two actions. Firstly, they need to ensure that the screen resolution is appropriate for the device, as different tablets may have different screen resolutions. This will ensure that the QVW application is displayed correctly on the tablet devices. Secondly, the developer should use only sheet objects that are suitable for tablet devices. This means selecting and designing sheet objects that are optimized for tablet use, providing a seamless and user-friendly experience for the customer.

Explanation

To meet the customer's need of deploying QlikView to tablet devices, the developer must take two actions. Firstly, they need to ensure that the screen resolution is appropriate for the device, as different tablets may have different screen resolutions. This will ensure that the QVW application is displayed correctly on the tablet devices. Secondly, the developer should use only sheet objects that are suitable for tablet devices. This means selecting and designing sheet objects that are optimized for tablet use, providing a seamless and user-friendly experience for the customer.

Submit

14. 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 thefields 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

To eliminate synthetic keys and appropriately link the data, the developer should first qualify all tables by prefixing them with their respective aliases. This ensures that the fields from different tables can be distinguished. Then, the developer should unqualify all key fields, which means removing the table prefix from the key fields. This allows the key fields to be properly linked between the tables without any synthetic keys.

Explanation

To eliminate synthetic keys and appropriately link the data, the developer should first qualify all tables by prefixing them with their respective aliases. This ensures that the fields from different tables can be distinguished. Then, the developer should unqualify all key fields, which means removing the table prefix from the key fields. This allows the key fields to be properly linked between the tables without any synthetic keys.

15. What is the cardinality of the relationship between CUSTOMER and ACCOUNT?

Many-to-many

One-to-many

One-to-none

One-to-one

The cardinality of the relationship between CUSTOMER and ACCOUNT is many-to-many. This means that a customer can have multiple accounts and an account can be associated with multiple customers. It suggests that there can be multiple customers linked to multiple accounts, indicating a complex and flexible relationship between the two entities.

Explanation

The cardinality of the relationship between CUSTOMER and ACCOUNT is many-to-many. This means that a customer can have multiple accounts and an account can be associated with multiple customers. It suggests that there can be multiple customers linked to multiple accounts, indicating a complex and flexible relationship between the two entities.

16. A customer specified that the QlikView application should be designed to fit a screen resolution of 1280 x 800 as a standard.Which option will assist a designer while creating the user interface?

Go to View menu > Resize Window > 1280 x 800

Go to View menu > Fit Zoom to Window > 1280 x 800

Go to Settings menu > User Preferences > Design Tab and select 1280 x 800

Go to Settings menu > User Preferences > Design Tab and select Display Grid Lines

The option "Go to View menu > Resize Window > 1280 x 800" will assist a designer while creating the user interface by allowing them to resize the window to the specified screen resolution of 1280 x 800. This ensures that the application is designed to fit the specified screen resolution as a standard.

Explanation

The option "Go to View menu > Resize Window > 1280 x 800" will assist a designer while creating the user interface by allowing them to resize the window to the specified screen resolution of 1280 x 800. This ensures that the application is designed to fit the specified screen resolution as a standard.

17. Which technique should be used by a developer to eliminate the circular reference in the data modeldisplayed in the exhibit?

Qualify all the fields in the data model ending with 'ID'

Qualify the fields Name, Address, City, and Country in the Shippers and Suppliers tables

Rename the fields ShipperID in the Shippers table and SupplierID in the Suppliers table

Rename the fields OrderID in the OrderDetails table and SupplierID in the Products table

To eliminate the circular reference in the data model, the developer should qualify the fields Name, Address, City, and Country in the Shippers and Suppliers tables. By qualifying these fields, it means adding the table names as prefixes to the field names, such as Shippers.Name, Shippers.Address, Suppliers.City, and Suppliers.Country. This helps to differentiate the fields with the same name in different tables, resolving the circular reference issue.

Explanation

To eliminate the circular reference in the data model, the developer should qualify the fields Name, Address, City, and Country in the Shippers and Suppliers tables. By qualifying these fields, it means adding the table names as prefixes to the field names, such as Shippers.Name, Shippers.Address, Suppliers.City, and Suppliers.Country. This helps to differentiate the fields with the same name in different tables, resolving the circular reference issue.

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

Custom Object

Button Object

QlikView Macro

Extension Object

The designer should use an Extension Object to integrate QlikView with an interactive third-party web service for use in the AJAX Zero Footprint client. Extension Objects allow developers to extend the functionality of QlikView by integrating external web services, creating custom visualizations, and adding interactive features. This makes it the most suitable option for integrating QlikView with a third-party web service in the AJAX Zero Footprint client.

Explanation

The designer should use an Extension Object to integrate QlikView with an interactive third-party web service for use in the AJAX Zero Footprint client. Extension Objects allow developers to extend the functionality of QlikView by integrating external web services, creating custom visualizations, and adding interactive features. This makes it the most suitable option for integrating QlikView with a third-party web service in the AJAX Zero Footprint client.

19. Which QlikView feature should a developer use to provide information throughout the QVW application about how a field was calculated in the Load script?

Field Tag

Field Comment

Dimension Tag

Variable Comment

Expression Comment

Field Comment is the correct answer because it allows a developer to provide information about how a field was calculated in the Load script. Field comments can be added to individual fields in the script, and they can be viewed by other developers or users when they hover over the field name in the QlikView application. This feature is useful for documenting and explaining the logic behind the calculations performed on a field, making it easier for others to understand and work with the application.

Explanation

Field Comment is the correct answer because it allows a developer to provide information about how a field was calculated in the Load script. Field comments can be added to individual fields in the script, and they can be viewed by other developers or users when they hover over the field name in the QlikView application. This feature is useful for documenting and explaining the logic behind the calculations performed on a field, making it easier for others to understand and work with the application.

20. A customer needs a better understanding of inventory trends over time. However, the sourcedatabase contains only the current product inventory levels.Which technique will take advantage of QlikView capabilities to meet the customer's needs?

Using a QlikView script to store an accumulation of periodic snapshots to a table in the sourcedatabase

Using a QVD file to store an accumulation of periodic snapshots from the source database

Using a QVX file to store an accumulation of periodic snapshots from the source database

Using a QlikView script to store an accumulation of periodic snapshots to an XML file

Using a QVD file to store an accumulation of periodic snapshots from the source database is the best technique to meet the customer's needs for better understanding of inventory trends over time. A QVD file is a QlikView-specific file format that allows for efficient storage and retrieval of data. By storing periodic snapshots in a QVD file, the customer can easily analyze and compare inventory levels over time using QlikView's powerful capabilities. This technique ensures that the customer has access to historical inventory data and can track trends effectively.

Explanation

Using a QVD file to store an accumulation of periodic snapshots from the source database is the best technique to meet the customer's needs for better understanding of inventory trends over time. A QVD file is a QlikView-specific file format that allows for efficient storage and retrieval of data. By storing periodic snapshots in a QVD file, the customer can easily analyze and compare inventory levels over time using QlikView's powerful capabilities. This technique ensures that the customer has access to historical inventory data and can track trends effectively.

21. A customer has 30 target values that are used to evaluate the quality of an organization'sfacilities. 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 aFOR loop to assign the values to variables

Manually create a variable for each value in Expression Overview and maintain them in ExpressionOverview

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

The most efficient way to store, access, and maintain the target values is to save them in an external file and load them into a QlikView table. By doing so, the values can be easily accessed and maintained in a structured manner. Using a FOR loop to assign the values to variables allows for efficient processing and manipulation of the data. This approach also allows for scalability and flexibility, as new target values can be easily added or modified in the external file without affecting the code structure.

Explanation

The most efficient way to store, access, and maintain the target values is to save them in an external file and load them into a QlikView table. By doing so, the values can be easily accessed and maintained in a structured manner. Using a FOR loop to assign the values to variables allows for efficient processing and manipulation of the data. This approach also allows for scalability and flexibility, as new target values can be easily added or modified in the external file without affecting the code structure.

22. The tables displayed in the exhibit need to be loaded into QlikView. How will the data model appear once the load is complete?

There will be a relationship between all the tables without synthetic key tables or loosely coupledtables.

There will be a relationship between four of the five tables and one table will be a data island.

There will be a synthetic key table in the data model.

There will be loosely coupled tables in the data model.

Once the tables are loaded into QlikView, the data model will have loosely coupled tables. This means that the tables will have a relationship, but it will not be a strong or direct relationship. The tables will be connected through common fields or keys, but they will not be tightly integrated. This allows for more flexibility in the data model and allows for easier modifications or additions to the data structure.

Explanation

Once the tables are loaded into QlikView, the data model will have loosely coupled tables. This means that the tables will have a relationship, but it will not be a strong or direct relationship. The tables will be connected through common fields or keys, but they will not be tightly integrated. This allows for more flexibility in the data model and allows for easier modifications or additions to the data structure.

23. A customer's data set contains information for multiple departments.The customer needs a document to show only one specific department when a user first accesses the application. Which trigger and action will meet the requirement?

Trigger. OnPostReload; action. Lock Field

Trigger. OnOpen; action. Set Variable

Trigger. OnOpen; action. Select in Field

Trigger. OnSelect; action. Select in Field

The trigger "OnOpen" is used when a user first accesses the application, and the action "Select in Field" will allow the customer to show only one specific department. This means that when the application is opened, the action will automatically select the desired department, filtering the data set to only show information related to that department.

Explanation

The trigger "OnOpen" is used when a user first accesses the application, and the action "Select in Field" will allow the customer to show only one specific department. This means that when the application is opened, the action will automatically select the desired department, filtering the data set to only show information related to that department.

24. A QlikView report does not match the legacy report it was designed to replace. The purpose of thereport is to count the number of customers per year and in total.Why is there a difference between the Total row values in the two reports?

The legacy report calculates the total customer occurrences, while the QlikView report counts onlydistinct customers.

The legacy report calculates the total customer occurrences, while the QlikView report calculatesthe customer ranking

The legacy report totals the number of customers correctly, while the QlikView report is droppingrecords.

The legacy report totals the number of customers correctly, while the QlikView total row is set toSum of rows.

The correct answer is that the legacy report calculates the total customer occurrences, while the QlikView report counts only distinct customers. This means that the legacy report includes all occurrences of a customer, even if they appear multiple times, while the QlikView report only counts each customer once, regardless of how many times they appear. This difference in calculation method results in a difference in the total row values between the two reports.

Explanation

The correct answer is that the legacy report calculates the total customer occurrences, while the QlikView report counts only distinct customers. This means that the legacy report includes all occurrences of a customer, even if they appear multiple times, while the QlikView report only counts each customer once, regardless of how many times they appear. This difference in calculation method results in a difference in the total row values between the two reports.

25. A customer has two databases containing employee data for different regions. Based on the script displayed in the exhibit, what will be the resulting table schema?

One table named Employees_US

One table named Employees_UK

Two tables named Employees_US and Employees_UK with no associations

Two tables named Employees_US and Employees_UK with a synthetic key

Based on the script displayed in the exhibit, the resulting table schema will be one table named Employees_US.

Explanation

Based on the script displayed in the exhibit, the resulting table schema will be one table named Employees_US.

26. What is the primary key of ACCOUNT_TRANS?

ACCOUNT_ID

TRANS_SEQ

ACCOUNT_ID and TRANS_SEQ

ACCOUNT_ID, TRANS_SEQ, and TRANS_TYPE

The primary key of ACCOUNT_TRANS is composed of both ACCOUNT_ID and TRANS_SEQ. This means that the combination of these two columns uniquely identifies each record in the ACCOUNT_TRANS table. Having a primary key is essential for maintaining data integrity and ensuring that there are no duplicate or conflicting records in the table.

Explanation

The primary key of ACCOUNT_TRANS is composed of both ACCOUNT_ID and TRANS_SEQ. This means that the combination of these two columns uniquely identifies each record in the ACCOUNT_TRANS table. Having a primary key is essential for maintaining data integrity and ensuring that there are no duplicate or conflicting records in the table.

27. How can a developer use QVD files to optimize reload performance?

Create an incremental load strategy that reduces the query sizes against the source data

Decrease latency between the QlikView reload engine and the source data

Enable a direct interface between the database server memory and the QlikView server memory

Enable the binary load functionality and directly load files in binary from the hard disk into system memory

By creating an incremental load strategy, the developer can optimize reload performance using QVD files. This strategy involves reducing the query sizes against the source data, which helps to minimize the amount of data that needs to be loaded and processed during each reload. Incremental loading allows the developer to only load and update the new or modified data since the last reload, rather than reloading the entire dataset. This can significantly improve the reload performance by reducing the time and resources required for the reload process.

Explanation

By creating an incremental load strategy, the developer can optimize reload performance using QVD files. This strategy involves reducing the query sizes against the source data, which helps to minimize the amount of data that needs to be loaded and processed during each reload. Incremental loading allows the developer to only load and update the new or modified data since the last reload, rather than reloading the entire dataset. This can significantly improve the reload performance by reducing the time and resources required for the reload process.

28. The Sales table displayed in the exhibit represents the entire data set. Given the expression.=sum( {$< Month={'Oct'}, RegionID={'4'} >} SalesAmount)What is the result with the selections for SalesPersonID=1 and RegionID=3?

0

3500

4500

5000

not-available-via-ai

Explanation

not-available-via-ai

29. 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 baselinecurrency

Create a separate QVW for each currency ($USD is considered its own currency) and documentchain them all together

Create a single QVW with duplicate tables for each currency in data islands and associate each dataisland to each user or group

By creating a single QVW and adding a table containing currency multipliers while using $USD as a baseline currency, the developer can achieve the goal of providing sales figures in both local currencies and $USD. This approach allows users to consume a single Document CAL, as all the necessary information is contained within one QVW file. The currency multipliers in the table can be used to convert the local currency amounts to $USD, providing the required figures in the corporate standard.

Explanation

By creating a single QVW and adding a table containing currency multipliers while using $USD as a baseline currency, the developer can achieve the goal of providing sales figures in both local currencies and $USD. This approach allows users to consume a single Document CAL, as all the necessary information is contained within one QVW file. The currency multipliers in the table can be used to convert the local currency amounts to $USD, providing the required figures in the corporate standard.

30. A customer created 20 expressions that will be used repetitively throughout a QlikViewapplication. 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 textin each object

Create a variable for each expression that contains the expression text and use the variable inplace of the expression in each object

To efficiently apply and maintain the expressions, the developer should create a variable for each expression that contains the expression text. By using variables, the developer can easily manage and update the expressions in one central location. This eliminates the need to edit each individual object that uses the expression. Instead, the variable can be used in place of the expression in each object, ensuring consistency and simplifying maintenance.

Explanation

To efficiently apply and maintain the expressions, the developer should create a variable for each expression that contains the expression text. By using variables, the developer can easily manage and update the expressions in one central location. This eliminates the need to edit each individual object that uses the expression. Instead, the variable can be used in place of the expression in each object, ensuring consistency and simplifying maintenance.

31. A developer created two QVWs. The first QVW loads data from the data source and creates QVD files. The second QVW loads the QVD files and provides the user interface for the analytics.The customer does not have Publisher installed.How should the reloads be configured on the server to ensure the first QVW reload completes before the second QVW reload begins?

Only the first QVW reload can be automated. An alert will need to be sent to prompt an administrator to manually perform the second QVW reload.

Only one QVW reload can occur at a time on the QlikView server. The second QVW reload will always wait until the first QVW reload completes.

The second QVW reload can be scheduled to start upon the successful completion of the first QVW reload.

An action can be placed on the OnPostReload trigger within the first QVW to submit the reload of the second QVW.

The second QVW reload can be scheduled to start upon the successful completion of the first QVW reload. This means that the server will automatically start the reload of the second QVW once it detects that the first QVW reload has finished successfully. This ensures that the second QVW reload will not begin until the data has been loaded and the QVD files have been created by the first QVW.

Explanation

The second QVW reload can be scheduled to start upon the successful completion of the first QVW reload. This means that the server will automatically start the reload of the second QVW once it detects that the first QVW reload has finished successfully. This ensures that the second QVW reload will not begin until the data has been loaded and the QVD files have been created by the first QVW.

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

Identically to all table linkages created in a relational database

On a field called ".id" created by the developer in every table

On an identically named field in both the fact table and the dimension table

By manually setting the field property Keyfield on one field in both the fact table and thedimension table

In QlikView, the fact table and dimension table are linked by having an identically named field in both tables. This means that there is a common field in both tables that is used to establish the relationship between the data in the fact table and the dimension table. This allows QlikView to associate and analyze the data based on this common field, enabling users to easily explore and navigate the data in a flexible and intuitive manner.

Explanation

In QlikView, the fact table and dimension table are linked by having an identically named field in both tables. This means that there is a common field in both tables that is used to establish the relationship between the data in the fact table and the dimension table. This allows QlikView to associate and analyze the data based on this common field, enabling users to easily explore and navigate the data in a flexible and intuitive manner.

33. What is the interpretation of a 98 percent subset ratio in the CustomerID field in an Orderstable when the subset ratio of the same field in the Customer table is 100 percent?

98 percent of the orders have customers in the data, but only 2 percent of the orders have beenshipped

2 percent of the orders have customers in the data, but 100 percent of the customers have placedan order

100 percent of customers are defined in the Customer table, but 2 percent of the customers havenot placed an order

98 percent of the customers are defined in the Customer table, but 2 percent of the customershave not placed an order

The interpretation of a 98 percent subset ratio in the CustomerID field in the Orderstable, when the subset ratio of the same field in the Customer table is 100 percent, is that 100 percent of customers are defined in the Customer table, but 2 percent of the customers have not placed an order. This means that while all customers are recorded in the Customer table, there is a small percentage of customers who have not yet placed an order in the Orders table.

Explanation

The interpretation of a 98 percent subset ratio in the CustomerID field in the Orderstable, when the subset ratio of the same field in the Customer table is 100 percent, is that 100 percent of customers are defined in the Customer table, but 2 percent of the customers have not placed an order. This means that while all customers are recorded in the Customer table, there is a small percentage of customers who have not yet placed an order in the Orders table.

34. Which action should a developer perform on a table to reduce the 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

Splitting out a single complex field into multiple fields reduces the number of distinct values per field, which can help reduce the required memory and optimize the application. By doing this, the application can store and process data more efficiently, as it eliminates the need to store repetitive or redundant data. Additionally, it allows for better organization and indexing of the data, making it easier to retrieve and manipulate when needed.

Explanation

Splitting out a single complex field into multiple fields reduces the number of distinct values per field, which can help reduce the required memory and optimize the application. By doing this, the application can store and process data more efficiently, as it eliminates the need to store repetitive or redundant data. Additionally, it allows for better organization and indexing of the data, making it easier to retrieve and manipulate when needed.

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

Change the script to use an Inner Join instead of Left Join

Change the QUALIFY * command to list out only the fields that need to be qualified

Change the Left Join command to include the name of the table being joined enclosed inparentheses

Change the DepartmentID field in the SalesPerson table to match the qualified field name ofDepartmentID in the Department table

The error message "OBJECT OUT OF MEMORY" suggests that the script is consuming too much memory, causing it to fail. By changing the QUALIFY * command to list out only the fields that need to be qualified, the developer can reduce the memory usage of the script. This means that only the necessary fields will be processed, reducing the memory requirements and resolving the logic error.

Explanation

The error message "OBJECT OUT OF MEMORY" suggests that the script is consuming too much memory, causing it to fail. By changing the QUALIFY * command to list out only the fields that need to be qualified, the developer can reduce the memory usage of the script. This means that only the necessary fields will be processed, reducing the memory requirements and resolving the logic error.

36. A customer has a Sales data table and needs a chart to display sales figures by date, including dates without sales.The Sales table is sorted by the primary key which is generated based on the type of order and the SalesPersonID who generated it. Which technique should a developer use to achieve this requirement?

A Resident Load and Peek, to determine the minimum and maximum dates and then AutoGenerate to create a master calendar

The today() function, to determine the required date range and use an Inline load to generate the master calendar

Peek, when loading the Sales data, to create records within the Sales data table for dates with no sales

Calculated dimensions in Chart Objects and expressions in List Boxes, to generate the required dates

A developer should use a Resident Load and Peek technique to determine the minimum and maximum dates from the Sales data table. This will allow them to create a master calendar using the AutoGenerate function. By using Resident Load and Peek, the developer can extract the necessary date information from the Sales table and then generate a calendar that includes all dates, even those without sales. This technique ensures that the chart will display sales figures by date, fulfilling the customer's requirement.

Explanation

A developer should use a Resident Load and Peek technique to determine the minimum and maximum dates from the Sales data table. This will allow them to create a master calendar using the AutoGenerate function. By using Resident Load and Peek, the developer can extract the necessary date information from the Sales table and then generate a calendar that includes all dates, even those without sales. This technique ensures that the chart will display sales figures by date, fulfilling the customer's requirement.

37. An Invoices table has a DaysOverdue field. A chart is required to analyze overdue invoices in 30 day intervals.Which function should a designer use within a chart to meet this requirement?

Class(DaysOverdue,30)

Aggr(DaysOverdue,30)

GroupBy(DaysOverdue,30)

IntervalMatch(DaysOverdue,30)

The designer should use the Class(DaysOverdue,30) function within the chart to meet the requirement of analyzing overdue invoices in 30 day intervals. This function will group the DaysOverdue values into intervals of 30 days, allowing for a clear analysis of the overdue invoices based on the specified interval.

Explanation

The designer should use the Class(DaysOverdue,30) function within the chart to meet the requirement of analyzing overdue invoices in 30 day intervals. This function will group the DaysOverdue values into intervals of 30 days, allowing for a clear analysis of the overdue invoices based on the specified interval.

38. 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? Internet Explorer Plug-in client on a 64 bit Windows 7 operating system

Internet Explorer Plug-in client on a 64 bit Windows 7 operating system

QlikView local client on a 32 bit Windows 7 operating system

QlikView local client on a 64 bit Mac operating system

QlikView local client on a 64 bit Windows 7 operating system

The QlikView local client on a 64 bit Windows 7 operating system is the correct answer because it allows the developer to modify the data model of the document. Additionally, using a 64 bit operating system provides access to more memory, which is necessary to accommodate the 5GB RAM consumption of the document.

Explanation

The QlikView local client on a 64 bit Windows 7 operating system is the correct answer because it allows the developer to modify the data model of the document. Additionally, using a 64 bit operating system provides access to more memory, which is necessary to accommodate the 5GB RAM consumption of the document.

39. A customer needs to display sales amounts for the current month and a trend of sales over the prior 12 months using a small amount of screen space. Which chart type should the designer use to meets the customer's needs?

A Combo Chart with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months

A Straight Table with one expression to display the current month sales and a second Line Chart to display a trend of sales over the prior 12 months

A Straight Table with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months

A Straight Table with one expression to display the current month sales and a second expression represented as a Linear Gauge to display a trend of sales over the prior 12 months

The designer should use a Straight Table with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months. This option allows the customer to view both the current month sales and the trend of sales over the prior 12 months in a compact and efficient manner, using a small amount of screen space.

Explanation

The designer should use a Straight Table with one expression to display the current month sales and a second expression represented as a Mini Chart to display a trend of sales over the prior 12 months. This option allows the customer to view both the current month sales and the trend of sales over the prior 12 months in a compact and efficient manner, using a small amount of screen space.

40. A customer needs to analyze Products by Product Grouping. The relationship between Productand 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

The correct answer is by generating a lookup table using the Inline wizard. This means that within the QlikView script, a lookup table can be created using the Inline wizard. This allows the user to define the Product Grouping by manually entering the necessary data directly into the script. This method is useful when the relationship between Product and Product Group is undefined in the original data source.

Explanation

The correct answer is by generating a lookup table using the Inline wizard. This means that within the QlikView script, a lookup table can be created using the Inline wizard. This allows the user to define the Product Grouping by manually entering the necessary data directly into the script. This method is useful when the relationship between Product and Product Group is undefined in the original data source.

41. A customer has a set of date values in different formats. Some dates are in Julian date format; some dates are text strings. How can a developer ensure the data is loaded in a consistent format?

Change the default DateFormat variable assignment on the Main script tab

Use the Date function to format the field during load

Use the Alt function with different Date# functions

Use the Lookup function with a format table

The Alt function can be used to load data in a consistent format by providing multiple options for parsing the dates using different Date# functions. This allows the developer to handle different date formats and convert them into a consistent format during the load process.

Explanation

The Alt function can be used to load data in a consistent format by providing multiple options for parsing the dates using different Date# functions. This allows the developer to handle different date formats and convert them into a consistent format during the load process.

42. Which statement describes required field characteristics 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.

The correct answer is that the fields must be aliased to the same name when loading into QlikView. This is because QlikView uses field names to create associations between tables. If the field names are not the same, QlikView will not be able to establish the associations correctly. The other statements are not necessarily true for ensuring associations across multiple tables.

Explanation

The correct answer is that the fields must be aliased to the same name when loading into QlikView. This is because QlikView uses field names to create associations between tables. If the field names are not the same, QlikView will not be able to establish the associations correctly. The other statements are not necessarily true for ensuring associations across multiple tables.

43. Schema A displayed in the exhibit has been transformed into Schema B. How can the before and after schemas be described?

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

The snowflake schema has been transformed into a normalized schema.

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

The star schema has been transformed into a normalized schema.

The given answer is correct because it states that the snowflake schema, which is a normalized schema, has been transformed into a de-normalized schema. This means that the schema has been modified to reduce the number of relationships and increase redundancy in order to improve performance for certain types of queries.

Explanation

The given answer is correct because it states that the snowflake schema, which is a normalized schema, has been transformed into a de-normalized schema. This means that the schema has been modified to reduce the number of relationships and increase redundancy in order to improve performance for certain types of queries.

44. When the script displayed in the exhibit is reloaded, an error message is displayed.Table not foundLeft Join (SalesPerson)LOAD ID,DepartmentIDFROM[DataSourceA.xlsx](ooxml, embedded labels, table is SalesPersonDepartment);What is the likely cause of the error?

When loaded, the SalesPerson table is auto concatenated to Customer and does not exist whenreferenced.

The Left Join statement fails to correctly bracket the referenced table name, such as Left Join([SalesPerson]).

The Left Join statement fails to correctly quote the referenced table name, such as Left Join("SalesPerson").

There is an error in the Customer table load and it is not created in memory.

The likely cause of the error is that when the script is reloaded, the SalesPerson table is auto concatenated to the Customer table. However, when the script tries to reference the SalesPerson table, it does not exist because it has been concatenated with the Customer table.

Explanation

The likely cause of the error is that when the script is reloaded, the SalesPerson table is auto concatenated to the Customer table. However, when the script tries to reference the SalesPerson table, it does not exist because it has been concatenated with the Customer table.

45. A customer needs to measure the Amount of Sales by Days Sales Outstanding (DSO). Days Sales Outstanding does not exist in the data model. Which technique should a developer use to meet the customer's need?

On the Dimensions tab, press the Add Calculated Dimension button

On the Expressions tab, add an expression using the Class function

On the Expressions tab, add an expression using the Aggr function

On the Dimensions tab, press the Add Dynamic Dimension button

To meet the customer's need of measuring the Amount of Sales by Days Sales Outstanding (DSO), a developer should use the technique of pressing the Add Calculated Dimension button on the Dimensions tab. This allows the developer to create a new calculated dimension that can be used to calculate and display the DSO based on the available data in the data model.

Explanation

To meet the customer's need of measuring the Amount of Sales by Days Sales Outstanding (DSO), a developer should use the technique of pressing the Add Calculated Dimension button on the Dimensions tab. This allows the developer to create a new calculated dimension that can be used to calculate and display the DSO based on the available data in the data model.

46. A customer who operates a large national sales organization needs to divide a Sales.qvw document into region-specific documents using the Region field (North, South, East, and West). Each region should have access to region-specific data.Which instruction should a developer give to the Server/Publisher administrator to meet the customer's needs?

Create a QlikView Server task to reduce the Sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions

Create a QlikView Publisher task to reduce the Sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions

Create four QlikView Server tasks to reload data from the Sales.qvw document with data only for each region and distribute to region-specific folders with appropriate file permissions

Create a QlikView Publisher task to reduce data from the Sales.qvw document to create four QVX files with data only for each region and distribute to region-specific folders with appropriate file permissions

The correct answer is to create a QlikView Publisher task to reduce the Sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions. This is the best solution because it allows the customer to divide the document into region-specific documents using the Region field. The Publisher task can reduce the document based on this field and distribute the resulting documents to region-specific folders, ensuring that each region has access to its own data. Additionally, the task can apply appropriate file permissions to ensure data security.

Explanation

The correct answer is to create a QlikView Publisher task to reduce the Sales.qvw document based on the Region field and distribute to region-specific folders with appropriate file permissions. This is the best solution because it allows the customer to divide the document into region-specific documents using the Region field. The Publisher task can reduce the document based on this field and distribute the resulting documents to region-specific folders, ensuring that each region has access to its own data. Additionally, the task can apply appropriate file permissions to ensure data security.

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

Add field metadata tags to fields in the load script

Put a How To sheet in the application

Put descriptive information in each object's help text

Add a system table to the application

To clearly describe dimensions and measures for end users who need to use collaborative objects, a developer should add field metadata tags to fields in the load script. This technique allows developers to provide additional information about the fields, such as their meaning, usage, or any specific instructions. By adding these metadata tags, end users can easily understand and interpret the dimensions and measures when working with the collaborative objects. This helps in enhancing collaboration and ensuring that all users have a clear understanding of the data and its context.

Explanation

To clearly describe dimensions and measures for end users who need to use collaborative objects, a developer should add field metadata tags to fields in the load script. This technique allows developers to provide additional information about the fields, such as their meaning, usage, or any specific instructions. By adding these metadata tags, end users can easily understand and interpret the dimensions and measures when working with the collaborative objects. This helps in enhancing collaboration and ensuring that all users have a clear understanding of the data and its context.

48. When should a developer create a new tab in the Load Script?

When the critical number of 255 lines per tab has been exceeded

When the tab is marked with the ///tab$ statement

When portions of script are logically related

When entering Edit Script for the first time

A developer should create a new tab in the Load Script when portions of the script are logically related. This allows for better organization and readability of the script. By grouping related portions of the script together, it becomes easier to understand and maintain the code. It also helps in troubleshooting and debugging as developers can quickly locate and work on specific sections of the script. Creating a new tab based on logical relationships improves the overall efficiency and effectiveness of the development process.

Explanation

A developer should create a new tab in the Load Script when portions of the script are logically related. This allows for better organization and readability of the script. By grouping related portions of the script together, it becomes easier to understand and maintain the code. It also helps in troubleshooting and debugging as developers can quickly locate and work on specific sections of the script. Creating a new tab based on logical relationships improves the overall efficiency and effectiveness of the development process.

49. A developer made several changes to a 25-tab load script that normally runs for at least twohours.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 commenteach successive Go To Exit after a successful run

Move each revised tab in succession to the second tab position, place an Exit Script statement atthe 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

not-available-via-ai

Explanation

not-available-via-ai

50. Which chart should a designer use to display orders, sales, and average order value grouped by year, quarter, region, product, and salesperson?

Pivot Table

Straight Table

Grid Chart

Mekko Chart

Bar Chart

A Pivot Table is the most suitable chart for displaying orders, sales, and average order value grouped by multiple dimensions such as year, quarter, region, product, and salesperson. It allows the designer to easily analyze and compare data across different categories and provides a comprehensive view of the data. The Pivot Table can summarize and aggregate data in a flexible and interactive manner, making it an ideal choice for this type of analysis.

Explanation

A Pivot Table is the most suitable chart for displaying orders, sales, and average order value grouped by multiple dimensions such as year, quarter, region, product, and salesperson. It allows the designer to easily analyze and compare data across different categories and provides a comprehensive view of the data. The Pivot Table can summarize and aggregate data in a flexible and interactive manner, making it an ideal choice for this type of analysis.

51. 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?

Load the tables leaving the automatic associations

Comment out the AssignedTo from the Orders table

Comment out the AssignedTo from the Customer table

Use Rename Field syntax to alias one of the AssignedTo fields

Create a concatenated key of CustomerID and AssignedTo in both tables

To meet the requirement of displaying Customers and Orders by employee, the script should use the Rename Field syntax to alias one of the AssignedTo fields. This will allow the system to differentiate between the employee assigned to the Customer and the employee assigned to the Order, while still maintaining the necessary associations between the tables. By renaming one of the AssignedTo fields, the script can create a clear distinction and enable users to view the data by employee accurately.

Explanation

To meet the requirement of displaying Customers and Orders by employee, the script should use the Rename Field syntax to alias one of the AssignedTo fields. This will allow the system to differentiate between the employee assigned to the Customer and the employee assigned to the Order, while still maintaining the necessary associations between the tables. By renaming one of the AssignedTo fields, the script can create a clear distinction and enable users to view the data by employee accurately.

52. 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?

Build a Link Table to connect the four transaction tables and add a summary table with precalculatedcounts, totals, and averages

Build a Link Table to connect the four transaction tables and alias fields that must be kept in theirrespective table

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

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

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

The most effective approach to meet the customer's requirements while optimizing performance and maintaining accuracy is to concatenate the four transaction tables and add fields to identify the record type and count flag. By concatenating the tables, the data can be easily analyzed across dimensions and metrics. Adding fields to identify the record type and count flag allows for accurate calculation of the required metrics. This approach avoids the need for a Link Table and aliasing fields, which can be more complex and potentially impact performance. Keeping the tables separate and qualifying the names may also lead to difficulties in linking the data correctly.

Explanation

The most effective approach to meet the customer's requirements while optimizing performance and maintaining accuracy is to concatenate the four transaction tables and add fields to identify the record type and count flag. By concatenating the tables, the data can be easily analyzed across dimensions and metrics. Adding fields to identify the record type and count flag allows for accurate calculation of the required metrics. This approach avoids the need for a Link Table and aliasing fields, which can be more complex and potentially impact performance. Keeping the tables separate and qualifying the names may also lead to difficulties in linking the data correctly.

53. A customer has an Addresses table with the fields. CustomerNumber, CustomerName, AddressLine1, AddressLine2, City, StateCode, PostalCode, and CountryCode.A designer needs to design a chart to show a count of distinct customers in which the customer's CountryCode is US or CA, while ignoring all selections on the Addresses table except the CustomerNumber and CustomerName fields.How can the designer calculate the required value?

Option 5

The designer can calculate the required value by creating a chart with the CustomerNumber and CustomerName fields as dimensions and using the distinct count aggregation on these fields. Then, the designer can apply a filter to only include customers whose CountryCode is US or CA. This will give the count of distinct customers from the specified countries while ignoring any selections made on other fields in the Addresses table.

Explanation

The designer can calculate the required value by creating a chart with the CustomerNumber and CustomerName fields as dimensions and using the distinct count aggregation on these fields. Then, the designer can apply a filter to only include customers whose CountryCode is US or CA. This will give the count of distinct customers from the specified countries while ignoring any selections made on other fields in the Addresses table.

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

The Fax field has NULL values for 24 percent of the records.

The Fax field has blanks for 24 percent of the records.

The Fax field has 76 percent incomplete/invalid fax numbers.

On average, 76 percent of the Fax field values are non-spaces.

The longest Fax value is 76 percent of the assigned field length.

The exhibit shows that the Fax field has NULL values for 24 percent of the records.

Explanation

The exhibit shows that the Fax field has NULL values for 24 percent of the records.

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

Multiple spellings of the same City

The City value London is associated with two different Country values

The Country values and SalesOrderID values do not relate properly

The SalesAmount field name does not contain a space

Inconsistent Country abbreviations

Duplicate key values

The data set displayed in the exhibit has two data quality issues. Firstly, there are multiple spellings of the same city, which indicates inconsistency and can lead to confusion or errors in data analysis. Secondly, there are inconsistent country abbreviations, which can also cause confusion and inaccuracies when analyzing the data.

Explanation

The data set displayed in the exhibit has two data quality issues. Firstly, there are multiple spellings of the same city, which indicates inconsistency and can lead to confusion or errors in data analysis. Secondly, there are inconsistent country abbreviations, which can also cause confusion and inaccuracies when analyzing the data.

Submit

56. A customer's product catalog database contains approximately 50,000 individual productSKUs. The catalog is updated quarterly.The customer needs the load on database servers to be minimized.Which technique should a developer use to meet the customer's needs?

A preceding load statement when loading the product catalog quarterly from the customer'sdatabase

The BUFFER statement when loading the product catalog quarterly from the customer's database

A mapping table when loading the product catalog quarterly from the customer's database

A QVD file to store the product catalog quarterly from the customer's database

To minimize the load on the database servers, a developer should use a QVD (QlikView Data) file to store the product catalog quarterly from the customer's database. QVD files are optimized for efficient data storage and retrieval in QlikView applications. By storing the product catalog in a QVD file, the developer can reduce the need for frequent database queries and improve overall performance. This technique allows for faster data loading and reduces the workload on the database servers.

Explanation

To minimize the load on the database servers, a developer should use a QVD (QlikView Data) file to store the product catalog quarterly from the customer's database. QVD files are optimized for efficient data storage and retrieval in QlikView applications. By storing the product catalog in a QVD file, the developer can reduce the need for frequent database queries and improve overall performance. This technique allows for faster data loading and reduces the workload on the database servers.

57. A customer is building a dashboard to measure the performance of the Support organization. The customer needs to dynamically sort the Ticket Severity field by Severity Weight field when the Ticket Severity column header is double-clicked in Straight Table charts.Example ticket severities. Urgent = 1 High = 2 Normal = 3 Low = 4 Which QlikView load script function can the developer use to create the Ticket Severity field to meet the customer's needs?

Rank( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

Num( [Severity Weight], [Ticket Severity] ) AS [Ticket Severity]

Sort( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]

The correct answer is "Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]". This function creates a field that contains both the Ticket Severity and Severity Weight values. It allows the customer to sort the Ticket Severity field by Severity Weight when the Ticket Severity column header is double-clicked in Straight Table charts.

Explanation

The correct answer is "Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]". This function creates a field that contains both the Ticket Severity and Severity Weight values. It allows the customer to sort the Ticket Severity field by Severity Weight when the Ticket Severity column header is double-clicked in Straight Table charts.

58. 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

The developer should proceed by selecting "ODBC" from the Database pull down menu in the Data tab of the script editor. They should also make sure to select the "Force 32 bit" check box before clicking the "Connect" button. This is because the data model is intended to run on a 64-bit Windows Server, and using the 32-bit version of ODBC will ensure compatibility with the Microsoft Access database.

Explanation

The developer should proceed by selecting "ODBC" from the Database pull down menu in the Data tab of the script editor. They should also make sure to select the "Force 32 bit" check box before clicking the "Connect" button. This is because the data model is intended to run on a 64-bit Windows Server, and using the 32-bit version of ODBC will ensure compatibility with the Microsoft Access database.

59. A Straight Table Chart calculates several metrics for each individual alphanumeric transaction detail record (TRAN_ID) and its Amount over several years of data. The calculation time for the chart is over two minutes.How can a designer decrease the calculation time for the chart without compromising core functionality?

Create a Calculation Condition. =count(TRAN_ID)

Create a Calculation Condition. =sum(TRAN_ID)

Create a Calculation Condition. =sum(Amount) > 0

Create a Calculation Condition. =TRAN_ID < 10000

Creating a calculation condition using the formula "=count(TRAN_ID)" will decrease the calculation time for the chart without compromising core functionality. This is because the count function is a relatively simple and efficient calculation compared to summing the transaction IDs or amounts. By using the count function, the designer can quickly determine the number of transaction IDs in the data set, reducing the overall calculation time for the chart.

Explanation

Creating a calculation condition using the formula "=count(TRAN_ID)" will decrease the calculation time for the chart without compromising core functionality. This is because the count function is a relatively simple and efficient calculation compared to summing the transaction IDs or amounts. By using the count function, the designer can quickly determine the number of transaction IDs in the data set, reducing the overall calculation time for the chart.

60. A customer has multiple bar charts comparing different metrics. All charts contain a single Expression all with the Dimension CustomerID.The charts are sorted by Y-Value Descending. Some Customers have Y-Values of zero for some metrics and not others. How can the designer show the same color bar for a single CustomerID in all the charts?

Properties > Colors and then define colors 1 - 6 with specific RGB values

Properties > Colors and then check the Multicolored and Persistent Colors checkboxes

Properties > Visual Cues and then set the Upper and Lower colors using specific RGB values

Properties > Presentation and then define the Error Bars colors with a specific RGB value

By checking the Multicolored and Persistent Colors checkboxes in the Properties > Colors section, the designer can ensure that the same color bar is shown for a single CustomerID in all the charts. This means that even if a CustomerID has Y-Values of zero for some metrics and not others, the color of their bar will remain consistent across all the charts.

Explanation

By checking the Multicolored and Persistent Colors checkboxes in the Properties > Colors section, the designer can ensure that the same color bar is shown for a single CustomerID in all the charts. This means that even if a CustomerID has Y-Values of zero for some metrics and not others, the color of their bar will remain consistent across all the charts.

61. How can a designer display the field selections that have been made within a chart caption?

By inserting a Current Selections box into the Text in Chart

By using an expression with GetCurrentSelections in the Window Title option on the General tab

By using an expression with Set Analysis and the System Fields in the Title Text option on the Caption tab

By selecting Show Current Selections on the Caption tab

By using an expression with GetCurrentSelections in the Window Title option on the General tab, the designer can display the field selections that have been made within a chart caption. This allows the chart to dynamically update and show the current selections made by the user.

Explanation

By using an expression with GetCurrentSelections in the Window Title option on the General tab, the designer can display the field selections that have been made within a chart caption. This allows the chart to dynamically update and show the current selections made by the user.

62. A customer has an Actual Sales fact table aggregated at the transactional level and aBudgeted Sales fact table aggregated at the monthly level. The tables share many of the samedimensional 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 asNULL

Create a link table containing the dimensional fields then link each fact table using a concatenatedkey

The developer should create a link table containing the dimensional fields and then link each fact table using a concatenated key. This approach allows for a more efficient and organized data model. By creating a link table, the developer can establish a relationship between the fact tables and the dimensional fields, ensuring accurate and meaningful analysis. The concatenated key helps in uniquely identifying the records and avoiding any data inconsistencies. This approach also allows for easy expansion and maintenance of the data model in the future.

Explanation

The developer should create a link table containing the dimensional fields and then link each fact table using a concatenated key. This approach allows for a more efficient and organized data model. By creating a link table, the developer can establish a relationship between the fact tables and the dimensional fields, ensuring accurate and meaningful analysis. The concatenated key helps in uniquely identifying the records and avoiding any data inconsistencies. This approach also allows for easy expansion and maintenance of the data model in the future.

63. Which objects are the most appropriate for setting one or more values for use in a "what-if" scenario?

Input Box Object and Chart Object

Input Box Object and Calendar/Slider Object

Button Object and Extension Object

Calendar/Slider Object and Chart Object

Input Box Object and Text Object

not-available-via-ai

Explanation

not-available-via-ai

64. A developer has a Container Object with multiple charts and each chart has many different expressions.The developer needs to provide users with a method to easily obtain information related to each chart and the expressions within. How can the developer fulfill this requirement?

Design a help graphic for each chart and set it as the caption background

Create a Text Object containing help information for each chart and link each Chart Object to its corresponding Text Object using QlikView's Linked Objects feature

Enter a thorough description of each chart and its expressions in the Text in Chart property on the Layout tab

Enter a thorough description of each chart and its expressions in the Help Text property on the Caption tab

The developer can fulfill this requirement by entering a thorough description of each chart and its expressions in the Help Text property on the Caption tab. This will provide users with easily accessible information related to each chart and its expressions.

Explanation

The developer can fulfill this requirement by entering a thorough description of each chart and its expressions in the Help Text property on the Caption tab. This will provide users with easily accessible information related to each chart and its expressions.

65. In which two places in the Chart Properties of a Gauge can expressions be entered? (Choose two.)

Calculation Condition of the object

Number of major/minor units for the scale

Show Condition of the object

X and Y position of the object

Auto Minimize of the object

Expressions can be entered in the Calculation Condition and Show Condition of the object in the Chart Properties of a Gauge. The Calculation Condition allows for the use of expressions to determine when a calculation should be performed, while the Show Condition allows for the use of expressions to determine whether the object should be displayed or hidden.

Explanation

Expressions can be entered in the Calculation Condition and Show Condition of the object in the Chart Properties of a Gauge. The Calculation Condition allows for the use of expressions to determine when a calculation should be performed, while the Show Condition allows for the use of expressions to determine whether the object should be displayed or hidden.

Submit

66. 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?

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

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

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

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

By using the Concatenate function to append the Budgets table to the Actuals table, the developer can remove the synthetic key automatically generated by QlikView. This allows for the analysis of budgets and actuals by product, month, and year.

Explanation

By using the Concatenate function to append the Budgets table to the Actuals table, the developer can remove the synthetic key automatically generated by QlikView. This allows for the analysis of budgets and actuals by product, month, and year.

67. How many rows and fields will TableA have after the script completes?

Five rows and three fields

Five rows and two fields

Four rows and three fields

Four rows and two fields

Two rows and three fields

The script will complete with five rows and three fields in TableA.

Explanation

The script will complete with five rows and three fields in TableA.

68. 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?

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

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

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

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 tablesDrop the location and date fields from all other tables

The correct answer suggests finding the minimum and maximum dates that appear in all the tables. Then, a calendar is created spanning those dates. Additionally, a link table is created with a key of location and date, containing all unique locations and dates. Finally, a key of location and date is added to the other tables, and the location and date fields are dropped from all other tables. This approach ensures that a master calendar is created that can be used with all the tables, allowing for consistent analysis and reporting.

Explanation

The correct answer suggests finding the minimum and maximum dates that appear in all the tables. Then, a calendar is created spanning those dates. Additionally, a link table is created with a key of location and date, containing all unique locations and dates. Finally, a key of location and date is added to the other tables, and the location and date fields are dropped from all other tables. This approach ensures that a master calendar is created that can be used with all the tables, allowing for consistent analysis and reporting.

69. A customer needs an application to reload in a short time period. The source tables are log files that are appended to on a daily basis.Which performance tuning option should a developer use?

The QVD files to store the source tables

The Partial Reload command with the append option

The Load prefix Buffer with the incremental option

The Load prefix Buffer and set the Keep Outdated QVD Buffers in the Document Properties

Using QVD files to store the source tables can improve the performance of reloading the application in a short time period. QVD files are optimized for fast read and write operations, allowing for quick data retrieval. By storing the source tables in QVD files, the application can load the data directly from these files instead of reading the entire log files every time, resulting in faster reload times.

Explanation

Using QVD files to store the source tables can improve the performance of reloading the application in a short time period. QVD files are optimized for fast read and write operations, allowing for quick data retrieval. By storing the source tables in QVD files, the application can load the data directly from these files instead of reading the entire log files every time, resulting in faster reload times.

70. A project to develop a QlikView application for a customer requires splitting developers intotwo teams.One team will focus on developing source database query knowledge to create a reusable data layer.There are several application-specific business rules for this project. The customer needs toincrementally accumulate history for the QlikView application over time.The second team will focus on developing the presentation layer. This team also has data modeling and scripting expertise, but does not have source database query knowledge.Which data loading strategy should the developers use on the project?

Create a series of QVWs that apply the business rules and then binary load them into thepresentation layer QVW

Create the presentation layer QVW and connect directly to the source data and apply the businessrules in the script

Create QVDs of the source data and load them into the presentation layer QVW and apply thebusiness rules in the script

Create QVDs of the source data, apply the business rules and store a second layer of QVDs, andthen load these QVDs into the presentation layer QVW

The developers should create a series of QVWs that apply the business rules and then binary load them into the presentation layer QVW. This strategy allows the first team to focus on developing the source database query knowledge and create a reusable data layer. The second team, which lacks source database query knowledge, can then focus on developing the presentation layer using the pre-built QVWs that already apply the necessary business rules. This approach ensures efficient collaboration between the two teams and allows for incremental accumulation of history for the QlikView application over time.

Explanation

The developers should create a series of QVWs that apply the business rules and then binary load them into the presentation layer QVW. This strategy allows the first team to focus on developing the source database query knowledge and create a reusable data layer. The second team, which lacks source database query knowledge, can then focus on developing the presentation layer using the pre-built QVWs that already apply the necessary business rules. This approach ensures efficient collaboration between the two teams and allows for incremental accumulation of history for the QlikView application over time.