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

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