Data warehousing Security

Data warehousing Security

1) Which activities get affected by security measures.
A) User access
B) Data load and Data movement
C) Query generation
D) All mentioned above
View Answer / Hide Answer


2) Adding security features affect the performance of the data warehouse, therefore it is important to determine the security requirements as early as possible.
A) True
B) False
View Answer / Hide Answer


3) Is it easy to add security features after the data warehouse has gone live.
A) Yes
B) No
View Answer / Hide Answer


4) Network security is as important as other securities. We cannot ignore the network security requirement. Which of the following issues considered?
A) Is it necessary to encrypt data before transferring it to the data warehouse?
B) Are there restrictions on which network routes the data can take?
C) Both A & B
D) None of the above
View Answer / Hide Answer


5) Testing the data warehouse is a complex and lengthy process. Adding security to the data warehouse also affects the testing time complexity.
A) True
B) False
View Answer / Hide Answer


6) Adding security to the data warehouse also affects the testing time complexity. It affects the testing in which way from the following?
A) It will increase the time required for integration and system testing.
B) There is added functionality to be tested which will increase the size of the testing suite.
C) Both A & B
D) None of the above
View Answer / Hide Answer


7) A separate security document is required for security testing. This document contains a list of disallowed operations and devising tests for each.
A) True
B) False
View Answer / Hide Answer


8) Auditing is a subset of security, a costly activity. Auditing can cause heavy overheads on the system.
A) True
B) False
View Answer / Hide Answer


9) Audit requirements can be categorized as follows:
A) Connections and Disconnections
B) Data access and Data change
C) Both A & B
D) None of the above
View Answer / Hide Answer


10) The audit and security requirements need to be properly documented. This will be treated as a part of justification.
A) Yes
B) No
View Answer / Hide Answer


11) Adding security features affect the performance of the data warehouse, therefore it is important to determine the security requirements as early as possible.
A) True
B) False
View Answer / Hide Answer


12) When the data is loaded into the data warehouse, what are the questions raised?
A) Where is the flat file stored?
B) Who has access to that disk space?
C) Who has access to tapes?
D) Both A & B
E) Both B & C
View Answer / Hide Answer