# Business And Customer Service Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Post
P
Post
Community Contributor
Quizzes Created: 1 | Total Attempts: 179
Questions: 70 | Attempts: 179

Settings

Customer service is the provision of serves to customers – hence the name – before, during, and/or after a purchase. Whether you work in retail or a call center, customer service is a necessity for any business in ensuring customer satisfaction. Take this Business and Customer Service Quiz to see how much do you know.

• 1.

### 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?

• A.

Age group

• B.

Number of patients

• C.

Checked-in status

• D.

Hospital

A. Age group
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.

Rate this question:

• 2.

### 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?

• A.

On the Dimensions tab, press the Add Calculated Dimension button

• B.

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

• C.

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

• D.

On the Dimensions tab, press the Add Dynamic Dimension button

A. On the Dimensions tab, press the Add Calculated Dimension button
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.

Rate this question:

• 3.

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

• A.

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

• B.

A separate document for each language

• C.

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

• D.

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

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

Rate this question:

• 4.

### 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.)

• A.

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

• B.

Ensure that screen resolution is appropriate for the device

• C.

Convert the QVW application into a HTML5 document

• D.

Create a specific QVW application for each device

• E.

Use only sheet objects suitable for tablet devices

B. Ensure that screen resolution is appropriate for the device
E. Use only sheet objects suitable for tablet devices
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.

Rate this question:

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

A report with banding on SalesTeam

• B.

A report with GROUP BY on SalesTeam

• C.

Separate reports with where clauses for each SalesTeam

• D.

Separate reports referencing bookmarks for each SalesTeam

• E.

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

A. A report with banding on SalesTeam
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.

Rate this question:

• 6.

### A global sales organization needs sales figures in both the local currencies and the corporate standard of \$USD. How can a developer achieve this goal and enable users to only consume a single Document CAL?

• A.

Create a separate QVW containing values in the data model for both the local and \$USD currency amounts

• B.

Create a single QVW and add a table containing currency multipliers while using \$USD as a baseline currency

• C.

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

• D.

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

B. Create a single QVW and add a table containing currency multipliers while using \$USD as a baseline currency
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.

Rate this question:

• 7.

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

• A.

Multiple spellings of the same City

• B.

The City value London is associated with two different Country values

• C.

The Country values and SalesOrderID values do not relate properly

• D.

The SalesAmount field name does not contain a space

• E.

Inconsistent Country abbreviations

• F.

Duplicate key values

A. Multiple spellings of the same City
E. Inconsistent Country abbreviations
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.

Rate this question:

• 8.

### 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.)

• A.

The Transaction ID field name contains a space

• B.

One or more Product field values contain spaces

• C.

The Date field values contain special characters

• D.

One or more header rows are included in the file data

• E.

One or more Product field values contain the file delimiter

• F.

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

D. One or more header rows are included in the file data
E. One or more Product field values contain the file delimiter
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.

Rate this question:

• 9.

### 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?

• A.

NULL

• B.

1; 2; 3

• C.

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

• D.

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

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

Rate this question:

• 10.

### 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?

• A.

Change the default DateFormat variable assignment on the Main script tab

• B.

Use the Date function to format the field during load

• C.

Use the Alt function with different Date# functions

• D.

Use the Lookup function with a format table

C. Use the Alt function with different Date# functions
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.

Rate this question:

• 11.

### Which statement describes required field characteristics that will ensure QlikView associations across multiple tables?

• A.

The field formats (such as numeric or string) must be the same in the original data sources.

• B.

The fields must be defined as primary or foreign keys in the original data sources.

• C.

The fields must be aliased to the same name when loading into QlikView.

• D.

The number of distinct values in each field must be the same.

C. The fields must be aliased to the same name when loading into QlikView.
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.

Rate this question:

• 12.

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

• A.

Convert numeric fields into text fields using the Text function

• B.

Combine multiple fields into one complex field, reducing the number of fields per table

• C.

Make all numeric fields a fixed length by left padding with leading 0's using the Num function

• D.

Split out a single complex field into multiple fields reducing the number of distinct values per field

D. Split out a single complex field into multiple fields reducing the number of distinct values per field
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.

Rate this question:

• 13.

### What is the primary key of ACCOUNT_TRANS?

• A.

ACCOUNT_ID

• B.

TRANS_SEQ

• C.

ACCOUNT_ID and TRANS_SEQ

• D.

ACCOUNT_ID, TRANS_SEQ, and TRANS_TYPE

C. ACCOUNT_ID and TRANS_SEQ
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.

Rate this question:

• 14.

### What is the cardinality of the relationship between CUSTOMER and ACCOUNT?

• A.

Many-to-many

• B.

One-to-many

• C.

One-to-none

• D.

One-to-one

A. Many-to-many
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.

Rate this question:

• 15.

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

• A.

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

• B.

The snowflake schema has been transformed into a normalized schema.

• C.

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

• D.

