(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
Expert Answer
Buy This Answer $15
-- OR --
Subscribe $20 / Month