Which of the following describes Key Performance Indicators (KPI)?
A. Strategic goals, typically specified by executives, which describe the direction and objectives of the organization.
B. Industry standards by which organizations measure themselves against others in their market space.
C. Core, atomic level data items that provide input into higher level derived items which then appear on scorecards.
D. Specific metrics, usually derived, by which a company measures its progress and success.
正解:D
質問 2:
A user makes the following request:"I need to see actual sales compared with projected sales, and margin range for branches within each division, by product line, sales rep by sales manager, and cost center over time." Based on the user's request, Actual Sales and Projected Sales have been identified as required measures. Which of the following other measures would be included in an initial dimension map?
A. Sales Variance
B. Discount Amount
C. Unit Cost
D. Average Sales
正解:A
質問 3:
All of the following describe design intent of an operational database EXCEPT:
A. enhance reporting through foreign keys and indexes
B. maximize the speed of inserts and updates to the database
C. facilitate performing specific functional tasks
D. record the day to day operations of the company
正解:A
質問 4:
After a BI application is placed into production, all of the following are considered part of the process to prepare for the next iteration of the application, EXCEPT:
A. communicate with users to insure the application is delivering value
B. enhance application documentation to reflect errors and omissions
C. periodicallyre-apply the V-test model against the developed components
D. record and track enhancement requests
正解:C
質問 5:
A user makes the following request:"I need to see the number of flights throughout the year that arrived or departed more than 15 minutes early or late by origin and destination airport, by carrier, and by time of day. I want to see if the number of flights delayed is greater for large carriers or small carriers."This request requires clarification to make the user's intention clear. Which of the following will NOT further clarify the user's request?
A. Determine if origin and destination airports should be considered joined pairs (for example, from DFW to ORD) or as separate dimensions.
B. Determine the definition of a large and small carrier.
C. Determine if Date and Time of Day should be split into separate dimensions.
D. Determine if 15 minutes is the only significant grouping of late or early departures or arrivals.
正解:C
質問 6:
A consultant realizes after determining business requirements, that a complete solution will require several related but separate projects. The consultant must choose one project to deliver first. Which of the following describes the considerations that should govern that choice?
A. Priority of IT, ease of development, resource availability, and data availability
B. Business impact, ease of development, resource availability, and number of target users
C. Business impact, data availability,ease of development, and resource availability
D. Data availability, ease of development, resource availability, and position of project sponsor in the organization
正解:C
質問 7:
The partial diagram below is an example of what type of database schema design?
A. de-normalized schema
B. star schema
C. snowflake schema
D. normalized schema
正解:C
播磨** -
識もしっかりと身につくと思います。Pass4Testの商品はどれも優秀すぎます。私は1日4時間を3日で合格できました。