QV_Developer_01最も有効な質問と解答で勉強

Refer to the exhibit to the right.

When the script displayed in the exhibit is reloaded, an error message is displayed.
Table not found
Left Join (SalesPerson)
LOAD ID,
DepartmentID
FROM
[DataSourceA.xlsx]
(ooxml, embedded labels, table is SalesPersonDepartment);
What is the likely cause of the error?

• A. The Left Join statement fails to correctly quote the referenced table name, such as Left Join ("SalesPerson").
• B. When loaded, the SalesPerson table is auto concatenated to Customer and does not exist when referenced.
• C. There is an error in the Customer table load and it is not created in memory.
• D. The Left Join statement fails to correctly bracket the referenced table name, such as Left Join ([SalesPerson]).

A customer needs a better understanding of inventory trends over time. However, the source database contains only the current product inventory levels.
Which technique will take advantage of QlikView capabilities to meet the customer's needs?

• A. using a QVD file to store an accumulation of periodic snapshots from the source database
• B. using a QVX file to store an accumulation of periodic snapshots from the source database
• C. using a QlikView script to store an accumulation of periodic snapshots to a table in the source database
• D. using a QlikView script to store an accumulation of periodic snapshots to an XML file

A customer's data set contains information for multiple departments.
The customer needs a document to show only one specific department when a user first accesses the application.
Which trigger and action will meet the requirement?

• A. trigger. OnPostReload; action. Lock Field
• B. trigger. OnSelect; action. Select in Field
• C. trigger. OnOpen; action. Set Variable
• D. trigger. OnOpen; action. Select in Field

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

Refer to the exhibit to the right.

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

• A. The longest Fax value is 76 percent of the assigned field length.
• B. On average, 76 percent of the Fax field values are non-spaces.
• C. The Fax field has 76 percent incomplete/invalid fax numbers.
• D. The Fax field has blanks for 24 percent of the records.
• E. The Fax field has NULL values for 24 percent of the records.