The purpose of a data warehouse is to ________. A) standardize ...

[newyorker26]

The purpose of a data warehouse is to ________.
 
  A) standardize the format of data retrieved from different systems
  B) allow managers to run queries and reports themselves without having to know query languages or the structure of the underlying data
  C) provide capabilities for discovering hidden predictive relationships in the data
  D) put key business information into the hands of more decision makers
  E) increase the complexity of the data to be analyzed

Question 2

In Microsoft Access, the statement used to calculate the number of clients from each NH zip
  code, labeled Zip Clients, would be which of the following?
 
  A) Select ZipCode, Count(Email) As 'Zip Clients' From Client Group By ZipCode Where
  State Is 'NH'
  B) Select ZipCode, Count(Email) As 'Zip Clients' From Client Group By ZipCode Where
  State = 'NH'
  C) Select ZipCode, Count(Email) As 'Zip Clients' From Client Group By ZipCode
  D) Select ZipCode, Count(Email) From Client Group By ZipCode Where State = 'NH'

[izzat]

Answer to Question 1

D

Answer to Question 2

B

[newyorker26]

Thanks for the timely response, appreciate it

[xiazhe]

Great answer, keep it coming