IBM C2020-180 問題集

質問 1：
Which of the following describes the design goals of a reporting database?
A. provide near real time access to summarized corporate data for analysis and reporting
B. provide fast access to corporate data and act as a system of record
C. provide fast access to corporate data for analysis and reporting
D. provide near real time access to summarized transactional data
正解：C

質問 2：
The V-Model testing process specifies that developers should both verify and validate each test. Which of the following describes how developers would validate their tests in the design step of the V-model?
A. Check the design against the business requirements.
B. Check the design by conducting an assembly test.
C. Check the design by conducting a component test.
D. Check the design against the developed components.
正解：A

質問 3：
Which of the following describes common methods for enriching an initial dimension map?
A. Include additional metrics and calculations and core metrics and dimensions from related business areas.
B. Include additional metrics, calculations, and hierarchy levels, and dimensions from related subject areas.
C. Add exception and range band dimensions and include additional metrics and calculations.
D. Merge dimensions andinclude additional metrics and calculations.
正解：C

質問 4：
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. Average Sales
B. Discount Amount
C. Unit Cost
D. Sales Variance
正解：D

質問 5：
Which of the following is a significant cause of failure when using the technology-focused approach to BI Application development?
A. New technology often contains internal flaws and errors that affect the delivered solution.
B. Developers often focus on just the data.
C. Users often have difficulty understanding new technology.
D. The solution is focused on a single subject area.
正解：B

質問 6：
Which of the following is a critical component in delivering Corporate Performance Management throughout an enterprise?
A. Drill across from one subject area to another through conformed dimensions.
B. Drill down from summary to detailed information within individual subject areas.
C. Event management designed to monitor the status of Key Performance Indicators.
D. Star schema data marts designed to facilitate analysis and reporting.
正解：A

質問 7：
Companies often create a collection of summary tables as their first attempt at a data warehouse. While there are several drawbacks to this approach, there are also some advantages. Which of
the following is an advantage of this approach over reporting from an operational database?
A. It is easy to leverage many new reports from the summary tables.
B. It is easier to understand because there are fewer summary tables.
C. Specific reports for which the summary tables were created will run faster.
D. Over time summary tables often naturally group into business subject areas.
正解：C