Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

IBM COG-500 Exam -

Free COG-500 Sample Questions:

Q: 1
Which statement is correct about Business Keys?
A. Business Keys are optional for fact warehouse objects.
B. Business Keys are optional for dimension warehouse objects.
C. Business Keys are optional for dimension warehouse objects that are not involved in any references.
D. Business Keys are mandatory for fact and dimension warehouse objects.
Answer: D

Q: 2
A warehouse provides reporting on Sales Amounts tracked by Month, Product, Rep, and Customer; and Demand Forecasts tracked by Month and Product. There is a need to produce a report that shows Sales Amount and Demand Forecast by Product and Month.Which warehouse design meets these requirements with minimal redundant data storage?
A. separate facts (Sales and Demand Forecast) with conformed Time and Product Dimensions.
B. a single fact at the grain of Sales with Demand Forecasts stored in the same fact, stored against a default Rep and Customer
C. a single fact at the grain of Sales with Demand Forecasts stored in the same fact allocated between Reps and Customers
D. separate facts (Sales and Demand Forecast) with a reference between the two facts Answer: A

Q: 3
A data warehouse keeps track of sales by employee. Employees are rolled up by sales office. Each employee operates from one and only one sales office. Employee items (e.g., employee name) and sales office items (e.g., region) are Type 1 attributes. Sales office and employee information will be loaded from two different data sources that contain a conformed sales office ID key. The warehouse design must make provisions for changed data capture for Sales, Employee, and Sales Office information. You are asked to create a warehouse model that minimizes the number of table joins required when querying Sales by Employee, and Sales Office. Which design meets these criteria?
A. Sales Fact only; all dimension information is denormalized onto the fact.
B. Sales Fact with reference to single Employee dimension; Sales Office items are denormalized onto the Employee dimension.
C. Sales Fact with reference to Employee dimension; Employee dimension with reference to Sales Office snowflake dimension.
D. Sales Fact with reference to Employee Location dimension; Employee Sales Office dimension has one snowflake reference to Employee dimension and another snowflake reference to the Sales Office dimension.
Answer: C

Q: 4
What are two ways of defining the source of a Warehouse Object item in the Input Source Manager window? (Choose two.)
A. mapping to a Query Subject Item in the Source Framework Manager model
B. calling an external procedure
C. embedding a calculation into the mapped item
D. mapping to a Query Subject Item in a Lookup Transformation
Answer: A, C

Q: 5
A report developer wants to use Report Studio to create some ad-hoc reports with the Adaptive Warehouse (AW) generated package. The developer inserts the Sales Amount field from the Order Activity fact then the Employee Name from the Employee dimension. When the developer previews the report, the report prompts for a Dimension Perspective.Why did this prompt appear?
A. The Employee Name field was selected from the model Query Subject instead of the Dimension.
B. There is no relationship defined between the two objects.
C. AW generates a model filter in the dimension to filter the fact data on ALL_TIME.
D. The Warehouse Object Item Employee Name is marked as type History.
Answer: D

Q: 6
So that the nightly load of data into the warehouse can be run on an automatic schedule, a single script is created to synchronize the database, synchronize and publish the Framework Manager models, and load the dimensions and facts.Which three cases would require that a new script be created to ensure that the warehouse is updated correctly? (Choose three.)
A. A hierarchy is added to a dimension query subject in the target model.
B. A new dimension warehouse object is created with a reference to a fact.
C. A dimension item of type attribute is deleted from the warehouse model.
D. The Cognos 8 signon to the warehouse for the user who created the script is removed.
E. A data flow is added to a dimension.
Answer: B, D, E

© 2014, All Rights Reserved