Business And Customer Service Quiz

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

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

Age group

Number of patients

Checked-in status

Hospital

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

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

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.

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

Many-to-many

One-to-many

One-to-none

One-to-one

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

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

Inner Join

Left Join

Right Join

Outer Join

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

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

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

Custom Object

Button Object

QlikView Macro

Extension Object

Field Tag

Field Comment

Dimension Tag

Variable Comment

Expression Comment

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

ACCOUNT_ID

TRANS_SEQ

ACCOUNT_ID and TRANS_SEQ

ACCOUNT_ID, TRANS_SEQ, and TRANS_TYPE

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.

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.

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

Trigger. OnPostReload; action. Lock Field

Trigger. OnOpen; action. Set Variable

Trigger. OnOpen; action. Select in Field

Trigger. OnSelect; action. Select in Field

0

3500

4500

5000

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

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

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

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

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

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.

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

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

Class(DaysOverdue,30)

Aggr(DaysOverdue,30)

GroupBy(DaysOverdue,30)

IntervalMatch(DaysOverdue,30)

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

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

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.

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.

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

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.

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

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

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

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

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