Caboodle Exam Study Set
A ComboKey is used as a lookup column to which of the subsequent types of DMCs?
Choose best one.
A. DataMart
B. SetDim
C. Dimension
D. AttributeValueDim
E. Fact
F. Bridge - ANS-F. Bridge
Epic recommends the usage of which schema because the default schema for file writing?
Choose one or all that follow.
A. Dbo schema on staging database
B. Dbo schema at the reporting database
C. Epic schema on both database
D. FullAccess schema on the reporting database - ANS-D. FullAccess schema on the
reporting database
Fact tables usually have extra _______ than measurement tables have. Choose one
solution.
A. Primary key columns
B. Durable key columns
C. Lookup columns
D. Columns - ANS-C. Lookup columns
How are you able to inform if a column is a lookup column in Caboodle? Choose all that
practice.
A. The column is marked as picture
B. The ER diagram lists the column and what table it joins to.
C. The column is contained in a fact desk.
D. The column will lead to Key however no longer be the number one key of the table. -
ANS-B.T he ER diagram lists the column and what desk it joins to.
D. The column will end in Key but now not be the number one key of the table.
Explanation: Lookup columns join to different tables and are effortlessly spotted in
Caboodle's documentation.
If the number one key of a row in a truth table is -1, then ... Choose all that follow.
A. The lookup columns will save -1.
B. The lookup columns will keep '*Unspecified'.
C. The lookup columns will keep '*unknown'.
D. Columns with a statistics kind of varchar will shop '*Unspecified'.
E. Columns with a records sort of Date Time will shop '1979-01-01'. - ANS-A. The research
columns will shop -1.
A ComboKey is used as a lookup column to which of the subsequent types of DMCs?
Choose best one.
A. DataMart
B. SetDim
C. Dimension
D. AttributeValueDim
E. Fact
F. Bridge - ANS-F. Bridge
Epic recommends the usage of which schema because the default schema for file writing?
Choose one or all that follow.
A. Dbo schema on staging database
B. Dbo schema at the reporting database
C. Epic schema on both database
D. FullAccess schema on the reporting database - ANS-D. FullAccess schema on the
reporting database
Fact tables usually have extra _______ than measurement tables have. Choose one
solution.
A. Primary key columns
B. Durable key columns
C. Lookup columns
D. Columns - ANS-C. Lookup columns
How are you able to inform if a column is a lookup column in Caboodle? Choose all that
practice.
A. The column is marked as picture
B. The ER diagram lists the column and what table it joins to.
C. The column is contained in a fact desk.
D. The column will lead to Key however no longer be the number one key of the table. -
ANS-B.T he ER diagram lists the column and what desk it joins to.
D. The column will end in Key but now not be the number one key of the table.
Explanation: Lookup columns join to different tables and are effortlessly spotted in
Caboodle's documentation.
If the number one key of a row in a truth table is -1, then ... Choose all that follow.
A. The lookup columns will save -1.
B. The lookup columns will keep '*Unspecified'.
C. The lookup columns will keep '*unknown'.
D. Columns with a statistics kind of varchar will shop '*Unspecified'.
E. Columns with a records sort of Date Time will shop '1979-01-01'. - ANS-A. The research
columns will shop -1.
