Exam DP203 Course Tybul: Difference between revisions

@@ Line 4: / Line 4: @@
 == 03 Storage Account Overview ==
-https://www.youtube.com/watch?v=ClqZ1j_7NY4
+[[Exam_DP203_Course_Tybul_03_Storage_Account_Overview]]
-Storage Account Table Service.
+== 04 Storage Account Redundancy ==
+[[Exam_DP203_Course_Tybul_04_Storage_Account_Redundancy]]
-Configured in portal - storage account.
+== 05 Storage Account Access Tiers ==
+[[Exam_DP203_Course_Tybul_05_Storage_Account_Access_Tiers]]
-Used by NoSQL. Table is schemaless.
+== 06 Common File Types csv xml json ==
+[[Exam_DP203_Course_Tybul_06_Common_file_types_csv_xml_json]]
-It is disabled by default, and if you try to create a table, it fails with a permissions error.
+== 07 Common File Types parquet ==
+[[Exam_DP203_Course_Tybul_07_Common_file_types_parquet]]
-https://learn.microsoft.com/en-us/azure/storage/tables/assign-azure-role-data-access?tabs=powershell
+[[Exam_DP203_file_formats_Parquet]]
-says: When you create an Azure Storage account, you are not automatically assigned permissions to access data via Microsoft Entra ID. You must explicitly assign yourself an Azure role for Azure Storage. You can assign it at the level of your subscription, resource group, storage account, or table.
+== 07 Common File Types delta lake ==
+[[Exam_DP203_Course_Tybul_07_Common_file_types_delta_lake]]
-Storage Table Data Contributor
+== 08 Common File Types Data lake structure raw layer ==
+[[Exam_DP203_Course_Tybul_08_Data_lake_structure_Raw_layer]]
-Edit: I have created a new account (Sandbox).
+== 09 Common File Types Azure Data Factory ==
+[[Exam_DP203_Course_Tybul_09_Azure_Data_Factory]]
-In a Storage account, go to '''Storage Browser - Tables''' to add a table (you can go to Data Storage - Tables, but there you can't edit the table contents)
+Note this also contains videos 10 - 14
-Click Add Entity to add a new row to the table. Define columns and datatypes on the fly - it is schemaless so these can be changed, including on the same column in different rows.
+== 15 Questions about new data source ==
+[[Exam_DP203_Course_Tybul_15_Questions_about_new_data_source]]
+== 32 - A closer look at Databricks notebooks ==
+[[Exam_DP203_Course_Tybul_32_A_closer_look_at_Databricks_notebooks]]
+== 39 - Azure Synapse Analytics - Spark Pools ==
+[[Exam_DP203_Course_Tybul_39_Azure_Synapse_Analytics__Spark_Pools]]