Qv 11 Plus

66 Questions

Settings
Please wait...
Excel Quizzes & Trivia

.


Questions and Answers
  • 1. 
    • A. 

      Full Accumulation

    • B. 

      Accumulate 2 Steps Back

    • C. 

      Accumulate 1 Steps Back

    • D. 

      Total Mode to Average of rows

  • 2. 
    Refer to the exhibit. A developer loads dates from Excel and creates an associated MasterCalendar table. After running the script, QlikView gives the values shown in the exhibit. Which function must be used to fix the problem? ((Sometime date, sometimes numbers) 
    • A. 

      MAKEDATE(Date) AS Date

    • B. 

      CONCAT (DATE(Date)) AS Date

    • C. 

      DATE(Date) AS Date

    • D. 

      SETDATE(Date) AS Date

  • 3. 
    To display the selected values of a single field in a text object, which expression should a developer use?
    • A. 

      GetSelections(FieldName)

    • B. 

      GetFieldSelections(FieldName)

    • C. 

      GetCurrentField(FieldName)

    • D. 

      GetCurrentFieldSelecion(FliedName)

  • 4. 
    Refer to the exhibit. The dataset shown has been loaded into a QlikView application. The user has selected the year '2015' to analyze. Which result is produced by the following expression:num((sum({1<[Month]={'May'}>}SalesAmt-COGS)/sum({1<[Month]={'May'}>}SalesAmt)), '#,##0.0%')
    • A. 

      34.8%

    • B. 

      22.5%

    • C. 

      13.5%

    • D. 

      77.5%

  • 5. 
    The developers need to create breakpoints in the script to make the execution stop when using the Debugger window. Which statement should be set as an effective breakpoint?
    • A. 

      -- Breakpoint Here;

    • B. 

      /* Breakpoint Here */

    • C. 

      // Breakpoint Here;

    • D. 

      REM Breakpoint Here;

  • 6. 
    The developer needs to perform a reload and display a message in the 'Script Execution Progress' box. What should the developer use to perform this task?
    • A. 

      REM

    • B. 

      TRACE

    • C. 

      //

    • D. 

      Echo

  • 7. 
    • A. 

      Create a Section Access table with NTNAME and PASSWORD

    • B. 

      Create a Section Access table with ACCESS and USERID

    • C. 

      Create one QlikView document per user with Loop and Reduce task

    • D. 

      Create a condition in the script for every user who accesses the QlikView document

  • 8. 
    Refer to the exhibit. The customer needs to display a column that shows the average sales by month for each product. Which expression produces the desired column?
    • A. 

      Avg(Aggr(Sum(SalesAmt), VendorName, ProductName, Month))

    • B. 

      Avg(Aggr(Sum(SalesAmt), Month))

    • C. 

      Aggr(Avg(SalesAmt), VendorName, ProductName, Month)

    • D. 

      Sum(Aggr(SalesAmt), VendorName, ProductName)/Month

  • 9. 
    For which action can an expression be used?
    • A. 

      Switch the chart type of an object

    • B. 

      Set the position of an object

    • C. 

      Conditionally show an object

    • D. 

      Change the font within an object

  • 10. 
    To execute a very complex script to load the fact table, it takes to much RAM for one particular QlikView document… remaining reload tasks. Which strategy should the developer follow to accelerate the reload?
    • A. 

      Use DO … WHILE and avoid RESIDENT as much as possible

    • B. 

      Use FOR … NEXT and avoid INLINE as much as possible

    • C. 

      Use KEEP and avoid JOIN as much as possible

    • D. 

      Use JOIN and avoid CONCATENATE as much as possible

  • 11. 
    Refer to the exhibit. When the script shown is loaded, what is the value of myVar2?
    • A. 

      0

    • B. 

      1

    • C. 

      9

    • D. 

      10

  • 12. 
    A developer needs to add custom help text to some objects in a QlikView document. This text should be visible to the user and should be shown on the chart by a question mark icon. How should the developer perform this task?
    • A. 

      In the object properties on the Presentation tab, add Text in Chart and select Pop-up Labels

    • B. 

      Add a button and use the Show Information action with help text in the Field input

    • C. 

      In the object properties on the Caption tab, enter Help Text

    • D. 

      The object must be placed in a Container object that has Help Text option

  • 13. 
    Refer to the exhibit. A developer has created a straight table to show the total costs in each month, as shown on the left side of the exhibit. Users have requested the developers to add two totals to the table: the total of all months and the mean (average) of the months These new totals should represent as shown. How should the developer use the object properties of the straight table to perform this task?
    • A. 

      In the Dimension Limits tab, select Show Total and use a custom label of Total. In the Expressions tab, select Average of Rows

    • B. 

      In the Dimension Limits tab, select Show Total In the Expressions tab, select Average of Rows In the Presentations tab, add the label Mean in the Totals section

    • C. 

      In the Dimension Limits tab, select Show Total and use a custom label set to Mean In the Expressions tab, select Average of Rows

    • D. 

      In the Dimension Limits tab, select Show Total In the Expressions tab, select Average of Rows

  • 14. 
    Refer to the exhibit. A developer needs to show the number of cases for each month and display the percentage each month represents full year adds up to 100%, and the developer uses a pivot table chart. Which expression returns the correct result for the column "Accumulation"?
    • A. 

      RangeSum(Above(Column(1), 0, NoOfRows()))

    • B. 

      RangeSum(Before(Column(1), 0, NoOfRows()))

    • C. 

      RangeSum(Above(Column(1), 0, RowNo()))

    • D. 

      RangeSum(Before(Column(1), 0, RowNo()))

  • 15. 
    A user should be able to enter any number should a developer use to create this functionality?
    • A. 

      A List Box that displays the user values from which to choose

    • B. 

      An Input Box connected to a variable

    • C. 

      A Slider Object with Static Step included

    • D. 

      A Container Object that includes the simulation calculation

  • 16. 
    RIGHT JOIN
    • A. 

      The keyword RIGHT will retain rows from the right table but only matching rows from the left table

    • B. 

      Option 2

  • 17. 
    The script shown below is run in QlikView:LEFT JOIN (Transaction)LOADCustomerID,CustomerName,Address,Country,ContactsName;SQL SELECT *FROM Customers;What is the result?
    • A. 

      The Transactions table remains, but all customers that did NOT have transactions are deleted

    • B. 

      The Transactions table remains, but all customers that did NOT have customer are deleted

    • C. 

      The Customers table remains, but all customers that did NOT have customer are deleted

    • D. 

      The Customers table remains, but all customers that did NOT have transactions are deleted

  • 18. 
    A developer needs to append new employees to an existing employee table. Which method should the developer use?
    • A. 

      Perform a partial reload with the statement: ADD LOAD Name, EmployeeID FROM newEmployees.csv;

    • B. 

      Perform a reload with the statement: REPLACE LOAD Name, EmployeeID FROM newEmployees.csv;

    • C. 

      Perform a partial reload with the statement: CONCATENATE LOAD Name, EmployeeID FROM newEmployees.csv;

    • D. 

      Perform a reload with the statement: APPEND LOAD Name, EmployeeID FROM newEmployees.csv;

  • 19. 
    Refer to the exhibit. A Human Resource department keeps an up-to-date Excel file that contains the names of all former employees. The developer needs to use this information to load only employees who are currently on the payroll. The former employees are already loaded in the data model as shown. The SalesRepsEurope.xlsx file contains the names of all sales representative who have worked at the company. Which script loads only the active employees from the SalesRepsEurope.xlsx file?
    • A. 

      Exists() determines whether a specific field value has already been loaded into the field in the load script. The function returns TRUE or FALSE, so can be used in the where clause of a LOAD statement or an IF statement. Syntax: Exists(field_name [, expr] )

    • B. 

      Option 2

  • 20. 
    To troubleshoot a data load, a developer needs to execute the load script up to a specific point. Which method should the developer use?
    • A. 

      Add WHERE clauses to each LOAD statement to limit the data

    • B. 

      Add the Exit Script command after the last operation to be executed

    • C. 

      Use the debug window with Limited Load set to perform a load

    • D. 

      Use the Partial Reload function to perform a load

  • 21. 
    A company suspects that increasing margins negatively affect sales. Which chart makes it easiest to determine if there is a correlation over time?
    • A. 

      Option 1

    • B. 

      Option 2

  • 22. 
    Refer to the exhibit. Given the data source shown in Exibit 1, the developer needs to achieve the result shown in Exhibit 2. Which expression should the developer use for the column "Value for Max Date"?
    • A. 

      Sum(Aggr(FirstSortedValue(Date, Value),ID))

    • B. 

      Sum(Aggr(FirstSortedValue(Value, Date),ID))

    • C. 

      Sum(Aggr(FirstSortedValue(Value, -Date),ID))

    • D. 

      Sum(Aggr(FirstSortedValue(Date, -Value),ID))

    • E. 

      Reverse Order: Value, Sort-Weight

  • 23. 
    A hospital needs to analyze patient treatments and doctor utilization. There are four dimensions and three metrics to… analysis. There are four dimensions and two metrics for doctor utilization. What is the most appropriate method to display these data?
    • A. 

      A straight table to allow visualization of multiple measures and dimensions and quick sorting

    • B. 

      A table box to show all data in one convenient chart

    • C. 

      A pivot table to make it easy to organize, aggregate, and explore multiple dimensions and measures

    • D. 

      A grid chart to make it easy to show multiple dimensionality in a concise visual form

  • 24. 
    A developer has created a line chart to show a demand forecast model. This model includes dimensions and a complex expression … this requirement. How should the developer inform the end user about the contents of the complex expression?
    • A. 

      Place comments in the Dimensions tab of the Line Chart

    • B. 

      Place comments in the Expressions tab of the Line Chart

    • C. 

      Provide a written manual for the document

    • D. 

      Specify Text in Chart within the Line Chart

  • 25. 
    • A. 

      Use Window Scheduler, QlikView Server, and QlikView Publisher tasks

    • B. 

      Use QlikView Desktop and QlikView Publisher command line tools

    • C. 

      Use QlikView Server and Publisher tasks, set up in the QMC

    • D. 

      Use Windows Scheduler tasks and QlikView Server command line tools

  • 26. 
    A company has different departments. Each department has a set of managers with corresponding employees. This shown in a QlikView document. The document is to be used on a browser with the IE Plugin. What is the most efficient way to represent this structure?
    • A. 

      Create a multi box with Department, Manager, and Employee

    • B. 

      Create a list box in treeview with a hierarchy load

    • C. 

      Create a table box with Department, Manager, Employee

    • D. 

      Use an extension object that represents the fields in a treemap

  • 27. 
    A developer needs to build an application to be used throughout the whole company. A small group of users needs application on mobile devices. Which approach should the developer use to meet the requirement?
    • A. 

      Design the application to meet all requirements. Choose the smallest resolution possible

    • B. 

      Enable the grid. Place objects that are sized to fit all screen resolutions

    • C. 

      Design the application for the majority of users. Address mobile solutions separately

    • D. 

      Place all necessary objects below each other (as if in a column) to address all user needs in one application

  • 28. 
    A sheet has been created within an application. The sheet should NOT be used with any other selections made in the application. All selections should be cleared when a user enters this sheet. All tabs must be remain visible in this application. How should this effect be achieved?
    • A. 

      Create a second application that only contains this sheet.

    • B. 

      Use a button with actions Clear All and Activate Sheet, which links to the tab

    • C. 

      Use the sheet trigger OnActivateSheet and add the Clear All action

    • D. 

      Add a text box to ask the user to clear all selections

  • 29. 
    A company has a QlikView Server with several documents. The Director of Sales requires the developer to create an application so the a single application for each sales person in the company. Sales people must NOT see each other's best-selling products and most customers. The data must be protected even if applications are downloaded locally. The Director of Sales and Depty Director of … be able to view all of the information in the application. What should the developer do to meet the requirements?
    • A. 

      Develop the applications with QlikView Desktop and is feature to Keep Possible Values. Select each sales person in the corresponding listbox, then use a QlikView Publisher Distribution task to move it to each folder

    • B. 

      Develop a script with Section Access fields ADMIN and NTNAME, then reload the application with QlikView Server and distribute with QlikView Publisher

    • C. 

      Use QlikView Desktop to develop a script with section access and a reduction field. Once the QVW is completed QlikView Publisher will run a Loop and Reduce task by field and distribute to a QlikView Server

    • D. 

      Use QlikView Desktop to create the script with Section Access and schedule the reloads for each application, then create task in QlikView Publisher to distribute them to their corresponding folders

  • 30. 
    Refer to the exhibit. A developer loads the tables in the exhibit into QlikView without making any modifications. What can the developer detect in the table viewer after the load process?
    • A. 

      One circular reference

    • B. 

      Two circular reference

    • C. 

      One circular reference and one synthetic key // Hint: Synthetic keys link tables that have more than one field in common. Circular loop (reference) means you have alternative paths between two tables.

    • D. 

      Two circular reference and one synthetic key

  • 31. 
    A developer previously created QlikView documents for each department in a financial organization: HR, Marketing, Sales, Support, etc. The Board of Directors (BoD) needs a high-level view of all departments, with the ability to drill down to the details to make appropriate strategic decisions. Which two concepts should the developer implement? (Select two)
    • A. 

      Document chaining

    • B. 

      Loop and reduce

    • C. 

      Document segmentation

    • D. 

      A separate document for BoD

    • E. 

      Direct discovery

  • 32. 
    *** A developer deploys several QlikView documents on the server. Which two clients can be used to open the QlikView documents? (Select two)
    • A. 

      E-Mail application

    • B. 

      Android APK App

    • C. 

      Web Browser

    • D. 

      IE Plugin

    • E. 

      Java Client

  • 33. 
    A pivot table has the following dimensions and expression:
    • CustomerName (there are approximately 20,000 values)
    • A calculated dimension to get the top five products per customer based on sales using nested IF statements
    • An expression with the following code: SUM((1<Year=($(=Max(Year))), CompanyName={"=SUM({1}Sales)>}Sales)
    Business users access this table on a daily basis on the fill dataset, but the table performs slowly. Which option improves performance?
    • A. 

      Remove the calculated dimension and replace the set analysis in the expression with CASE statements

    • B. 

      Use a calculation condition on the pivot table based on a selection on the Customer field

    • C. 

      Use a condition on the expression and remove the set analysis

    • D. 

      Remove the calculated dimension and use dimension limits on the Customer dimension

  • 34. 
    Regarding load performance, the RESIDENT load method should be avoided for which reason? 
    • A. 

      It reads from disk, which is slow

    • B. 

      It reads through every record in the table

    • C. 

      It does NOT allow incremental loads

    • D. 

      It can NOT be used with partial loads

  • 35. 
    Refer to the exhibit. A developer needs to load four fields from the Employees table. The Company Dept field must be named Department, and the Employees field must be named NumberOfEmployees. The QlivView scripts runs without errors, but the result are NOT what the developer expected. What is the cause of this problem?
    • A. 

      The QlikView table name does NOT match the database table name

    • B. 

      There is no semi-colon on line 32, so more than four fields are loaded

    • C. 

      A QlikView field name can NOT exceed 16 characters

    • D. 

      Field names can NOT be encapsulated with single quotes

  • 36. 
    Which method should be used to load data from multiple files in a folder if the exact file name is unknown?
    • A. 

      Use the FileDir() and For each..next function to load each file

    • B. 

      Enter only the folder path without any filename within the load statement

    • C. 

      Use a wildcard(*) in the filename specified within the load statement

    • D. 

      Create a sub function to be called during the load to rename each file

  • 37. 
    A developer has created a QlikView document that must be refreshed every hour in the QlikView Server. The developer needs to ensure that files are loaded properly regardless of the file location. With regards to the source folder and paths used in the script for QVD and Excel files, which strategy should the developer choose?
    • A. 

      Place the folders with source files on the same QlikView Server

    • B. 

      Follow the Universal Naming Convention path for all folders to source files

    • C. 

      Map all folders with source files to a drive in the operating system

    • D. 

      Pace the folders with source files at the same level as the QlikView document

  • 38. 
    A developer needs to create five QVDs for a project through either a single document or multiple documents. Which two statements are advantages of creating QVDs with multiple documents? (Select two)
    • A. 

      Fewer connections to source systems are required

    • B. 

      The schedule for fast-changing and slow-changing data can differ

    • C. 

      Smaller QVW documents require less disk storage space

    • D. 

      Revision control for the documents can be simplified

    • E. 

      Greater control of security is allowed for produced QVDs

  • 39. 
    *** A developer needs to create a chart to display all tables and fields that are currently loaded into the application. Which system fields and objects should the developer use?
    • A. 

      $Field, $Table in a Table Box

    • B. 

      $Fields, $Table in a Pivot Table

    • C. 

      $Fields, $Fields in a Straight Table

    • D. 

      $Table, $FliedsNo in a MultiBox

  • 40. 
    A developer needs to use a variable and a control statement to specify which data file will be loaded. Which method should the developer choose?
    • A. 

      If myVar=1 then; load * from sales.csv; else; load * from budget.csv; else end;

    • B. 

      If myVar=1 then; load * from sales.csv; else; budget.csv; else if;

    • C. 

      If myVar=1 then; load * from sales.csv; elseif; load * from budget.csv; end if;

    • D. 

      If myVar=1 then; load * from sales.csv; else; load * from budget.csv; end if;

  • 41. 
    A developer needs to create a bar chart and a combo chart that correspond to a specified data range. The data model supports date ranges. Which two approaches may be used to write the expression of the chart? (Select two)
    • A. 

      Use set analysis and specify the data ranges within

    • B. 

      Use conditional expressions like If() to address it

    • C. 

      Use the MATCH function in the expressions to make sure the desired dates are applied

    • D. 

      Use Slider/Calendar objects that refer to variables where the dates are stored

    • E. 

      Use the Dual() function to return a numeric value

  • 42. 
    An ODBC connection is made to a Microsoft SQL DB from a development PC for the first time. Which two steps must the developer perform? (Select two)
    • A. 

      Create a new DSN for the ODBC connection

    • B. 

      Define the data source connection in the QlikView script

    • C. 

      Set the DB type variable to ODBC

    • D. 

      Add the ODBC connection to the resource library of the script

    • E. 

      Add the connection type to the Document Properties

  • 43. 
    QlikView document has been created with a complex data model and sheet layouts designed for a specific area of the business. A developer needs to use the same data model, but design different sheet layouts in a new document. What is the most efficient strategy the developer should use for load performance?
    • A. 

      Save the load script into an external text file and include it within the load script of both documents

    • B. 

      Alter the script of the original document to save the model to one QVD and load it in the new document

    • C. 

      Create a copy of the original document and remove the existing objects, sheets, and variables

    • D. 

      Use a binary statement within the load script of the new document and refer to the original document

  • 44. 
    In which scenario is it appropriate to use an incremental load strategy?
    • A. 

      There are high volumes of new transactions

    • B. 

      Dimension data is subject to frequent changes

    • C. 

      Available disk storage space is limited

    • D. 

      The resulting QVD is used in multiple documents

  • 45. 
    The CEO, CFO, and Sales Manager need to use QlikView on a daily basis for comparative analysis. All three individuals need access all data. The company figures change rapidly, so the document needs to be reloaded twice a day. Which setup is most efficient?
    • A. 

      Three separate QlikView documents A server with two reload tasks for each document on a time schedule QVDs to set up an incremental load system

    • B. 

      One QlikView document A shared drive for the document with two partial reloads on Windows Scheduler Add Loads in the scrip

    • C. 

      One QlikView document A server with two partial reloads tasks on a time schedule Add Loads in the script

    • D. 

      One QlikView Document A server with two reload tasks on a time schedule QVDs to set up an incremental load system

  • 46. 
    A developer needs to concatenate data from multiple sources and know how many records exist in the resulting table. Which method should the developer use?
    • A. 

      Open the table viewer and hover over the table name to view the row count in the tool tip

    • B. 

      Create a text object and use the Count() function in an expression to specify a key field

    • C. 

      Use the RecNo() function in each load statement and use the maximum value

    • D. 

      Add a Statistics object that is set to a key field and select to show the Total Count

  • 47. 
    *** Refer to the exhibit. A department sells to different companies. A value is automatically generated in the transactional database to show how a company is to the department. When the department no longer sells to a particular company is real customer ID must remain in the database for historical and auditing reason. The country table only contains data that per… with value. The legacy report indicates that there are six companies with current sales. The data is loaded into QlikView through the script shown. Which value is returned when the function count(CustID) is run?
    • A. 

      6 (QlikView counts the number of items in the Country table because this was loaded first.)

    • B. 

      7 (QlikView counts all customers although the value is blank in one.)

    • C. 

      5 (QlikView does NOT count the customers where the value is zero or blank.)

    • D. 

      5 (QlikView only counts the number of distinct countries.)

  • 48. 
    Which type of QlikView key is described?All key value are unique,… NOT every value…
    • A. 

      Perfect Key // is Primary Key, unique and not null

    • B. 

      Primary Key // null value is allowed

    • C. 

      Secondary Key

    • D. 

      Key

  • 49. 
    A marketing application contains the following:
    • 10 tables to be loaded from SAP
    • 2 tables from a Oracle database
    Which method requires the minimum number of connections to the two databases and provides a correct result?
    • A. 

      Define the correct connection before each table is loaded

    • B. 

      Make an OLEDB connection to both DB systems before a table is loaded

    • C. 

      Define the connection each time tables is loaded from a different database

    • D. 

      Make an ODBC connection to both DB systems before an table is loaded

  • 50. 
    Depending on which sales representative has added an order to the ERP system, the delivery date is defined as D/MM/YYYY or M/DD/YYYY. How should a developer fix this data quality issue in QlikView?
    • A. 

      Date(Date([Date], 'D/MM/YYYY'), 'M/DD/YYYY')

    • B. 

      Date(Date#(Date#([Date], 'D/MM/YYYY'), 'M/DD/YYYY')

    • C. 

      Date#(Date(Date([Date], 'D/MM/YYYY'), 'M/DD/YYYY')

    • D. 

      This data quality issue can NOT be fixed

  • 51. 
    *** Refer to the exhibit. A developer is importing the Orders and Clients tables to perform geographical analyses. The tables show all available data. How many data quality issues are in these two tables?
    • A. 

      One

    • B. 

      Two

    • C. 

      Three

    • D. 

      Four

  • 52. 
    *** Refer to the exhibit. A developer needs to analyze the budget per department and the associated department manager. The developer pe…. Selects the fied 'Dep_Manger' as shown in the exhibit. When viewing the results, which data quality issue is discovered by the selection?
    • A. 

      The field 'Dep_ID' contains an error due to an incorrect auto-increment

    • B. 

      The field 'Region' shows only one imported value

    • C. 

      There is no Dep_Manager_ID

    • D. 

      There is a department (Dep_Name) without a manager

  • 53. 
    *** Refer to the exhibit. For performance reason, the fact tables (Invoices, InvoiceDetails, and Shipments) illustrated in the exhibit will be combined together as one table. When these tables are concatenated, which problem occurs?
    • A. 

      Invoice can get multiple dates

    • B. 

      InvoiceDetails are aggregated up to Invoice level

    • C. 

      Shipments are aggregated up to Invoice level

    • D. 

      When an InvoiceID is selected, only Dates from the Invoices are shown.

  • 54. 
    The CFO compares actual net profit with projected net profit to examine the performance of company divisions for each financial period. What should be the two dimensions? (Choose two)
    • A. 

      Financial Period

    • B. 

      Actual Net Profit

    • C. 

      Company Division

    • D. 

      Projected Net Profit

    • E. 

      User Role

  • 55. 
    *** Refer to the exhibit. A client has simple budgeting application on which a QlikView document is to be built. The structure of the data from both application is shown in the exhibit. When both tables are loaded, data is presented in the QlikView document. However, no value is present when a Office is selected. How should this issue be fixed?
    • A. 

      Concatenate the tables

    • B. 

      Rename Full Name to Sales Rep

    • C. 

      Apply a Dual format to the key

    • D. 

      Move Office and Region to the Budget table

  • 56. 
    *** A developer loads the result of a survey on a QlikView server...What is a likely reason for this result?
    • A. 

      X A null value is

    • B. 

      Blank num...

    • C. 

      A null value is automatically // nothingness is represented by the concept of NULL, i.e. a field value to show that there is no value assigned to the field in this record

    • D. 

      The Subset Ratio is 7% // shows the percentage of all distinct values

  • 57. 
    *** Refer to the exhibit. What can be determined from this entity relationship diagram?
    • A. 

      At least one record must exist in the Customers table.

    • B. 

      There must be more records in the Products table than the Sales Order Detail table.

    • C. 

      More records will always exist in the Sales Order Detail table than in the Sales Order table.

    • D. 

      SalesOrderLineId within the Sales Order Detail may be NULL

  • 58. 
    Refer to the exhibit. A developer loads the Order Lines into a QlikView document and creates a concatenated key from the OrderID and LineNo fields, use script:[OrderID] & '|' & [LineNo] as [OrderLineID] The developer then checks the statistics of the fields, as shown in the exhibit. The OrderLineID makes up more than half of the table size (238.536 / 451.882). The developer needs to reduce the space taken from OrderLineID. Which function meets the requirement?
    • A. 

      AutoNumber

    • B. 

      Num#

    • C. 

      Dual

    • D. 

      AutoNumber#

  • 59. 
    *** Refer to the exhibit. Based on this data model, which problem might occur?
    • A. 

      Employees can only view details for the customers of their sales.

    • B. 

      The budget can NOT be retrieved for customers who have NOT made a sale.

    • C. 

      Employees can NOT retrieve the budget per customer

    • D. 

      The budget is shown at the employee level instead of the customer level.

  • 60. 
    *** A Customer has a QlikView document to analyze Help Desk tickets. Each technician records various metrics about this issues, such as date opened, ticket type, severity, customer, status, and closed. The customer needs a chart to show the total number of Help Desk tickets open date and ticket status. What should be the dimensions for this chart?
    • A. 

      Open Date and Ticket Type

    • B. 

      Ticket Type and Date

    • C. 

      Open Date and Technician

    • D. 

      Ticket Status and Open Date

  • 61. 
    *** A company has 75 stores and needs a convenient way to distribute weekly inventory reports. Each store manager needs to be informed in inventory metrics and understand relevant KPIs. The managers do NOT perform detailed analysis, but need to review a summary of inventory measurements. The company has decided NOT to buy licenses for each store manager. With the developers's assistance, the Recovery team has created an Inventory Management application that contains the information that needs to be distributed. How would this information be distributed to the 75 store managers?
    • A. 

      Create a QlikView report that contains the key metrics. Use report banding to create a separate report section for each manager. Save the report as a PDF and e-mail the report to each store.

    • B. 

      Install the QlikView Analyzer client at each store location. The managers log on to the server with QlikView Analyzer, open the Inventory Management document, and review their KPIs and metrics.

    • C. 

      Set up a Publisher loop and reduce task to generate a separate Inventory Management QVW for each store. E-Mail the reduced QlikView Document to each store.

    • D. 

      Create a bookmark for each store in the inventory Management document. Each store manager logs in to Access Point and opens the Inventory Management document. The managers select the appropriate bookmark and review a dashboard for their KPIs and metrics.

  • 62. 
    *** Refer to the exhibit. Which three statements are true of this data model? (Choose three)
    • A. 

      A synthetic key table will result in improper associations

    • B. 

      Snowflake data models are appropriate as long as the associations produce correct results

    • C. 

      Many of these tables can be combined to create a more simple and efficient data model

    • D. 

      Unassociated tables can be contained in a data model for proper data results

    • E. 

      This model contains too many tables and should be simplified to focus on one area of the business

  • 63. 
    *** Refer to the exhibit.  Which two events happen after a reload? (Select two)Synthetic keys link tables that have more than one field in common. Circular loop (reference) means you have alternative paths between two tables.
    • A. 

      A synthetic key consists of the EmployeeID and Description fields // one column linked between two tables its create sythetic key

    • B. 

      A synthetic key consists of the TicketDate and HireDate fields

    • C. 

      A circular reference exists between the Helpdesk_Tickets, Employees, and Clients tables.

    • D. 

      A circular reference exists between the Helpdesk_Tickets, Clients, and Calendar tables.

    • E. 

      A circular reference exists between the Helpdesk_Tickets, Employees, and Calendar tables.

  • 64. 
    *** Refer to the exhibit. A client provides an entity relationship diagram to a developer and requests that the diagram be implemented in a QlikView document. Which of the following statements is correct?
    • A. 

      There must always be more records in the students table than the Customers table

    • B. 

      It is possible for TraininCourseId to be a NULL value

    • C. 

      There must be fewer records in the Customers table then the Training Courses table

    • D. 

      It is possible to have NO records in the Training Courses table

  • 65. 
    *** Refer to the exhibit. A developer loads a Products and Facts table. After the reload, a list box for OrderID and a list box for ProductName and a dashboard. When an OrderID is being selected, no ProductNames are associated. In the table viewer, the data model in the exhibit appears. Which two solutions fix the issue? (Select two)
    • A. 

      Create an alias for the field ProductID in the Products table

    • B. 

      Concatenate the two tables

    • C. 

      Create an alias for the field ProductPrice in the Facts table

    • D. 

      Qualify all fields in the Products table EXCEPT the field ProductID

    • E. 

      Join the two tables

  • 66. 
    **** Refer to the exhibit.  Which two statements are true regarding the Freight field? (Select two)
    • A. 

      Autocomplete in the expression editor will NOT work for the Freight field

    • B. 

      Freight can NOT be used as the dimension for any chart

    • C. 

      Freight will NOT appear in the list of fields

    • D. 

      Freight can only be used in an expression with a dollar expansion //dollar expansion is done first and then the expression is evaluated

    • E. 

      There are NO missing values for Freight