[Free] 2017(Sep) Latesttests Pass4sure IBM C2020-180 V13 Dumps with VCE and PDF 41-50

Latesttests 2017 Sep IBM Official New Released C2020-180 V13
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/C2020-180 V13.html

IBM CognosBI Professional

Question No: 41

WhileCognos BIwill support any data warehouse design, which of the following designs doesCognos recommend for new warehouse development?

  1. Operational Data Store

  2. Dimensionally Modeled Relational

  3. Normalized Enterprise

  4. Dimensional Bus

Answer: D

Question No: 42

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 ofthe following is an advantage of this approach over reporting from an operational database?

  1. It is easier to understand because there are fewer summary tables.

  2. Specific reports for which the summary tables were created will run faster.

  3. It is easy to leverage many new reports from the summary tables.

  4. Over time summary tables often naturally group into business subject areas.

Answer: B

Question No: 43

Which of the following describes a disadvantage of using the dimensionally modeled relational(DMR) technique to access a normalized data structure?

  1. does not allow access to all relational items in Query and Report Studio

  2. may increase the time needed to fetch required data

  3. does not allow access to member functions

  4. may bypass aggregate aware tables

Answer: B

Question No: 44

All of the following describe design intent of an operational database EXCEPT:

  1. record the day to day operations of the company

  2. maximize the speed of inserts and updates to the database

  3. enhance reporting through foreign keys and indexes

  4. facilitate performing specific functional tasks

Answer: C

Question No: 45

Which of the following MOST clearly states the value of using a methodology?

  1. It provides a philosophy of development that maximizes return on investment.

  2. It helps consultants progress in a systematic way to insure all critical steps are addressed.

  3. It helps project managers estimate the cost and effort in developing a solution.

  4. It ensures that early mistakes are avoided in developing a solution.

Answer: B

Question No: 46

The partial diagram below is an example of what type of database schema design?

  1. star schema

  2. snowflake schema

  3. normalized schema

  4. de-normalized schema

Answer: B

Question No: 47

Which of the following describes an advantage of using the dimensionally modeled relational(DMR) technique to access a normalized data structure?

  1. eliminates the need for aggregate tables

  2. reduces the time needed to fetch the required data

  3. enables drill up/down functionality in reports and ad hoc queries

  4. enables creation of IQDs for creating Power Cubes

Answer: C

Question No: 48

Which of the following describes the design goals of a reporting database?

  1. provide fast access to corporate data for analysis and reporting

  2. provide near real time access to summarized corporate data for analysis and reporting

  3. provide fast access to corporate data and act as a system of record

  4. provide near real time access to summarized transactional data

Answer: A

Question No: 49

Which of the following describes how Cognos 8 works with aggregate aware tables in relationaldata sources?

  1. Cognos 8 can create aggregate aware tables within the database.

  2. Cognos 8 redirects its generated SQL to take advantage of aggregate aware tables.

  3. Cognos 8 does not make any specific adjustments for aggregate aware tables.

  4. Cognos 8 can monitor reports that are run and suggest aggregate aware tables.

Answer: C

Question No: 50

A table is in Third Normal Form if it is already in Second Normal Form, plus:

  1. All attributes are determined only by the primary key

  2. All attributes are determined by all segments of the primary key

  3. All foreign keys are determined by the primary key

  4. All surrogate keys are determined by the primary key

Answer: A

100% Free Download!
Download Free Demo:C2020-180 V13 Demo PDF
100% Pass Guaranteed!
Download 2017 Latesttests C2020-180 V13 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 Latesttests IT Certification PDF and VCE