The star schema has been transformed into a normalized schema.

A. The snowflake schema has been transformed into a de-normalized schema.
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.

Rate this question:

• 16.

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

• A.

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

• B.

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

• C.

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

• D.

There will be loosely coupled tables in the data model.

D. There will be loosely coupled tables in the data model.
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.

Rate this question:

• 17.

### 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?

• A.

Load the tables leaving the automatic associations

• B.

Comment out the AssignedTo from the Orders table

• C.

Comment out the AssignedTo from the Customer table

• D.

Use Rename Field syntax to alias one of the AssignedTo fields

• E.

Create a concatenated key of CustomerID and AssignedTo in both tables

D. Use Rename Field syntax to alias one of the AssignedTo fields
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.

Rate this question:

• 18.

### A customer needs to analyze transactions across the Dimensions and Metrics identified below. Required Dimensions. ------ Project ID Month Year Account ID Transaction Type Client ID Required Metrics. ----- Number of transactions Total Amount Total Cost Average Amount Average Cost Which approach will provide the most effective QlikView data model to meet the customer's requirements while optimizing performance and maintaining accuracy?

• A.

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

• B.

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

• C.

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

• D.

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

• E.

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

D. Concatenate the four transaction tables and add fields to identify the record type and count flag
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.

Rate this question:

• 19.

### A customer has aggregated budgets for products by year and month. Actual data is stored at a more detailed transaction level and so a one-to-many relationship exists between the Budgets to Actuals table. Budgets have been assigned for all months of the current year, but there are only transactions up to the current month of October. There are transactions for products that were not assigned budgets. How can a developer remove the synthetic key automatically generated by QlikView and be able to analyze budgets and actuals by product, month, and year?

• A.

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

• B.

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

• C.

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

• D.

Create a concatenated key of Product-Year-Month in both the Budgets and Actuals table and comment out the individual fields in the Budgets table

C. Load the Actuals table, and when loading the Budgets table, use the Concatenate function to append the Budgets table to the Actuals table
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.

Rate this question:

• 20.

### 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?

• A.

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

• B.

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

• C.

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

• D.

From the script editor, on the Data tab, under Database choose 'ODBC' from the Database pull down and then click the 'Connect' button

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

Rate this question:

• 21.

### 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?

• A.

By using Input Box to enter the lookup table

• B.

By using AutoGenerate to load the lookup table

• C.

By generating a lookup table using the Inline wizard

• D.

C. By generating a lookup table using the Inline wizard
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.

Rate this question:

• 22.

### 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?

• A.

Qualify all tables

• B.

Alias all primary key fields

• C.

Left join the Customer data onto the Sales table

• D.

Qualify all tables and then unqualify all key fields

D. Qualify all tables and then unqualify all key fields
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.

Rate this question:

• 23.

### 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?

• A.

Qualify both tables and Unqualify all shared fields

• B.

Left join the Budgeted Sales table onto the fact table using Month as the key

• C.

• D.

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

D. Create a link table containing the dimensional fields then link each fact table using a concatenated key
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.

Rate this question:

• 24.

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

• A.

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

• B.

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

• C.

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

• D.

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

B. Qualify the fields Name, Address, City, and Country in the Shippers and Suppliers tables
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.

Rate this question:

• 25.

### 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?

• A.

Save the target names and values in an external file, load them into a QlikView table, and use a FOR loop to assign the values to variables

• B.

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

• C.

Create a Variables tab in the load script and use 30 LET statements to assign the values to variables

• D.

Embed the target values into each expression in which they are required

A. Save the target names and values in an external file, load them into a QlikView table, and use a FOR loop to assign the values to variables
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.

Rate this question:

• 26.

### 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?

• A.

Create the required expression in each object as needed and edit them in the Expression Overview

• B.

Load the text for each expression from a text file into a table in the data model and link it to the fact table

• C.

Create a table of indices and expression text and use the index value in place of the expression text in each object

• D.

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

D. Create a variable for each expression that contains the expression text and use the variable in place of the expression in each object
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.

Rate this question:

• 27.

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

• A.

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

• B.

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

• C.

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

• D.

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

• E.

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

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

Rate this question:

• 28.

### 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?

• A.

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

• B.

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

• C.

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

• D.

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

A. The legacy report calculates the total customer occurrences, while the QlikView report counts only distinct customers.
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.

Rate this question:

• 29.

### 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?

• A.

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

• B.

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

• C.

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

• D.

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

• E.

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

E. LET vNumRows = NoOfRows('TableName'); TRACE 'Resulting Rows = \$(vNumRows)';
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.

Rate this question:

• 30.

### 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?

• A.

Place a Go To Exit statement after each block of revised script code, run the script, and comment each successive Go To Exit after a successful run

• B.

Move each revised tab in succession to the second tab position, place an Exit Script statement at the end of the tab script, and run the script

• C.

Open the QlikView Debugger and use the Step button to execute each line of the script

