Sample questions and answers

Try and answer the following questions:

1. Which one of the following tasks is the responsibility of the data engineer?
   1. Backing up and restoring databases
   2. Creating dashboards and report
   3. Creating pipelines to process data in a data lake
   4. Database maintenance
2. Which one of the following tasks is the responsibility of a database manager?
   1. Backing up and restoring databases
   2. Creating dashboards and reports
   3. Creating pipelines to process data in a data lake
   4. Machine learning development
3. Which role is most likely to use Azure Data Factory to define a data pipeline for an ETL process?
   1. Data engineer
   2. Data analyst
   3. Database manager
   4. Data scientist
4. Which single service would you use to implement data pipelines, SQL analytics, and Spark analytics?
   1. Azure Synapse Analytics
   2. Azure SQL Database
   3. Microsoft Power BI
   4. SQL Server
5. Which single service would you use to manage backups and restores on a SQL Server?
   1. SQL Server Management Studio
   2. Visual Studio
   3. A third-party vendor
   4. SQL backups...