From the course: Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Cert Prep by Microsoft Press
Unlock this course with a free trial
Join today to access over 25,500 courses taught by industry experts.
Quiz
Welcome to the Lesson 7 quiz, in which there are three questions to test your knowledge. Question 1. Which data store would you choose if the criteria were T-SQL, structured data and multi-table transaction support? A, Lakehouse, B, Warehouse, C, Event House, or D, SQL Database? Pause the video for a few seconds and have a think. Let's see what the answer is. The Warehouse B. Supports all three of those criteria. Question 2. What type of data transformation is the following PySpark code performing? Df.withColumn CustomerNameUpper upper Col. CustomerName A. Changing the data type B. A datetime manipulation C, String Manipulation, or D, Conditional Logic? Pause the video for a few seconds to think. Let's see what the answer is. It's performing a string manipulation. It's transforming that customer name into uppercase. So the answer is C. And question three. What type of table would you store surrogate keys and business keys? A. A fact table. B. A raw table. C. A dimension table. Or D. A…
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Learning objectives35s
-
(Locked)
Choosing between a lakehouse and a warehouse for data storage4m 39s
-
(Locked)
Transforming data using Power Query, PySpark, KQL, and T-SQL6m 37s
-
(Locked)
Creating and managing lakehouse shortcuts5m 34s
-
(Locked)
Creating and managing mirroring5m 46s
-
(Locked)
Using pipelines to ingest data3m 17s
-
(Locked)
Ingesting data by using continuous integration from OneLake2m 19s
-
(Locked)
Designing a dimensional model8m 9s
-
(Locked)
Grouping and aggregating data6m 11s
-
(Locked)
Handling duplicate, missing, and late-arriving data5m 30s
-
(Locked)
Quiz2m 25s
-
(Locked)
-
-
-
-
-
-