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

WPC300

Quiz 7  Data/information architecture

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