short answers will suffice 1)What is a data warehouse? How does it differ from a
ID: 3828278 • Letter: S
Question
short answers will suffice
1)What is a data warehouse? How does it differ from a database? What are data marts?
2)Please explain what prototyping is, some of its benefits and the types of software prototypes
3)Which of the following options will not help you to maintain the database security?
Follow principle of least privilege
Use Default passwords
Collect only the data needed
Keep data only as long as needed
4)
Which of the following statements is not true about three-tier architecture for database-driven websites?
SQL statements are processed on the server
SQL statements may be processed on some of the clients
Business logic may be processed on the server
A back-end database manages and provides access to the data.
a)Follow principle of least privilege
b)Use Default passwords
c)Collect only the data needed
d)Keep data only as long as needed
Explanation / Answer
3) option b is the answer
default passwordsare easily traceable and hence the data can be compromised.
4) option b is the answer
SQL statements that have database access should not be executed on client side to ensure code confidentiality.
1) A datawarehouse is a data storage that is not used for daily transacting operations on data. it is used to store the data permanently. A database is a data storage on which day-to-day transactions are done. A datawarehouse stores data for auditing,reporting and analytical purposes.
Normally database means a OLTP(Online transaction processing) database. whereas, OLAP(Online Analytical Processing) is a analytical database.
2) Software prototyping is the process of creating prototypes of a software.
Where a prototype is used to simulate the features and behaviour of a software by representing things like GUI interactivity,main functionality,etc.
Hence ,a prototype can be used to evaluate a software to some extent before development and improvements can be incorporated. The evaluation is done mainly based on the User Experience(UX) now-a-days.
A client can also check whether his requirements are being addressed or not.
Types of Prototypes :
- Throwaway
- Incremental
- Evolutionary
- Extreme
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.