QlikView 11 Developer Certification Examination 認定 QV_Developer_01 試験問題:
1. Which chart should a designer use to display orders, sales, and average order value grouped by year, quarter, region, product, and salesperson?
A) Pivot Table
B) Mekko Chart
C) Grid Chart
D) Bar Chart
E) Straight Table
2. A customer has multiple bar charts comparing different metrics. All charts contain a single Expression all with the Dimension CustomerID.
The charts are sorted by Y-Value Descending. Some Customers have Y-Values of zero for some metrics and not others.
How can the designer show the same color bar for a single CustomerID in all the charts?
A) Properties > Colors and then define colors 1 - 6 with specific RGB values
B) Properties > Presentation and then define the Error Bars colors with a specific RGB value
C) Properties > Colors and then check the Multicolored and Persistent Colors checkboxes
D) Properties > Visual Cues and then set the Upper and Lower colors using specific RGB values
3. Refer to the exhibit below.
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 loosely coupled tables in the data model.
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 a relationship between all the tables without synthetic key tables or loosely coupled tables.
4. 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 Alt function with different Date# functions
C) use the Date function to format the field during load
D) use the Lookup function with a format table
5. Refer to the exhibit to the right.
A customer has two databases containing employee data for different regions.
Based on the script displayed in the exhibit, what will be the resulting table schema?
A) one table named Employees_US
B) one table named Employees_UK
C) two tables named Employees_US and Employees_UK with no associations
D) two tables named Employees_US and Employees_UK with a synthetic key
質問と回答:
質問 # 1 正解: A | 質問 # 2 正解: C | 質問 # 3 正解: A | 質問 # 4 正解: B | 質問 # 5 正解: A |