h*****g
发帖数: 944 | 1 1)Which of the following does NOT automatically initiate a delivery of
information (reports, spreadsheets, downloads to analytical tools) to an
end user?
A)Date/time
B)Stored procedure
C)Event
D)Condition
我选的D
2)A data warehouse database typically does NOT contain...
A)lightly summarized data.
b)data cubes.
c)highly summarized data.
d)reference data master tables.
我选的C
3)A data mart database typically does NOT contain...
a)user profiles
b)real-time transactional data
c)detail and summary data
d)etl procedures
我选的a
4)What audit function must be considered when designing a data warehouse?
a) number of end-user information requests
b) data warehouse content to source application content
c) sum of aggregated fact tables
d) total of indexed fields
我选的d
5)Which of the following is NOT a component of access security in a data
warehouse?
a)password management
b)fact table contents
c)dimension table values
d)database views
我选的c
大家看看我选的对不对啊 |
j*****n
发帖数: 1781 | 2 献丑一个，凭着直觉答的。问题还是蛮有意思的，大家讨论下哈。
1-B
SP is a program, itself does not provide any information to the end-user.
2-B
data warehouse database contains data; cubs are built on the top of DW.
3-B
data in data mart usually is populated via batch loads.e.g. once or few
times a day.
4-A
note the word "audit".
5-B
compare to B and C, my understanding is that fact table could only contained
tons of IDs that refer to PKs in DIM tables. |
v*****r
发帖数: 1119 | 3 第二题不是很清楚，其他跟你选的一样。
Cube 是不是做BI 的 tool 里用的？
【在 j*****n 的大作中提到】
: 献丑一个，凭着直觉答的。问题还是蛮有意思的，大家讨论下哈。
: 1-B
: SP is a program, itself does not provide any information to the end-user.
: 2-B
: data warehouse database contains data; cubs are built on the top of DW.
: 3-B
: data in data mart usually is populated via batch loads.e.g. once or few
: times a day.
: 4-A
: note the word "audit".
|
j*****n
发帖数: 1781 | 4 yap, many BI tools have the cube concept. such as SSAS.
【在 v*****r 的大作中提到】
: 第二题不是很清楚，其他跟你选的一样。
: Cube 是不是做BI 的 tool 里用的？
|
p*********d
发帖数: 136 | 5 Agreed to your answers.
【在 j*****n 的大作中提到】
: 献丑一个，凭着直觉答的。问题还是蛮有意思的，大家讨论下哈。
: 1-B
: SP is a program, itself does not provide any information to the end-user.
: 2-B
: data warehouse database contains data; cubs are built on the top of DW.
: 3-B
: data in data mart usually is populated via batch loads.e.g. once or few
: times a day.
: 4-A
: note the word "audit".
|
g*****g
发帖数: 29 | 6 The person who designed those questions is not expert on data warehouse. He
/She worked on OLTP system and shifted to data warehouse. Those are not
clear questions and not suitable selections. Don't really understand core
different between OLTP system and data warehouse. |
