Business And Customer Service Quiz

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

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

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

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 baseline currency

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

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

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

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

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

ACCOUNT_ID

TRANS_SEQ

ACCOUNT_ID and TRANS_SEQ

ACCOUNT_ID, TRANS_SEQ, and TRANS_TYPE

Many-to-many

One-to-many

One-to-none

One-to-one

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.

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

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.

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

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

Build a Link Table to connect the four transaction tables and alias fields that must be kept in their respective 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

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

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

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

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

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 as NULL

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

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

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

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

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

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 text in each object

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

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

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

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

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

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)';

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

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

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

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 in parentheses

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

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

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.

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

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

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

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

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);'

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

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

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

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

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 the dimension table

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

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

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

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

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

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

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

Previous

Match

Exists

In

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

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

Inner Join

Left Join

Right Join

Outer Join

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.

0

3500

4500

5000

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]

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