Have a Question ?

Home / Answered Questions / WPC 300 / wpc-300-quiz-7-data-information-architecture-q-827

(Solved): WPC 300 Quiz 7: Data/information architecture...


WPC300

Quiz 7  Data/information architecture

  • Points 20
  • Questions 10

Attempt History

Question 1

2 / 2 pts

You are creating a database to store temperature and wind data from various airport. Which of the following fields is the most likely candidate to use as the basis for a Primary Key in the Airport Table?

  •   City
  •   AddressCorrect!
  •   Airport code 
  •   State

Question 2

2 / 2 pts

Which of the following is not a component of relational database?

  •   Relationship among rows in tables
  •   Metadata 
  •   Tablesorrect!
  •   CPU of Database Server 

Question 3

2 / 2 pts

Which of the following is true focus of Information Architecture?Correct!

  •   Making all information easy to find
  •   Make only irrelevant information easy to find
  •   Deliver information to the client where there is a misunderstanding
  •   Make the information hard to find 

Question 4

2 / 2 pts

The SQL code to extract only departure time information for all records of the following "Flight" table is:

  •   SELECT * FROM Flight;
  •   SELECT Flight # FROM Departs;rrect!
  •   SELECT Departs FROM Flight;
  •   SELECT * FROM Flight WHERE To = "LGA (New York City)";

Question 5

2 / 2 pts

Which of the following tools help in periodic managerial decision-making?

  •   Database Correct!
  •   OLAP
  •   Servers 
  •   OLTP

Question 6

2 / 2 pts

When you access information from two different tables connected by an identifier key, the SQL keyword you should use is ____________.

  •   COUNT
  •   ORDER BY
  •   GROUP BY orrect!
  •   INNER JOIN

Question 7

2 / 2 pts

Which of the following is a cloud service provider?

Correct!

  •   VMWare 
  •   Dropbox
  •   iCloud 
  •   Gmail

Question 8

2 / 2 pts

Which of the following is an important task of a database management system?

  •   Provides unauthorized access to data when authentication fails
  •   Provides support such as performing maintenance and routine backups.ounswered
  •   Helps create rules for data analysis
  •   Helps collect data from vendors

Question 9

2 / 2 pts

When are asked to design a database for airline ticket reservation system, based on an Entity Relationship Data model, which of the following could be an example of "entity"?

  •   Arrival time
  •   Destination cityCorrect!
  •   Traveler
  •   Flight Number

Question 10

2 / 2 pts

Which of the following is not a traditional data architectural process?Correct!

  •   Visual 
  •   Physical 
  •   Conceptual
  •   Logical

 

 



We have an Answer from Expert View Expert Answer

Expert Answer


We have an Answer from Expert
Buy This Answer $15

-- OR --

Subscribe To View Unlimited Answers
Subscribe $12 / Month