An Interest In:
Web News this Week
- April 20, 2024
- April 19, 2024
- April 18, 2024
- April 17, 2024
- April 16, 2024
- April 15, 2024
- April 14, 2024
Important Questions related to Data Engineering
Can a database be used as DWH?
Yes, Database can be used as a Data Warehouse. Even before the data warehouse, we use database for the business. But now it's a good practice to use Data warehouse because of quick response and Analystical tools. Data warehouse is based on specific category thatswhy, we get quick response as compared to Database.
Difference between structured and UN structured data ?
Structured Data:
Is in the form of structured manner, it can be a SQL query or a script that we run on terminal of any platform to perform task is considered as structured data. This data is in uniform format.
Unstructured Data:
This data is in distributed manner. It is in scattered formed. This data contains text file, video, image, audio etc.
Roles of Data Engineer :
- Design and develop databases, data models and tables to store data.
- Develop ETL processes and data pipelines for data integration.
- Monitor and optimize database performance.
- Analyze data for patterns, trends, and insights.
- Develop data visualizations and dashboards.
- Troubleshoot data-related issues.
- Implement security and privacy measures.
- Collaborate with data scientists and business stakeholders.
- Build API connection to fetch the data from the source target to the destination target.
Original Link: https://dev.to/zapeeosheikh/important-questions-related-to-data-engineering-33on
Dev To
An online community for sharing and discovering great ideas, having debates, and making friendsMore About this Source Visit Dev To