QlikView QV_Developer_01 問題集

質問 1：
A customer has an Addresses table with the fields. CustomerNumber, CustomerName, AddressLine1, AddressLine2, City, StateCode, PostalCode, and CountryCode.
A designer needs to design a chart to show a count of distinct customers in which the customer's CountryCode is US or CA, while ignoring all selections on the Addresses table except the CustomerNumber and CustomerName fields.
How can the designer calculate the required value?
A. count({$<CountryCode={US, CA}, Addresses.*=>} distinct CustomerNumber)
B. count({$<CountryCode={US or CA}, AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>} distinct CustomerNumber)
C. count({$<(CountryCode={US} or CountryCode={CA}), AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>} distinct CustomerNumber)
D. count({1<CountryCode={US, CA}, CustomerName=CustomerName, CustomerNumber=CustomerNumber>} distinct CustomerNumber)
E. count({$<CountryCode={US, CA}, AddressLine1=, AddressLine2=, City=, StateCode=, PostalCode=>} distinct CustomerNumber)
正解：E

質問 2：
An Address Book table has a Country Code field. A standard lookup table exists in Excel to translate the Country Code to a Country description.
The Country Code will be US for any Address Book record with no Country Code value.
Which technique should a developer use to ensure a Country description is loaded for all Address Book records?
A. 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
B. load the Excel data as a Mapping table and use Applymap with a default mapping value when loading the Address Book table
C. load the Excel data and then load the Address Book data ensuring the Country Code field has the same name in both tables
D. load the Address Book records and perform a Left Join of the Excel data to the Address Book table
正解：B

質問 3：
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. 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
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. 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
正解：C

質問 4：
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 and then click the 'Connect' button
B. 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
C. 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
D. 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

質問 5：
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 the fields 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 and then unqualify all key fields
B. alias all primary key fields
C. left join the Customer data onto the Sales table
D. qualify all tables
正解：A