DP900 basic questions
1. In structured data, what are data entity, instances of the entity and attributes of the entity ?
2. Is structured data must be stored in relational databases ?
3. Are JSON and XML just for semi-structured data ?
4. Which date format stores data in binary ?
5. In Relational database, what is primary key and foreign key?
6. What is ACID ?
7. What is a transaction ?
8. Is NoSQL doesn't use SQL ?
9. What is Horizontal scaling and Vertical scaling ?
10. Can we say for the OLAP system the data will be from OLTP ?
11. Can a NoSQL database be used for relational data ?
12. Non-relational data refers to NoSQL databases that can store structured, semi-structured, and unstructured data ?
13. IaaS, PaaS, SaaS
14. Can batch processing output data to a relational databse and to an non relational database ?