CDW110 Exam Questions and Answers 100% Pass

CDW110 Exam Questions and Answers
100% Pass


What is Caboodle? -

CORRECT ANSWER: A data warehouse, designed to store Epic and

non-Epic data in a unified data model for efficient reporting




QUESTION: Caboodle staging database -

CORRECT ANSWER: Data is transformed, checked for referential

integrity, and cleaned




QUESTION: Caboodle reporting database -

CORRECT ANSWER: Comes from the staging database and is used by

caboodle report writers to write reports




QUESTION: SSIS Packages -

,CORRECT ANSWER: SQL Server Integration Services. The

mechanism used to move data during the caboodle ETL process




QUESTION: True or false: your organization can create custom SSIS

packages to extract Clarity data or additional data sets -

CORRECT ANSWER: True




QUESTION: Schema -

CORRECT ANSWER: A collection of database objects




QUESTION: dbo schema -

CORRECT ANSWER: Stores reporting data and acts as the data

source for SlicerDicer




QUESTION: FullAccess Schema -

CORRECT ANSWER: Everything for report writers from the dbo

schema and more

, QUESTION: FilteredAccess Schema -

CORRECT ANSWER: Similar to FullAccess, but results are filtered

based on user security




QUESTION: Which schema should be the default schema for

reporting? -

CORRECT ANSWER: FullAccess




QUESTION: How to see what schema is being used for reports? -

CORRECT ANSWER: SELECT SCHEMA_NAME()




QUESTION: Which Cogito tools query from Caboodle? -

CORRECT ANSWER: Mainly SlicerDicer, but also certain custom

Radar metrics and Workbench templates