In this article i am gone to share Microsoft Azure for Data Engineering Week 1 | Test prep Quiz Answers with you..

Also visit:  Microsoft Azure for Data Engineering Week 3 | Course practice exam Quiz Answers

Microsoft Azure for Data Engineering Week 1 | Test prep Quiz Answers

Test prep Quiz Answers

Question 1)
Moving resources such as servers and services from an on-premises environment to a cloud-based solution will have a benefit on which of the following.

• Operational expenditure only
• Both capital and operational expenditure
• Capital expenditure only

Question 2)
Which of the following data processing frameworks are used by data engineers to ingest data from an on-premises database to an on-premises data warehouse?

• Extract, Transform, and Load (ETL)
• Online Transactional Processing (OLTP)
• Extract, Load, and Transform (ELT)

Question 3)
Unstructured data differs from Structured Data in many features.

Which of the following are features of Unstructured data? Select all options that apply.

• Schema-on-read.
• Schema-on-write
• Predefined format
• Commonly stored in data warehouses
• Native format
• Commonly stored in data lakes

Question 4)
Data Engineers may sometimes perform ETL process when processing data. The extract may come from many sources including databases, files, and streams. These data sources can have unique data formats including which of the following? Choose all that apply.

• Unstructured
• Partially structured
• Semi-structured
• Structured

Question 5)
The Extract Load and Transform (ELT) process has which of the following benefits. Select all options that apply.

• Data can be stored in its original format.
• Reduces the time required to load the data into a destination system.
• Data will be transformed prior to storage in the destination

Question 6)
A Data Engineers scope of work includes the process of getting, ingesting, transforming, validating, and cleaning up data to meet business requirements. Which of the following terms describe this process?

• Data Ranching
• Data Whaling
• Data Wrangling

Question 7)
Which data processing framework will a data engineer use to ingest data onto cloud data platforms in Azure?

• Online transaction processing (OLTP)
• Extract, transform, and load (ETL)
• Extract, load, and transform (ELT)

Question 8)
Data Engineers may sometimes perform ETL process when processing data. The extract may come from many sources including databases, files, and streams. As part of the Extract process which of the following information must be supplied?

Select all options that apply.

• Define the Data Source
• Define the Transformation
• Define the Data