Activity
Mon
Wed
Fri
Sun
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
What is this?
Less
More
Memberships
Learn Microsoft Fabric
Public • 5.3k • Free
Fabric Dojo 织物
Private • 198 • $39/m
45 contributions to Learn Microsoft Fabric
Sep 16 in
Exciting News: I Cleared the DP-600 Exam! Here's How I Did It
I’m thrilled to share that I recently passed the DP-600 certification exam, and I want to share my journey to help others in the community who are also preparing for it. I hope my experience provides you with some helpful insights and inspires you to reach your own goals! Here’s what worked for me: 1. Microsoft Learn Portal: This was my go-to resource. I focused on completing the DP-600 study guide, which includes excellent lab exercises that reinforce the core concepts. It’s incredibly hands-on! ➡️ Microsoft Learn - DP-600 Guide 2. Will Needham's YouTube Videos: Will's videos were game-changers for me. His in-depth explanations of the core concepts and exam structure really helped clarify things. His exam-focused approach made the difference in my preparation. ➡️ Will Needham's DP-600 Playlist 3. Skool Community Portal: To dive deeper into specific topics, I turned to the Skool Community portal. It’s a great place to further understand concepts covered in Will's videos and to get additional resource support. ➡️ Skool Community Portal - Microsoft Fabric 4. Microsoft Practice Test: The practice test on Microsoft Learn was invaluable in gauging my understanding and readiness for the exam. ➡️ Microsoft Practice Test 5. MeasureUp Practice Test: I invested in a 30-day subscription to MeasureUp’s practice tests, and it was worth every penny. The detailed explanations for each question helped me identify areas where I needed more study. I took the test 2-3 times to solidify my knowledge. 6. Microsoft Exam Readiness Zone Videos: After covering all the above, I watched the exam readiness zone videos to understand the overall exam objectives. These videos helped me review the key topics right before taking the exam. ➡️ Exam Readiness Zone
17
12
New comment Sep 25
0 likes • Sep 20
@Will Needham That's correct. I took mine today and it did have some KQL stuff on it Basic stuff that's equivalent in SQL to SELECT col1 From table1 and how to do an aggregation. It is interesting that it's on the renewal when it's not mentioned whatsoever on the exam but there were a few additional things that were new on that outside of it as well. I think they use the renewals to test new questions for future content/updates somewhat.
Jul 10 in
Can Fabric shortcut to Azure Blob Storage?
half a year ago, Fabric was only able to shortcut to ADLS gen2(ABFSS) but not to Azure Blob Storage (WASBS), is it still the same? has anyone got experience on this? Thanks guys.
1
9
New comment Aug 20
2 likes • Jul 10
I tested and it will not allow this even if you use a dfs endpoint. It just fails.
0 likes • Aug 19
@Tomasz Staroszczyk All you need is this https://storageaccount.dfs.core.windows.net/ I'm not sure if you're able to connect to his data lake. He might have referred to it as public data in that Microsoft gives you access to that data to play around with But trying to connect to that storage account with your organizational credentials is not going to work unless you are in the Microsoft tenant and have been given sufficient RBAC roles to access that specific storage with those credentials. A SAS token would have to be generated by someone with access and getting the account key would not be wise by whomever owns that. Thus, I don't think you can access this specific account unless somewhere else in that video he gives information around the SAS token.
Aug 13 in
Ingest nested JSON to Lakehouse tables
Hello! I am trying to ingest the below JSON file into (two) tables in a Lakehouse. https://www.kaggle.com/datasets/aditeloo/the-world-dataset-of-covid19?resource=download&select=owid-covid-data.json I was trying to test Pipelines and PySpark notebooks on this task. This file is less than 50 MB, so it is fairly small. 1) Pipeline cannot handle (preview) this file as a source. I have attached two screenshots showing the error. 2) This file is fairly simple, however, its data is nested. It has countries (Dimension table), and for each country, it has daily covid cases (Fact table). This means I can attempt to load "Dim Country" and "Fact Covid" tables using PySpark. However, due to the structure of the json file, it appears that this file does not fit nicely in a Spark Data Frame. Each country code appears as a column in the Spark Data Frame instead of a row. I am looking for ways to get two Data Frames, one for "Dim Country" and another for "Fact Covid", to be saved as Delta tables in the Lakehouse. I have added two screenshots. I am keen to hear feedback from other users and if someone can try to load this file and guide me in the right direction, I am very grateful.
1
20
New comment Aug 17
1 like • Aug 14
@Surm Man If you're still looking for a way to read this. from pyspark.sql.functions import explode, col df = spark.read.option("multiline", "true").json("Files/JSON/owid-covid-data.json") flattened_df = df.select( col("AFG.continent"), col("AFG.location"), col("AFG.population"), explode(col("AFG.data")).alias("data") ).select( col("continent"), col("location"), col("population"), col("data.date"), col("data.total_cases"), col("data.new_cases"), col("data.stringency_index") ) display(flattened_df) Hope that helps and gets you further along.
1 like • Aug 14
@Surm Man probably not This was a more simple way to start viewing this in spark quickly without having to write a bunch of Python. Some of the .py files earlier in this thread contain better logic for parsing out and extracting more dynamically. Just giving you some options.
Jul 24 in
IT'S THAT TIME AGAIN | Fabric July 2024 Update
See the latest July 2024 updates to Microsoft Fabric: https://blog.fabric.microsoft.com/en-US/blog/microsoft-fabric-july-2024-update/ Post your favourite update (and why), below 👇👇👇👇
Complete action
7
4
New comment Jul 25
2 likes • Jul 25
Edit JSON code in pipelines, just cause the workaround was annoying. RTI Dashboards being down to the 1 sec refresh rate is pretty crazy too.
0 likes • Jul 25
@Will Needham It's all gravy until that trial runs out lol
Jul 25 in
DP-600: Minor updates to study guide (from 22 July 2024 onwards)
If you sit the DP-600 exam after 22 July 2024, note that the following changes have been made to the study guide: IMPLEMENT AND MANAGE A DATA ANALYTICS ENVIRONMENT section: "Manage Fabric capacity" has changed to "Manage Fabric capacity and configure capacity settings" COPY DATA section: Added "Implement Fast Copy when using dataflows" OPTIMIZE PERFORMANCE SECTION: "Identify and resolve issues with Delta table file sizes" has changed to "Identify and resolve issues with the structure or size of Delta table files (including v-order and optimized writes)" All three of these elements are already covered in the videos/ DP-600 playlist, so need for updates/ changes 👍
25
5
New comment Jul 27
2 likes • Jul 25
I'm curious what Capacity Settings will be included I'm guessing it will be delegated tenant settings, Spark settings, and capacity notifications. My renewal is going to be ready in about a month, so I'll be interested to see what topics they put on that for the certification and if it will revolve around some of these topics.
1-10 of 45
Active 5d ago
Joined May 13, 2024
powered by