Business And Customer Service Quiz

70 Questions | Total Attempts: 107

SettingsSettingsSettings
Please wait...
Customer Quizzes & Trivia

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.


Questions and Answers
  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

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

  • 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

  • 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

  • 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

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

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

  • 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

  • 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

  • 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

  • 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

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

      By loading the lookup table using an Include statement

  • 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

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

      Concatenate Load the Budgeted Sales table into the Actual Sales table loading shared fields as NULL

    • D. 

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

  • 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

  • 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

Back to Top Back to top