This topic contains a solution. Click here to go to the answer

Author Question: The purpose of a data warehouse is to ________. A) standardize the format of data retrieved from ... (Read 101 times)

newyorker26

  • Hero Member
  • *****
  • Posts: 536
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'



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

izzat

  • Sr. Member
  • ****
  • Posts: 328
Answer to Question 1

D

Answer to Question 2

B




newyorker26

  • Member
  • Posts: 536
Reply 2 on: Jul 7, 2018
:D TYSM


jordangronback

  • Member
  • Posts: 339
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

Stevens-Johnson syndrome and Toxic Epidermal Necrolysis syndrome are life-threatening reactions that can result in death. Complications include permanent blindness, dry-eye syndrome, lung damage, photophobia, asthma, chronic obstructive pulmonary disease, permanent loss of nail beds, scarring of mucous membranes, arthritis, and chronic fatigue syndrome. Many patients' pores scar shut, causing them to retain heat.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

Blastomycosis is often misdiagnosed, resulting in tragic outcomes. It is caused by a fungus living in moist soil, in wooded areas of the United States and Canada. If inhaled, the fungus can cause mild breathing problems that may worsen and cause serious illness and even death.

Did you know?

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

Did you know?

The modern decimal position system was the invention of the Hindus (around 800 AD), involving the placing of numerals to indicate their value (units, tens, hundreds, and so on).

For a complete list of videos, visit our video library