• D.

Open the QlikView Debugger and use Limited Load to execute the script

D. Open the QlikView Debugger and use Limited Load to execute the script
• 31.

### 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?

• A.

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

• B.

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

• C.

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

• D.

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

B. Change the QUALIFY * command to list out only the fields that need to be qualified
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.

Rate this question:

• 32.

### 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?

• A.

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

• B.

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

• C.

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

• D.

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

A. When loaded, the SalesPerson table is auto concatenated to Customer and does not exist when referenced.
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.

Rate this question:

• 33.

### 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?

• A.

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

• B.

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

• C.

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

• D.

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

A. Create a series of QVWs that apply the business rules and then binary load them into the presentation layer QVW
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.

Rate this question:

• 34.

### 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?

• A.

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

• B.

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

• C.

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

• D.

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

C. 'Load * From [s. \userfiles\data*.txt] (ansi, txt, delimiter is '\t', embedded labels);'
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.

Rate this question:

• 35.

### 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?

• A.

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

• B.

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

• C.

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

• D.

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

B. Using a QVD file to store an accumulation of periodic snapshots from the source database
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.

Rate this question:

• 36.

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

• B.

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

• C.

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

• D.

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

D. A QVD file to store the product catalog quarterly from the customer's database
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.

Rate this question:

• 37.

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

• A.

Identically to all table linkages created in a relational database

• B.

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

• C.

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

• D.

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

C. On an identically named field in both the fact table and the dimension table
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.

Rate this question:

• 38.

### 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?

• A.

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

• B.

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

• C.

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

• D.

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

C. 100 percent of customers are defined in the Customer table, but 2 percent of the customers have not placed an order
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.

Rate this question:

• 39.

### 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?

• A.

One table named Employees_US

• B.

One table named Employees_UK

• C.

Two tables named Employees_US and Employees_UK with no associations

• D.

Two tables named Employees_US and Employees_UK with a synthetic key

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

Rate this question:

• 40.

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

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

• B.

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

• C.

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

• D.

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

A. A Resident Load and Peek, to determine the minimum and maximum dates and then AutoGenerate to create a master calendar
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.

Rate this question:

• 41.

### An Address Book table has a Country Code field. A standard lookup table exists in Excel to translate the Country Code to a Country description.The Country Code will be US for any Address Book record with no Country Code value.Which technique should a developer use to ensure a Country description is loaded for all Address Book records?

• A.

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

• B.

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

• C.

• D.

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

C. Load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Book table
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.

Rate this question:

• 42.

### A developer needs to load an Account table and a Contact table from QVDs. The developer needs to load only contacts for the accounts that have already been loaded.There may be more than one contact for an account, so the developer needs to keep the Account and Contact tables separate. After loading the Account table, which function should the developer use in the Where clause of the Contact table load?

• A.

Previous

• B.

Match

• C.

Exists

• D.

In

C. Exists
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.

Rate this question:

• 43.

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

• A.

Designate one of the date fields as the reference Build a calendar spanning the minimum and maximum dates in that table Rename all other date fields to match the reference field 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

• B.

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

• C.

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

• D.

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

D. Find the minimum and maximum dates spanned by all tables Create a calendar spanning those dates Create a link table with a key of location and date that contains all unique locations and dates Create a key of location and date in the other tables Drop the location and date fields from all other tables
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.

Rate this question:

• 44.

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

• A.

five rows and three fields

• B.

five rows and two fields

• C.

Four rows and three fields

• D.

Four rows and two fields

• E.

Two rows and three fields

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

Rate this question:

• 45.

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

• A.

Inner Join

• B.

Left Join

• C.

Right Join

• D.

Outer Join

B. Left Join
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.

Rate this question:

• 46.

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

• A.

• B.

All field names must be written in uppercase.

• C.

The field Access must be the first field loaded.

• D.

B. All field names must be written in uppercase.
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.

Rate this question:

• 47.

• A.

0

• B.

3500

• C.

4500

• D.

5000

A. 0
• 48.

### 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?

• A.

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

• B.

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

• C.

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

• D.

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

D. Dual( [Ticket Severity], [Severity Weight] ) AS [Ticket Severity]
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.

Rate this question:

• 49.

### 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?

• A.

Go to View menu > Resize Window > 1280 x 800

• B.

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

• C.

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

• D.

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

A. Go to View menu > Resize Window > 1280 x 800
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.

Rate this question:

• 50.

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

• A.

Calculation Condition of the object

• B.

Number of major/minor units for the scale

• C.

Show Condition of the object

• D.

X and Y position of the object

• E.

Auto Minimize of the object

A. Calculation Condition of the object
C. Show Condition of the object
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.

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

• Current Version
• Feb 03, 2023
Quiz Edited by
ProProfs Editorial Team
• Jan 24, 2017
Quiz Created by
Post

Related Topics

×

Wait!
Here's an interesting quiz for you.