What is the purpose of the DP-700 TestBank Setup?
- Stage raw DP-700 skills Excel in OneLake
- Register raw & prepared tables in Lakehouse
- Create SQL database, schema & target table
- Copy data into SQL DB and validate
What is the first step in Imports & Config?
Load libraries and set any paths/connection strings.
What libraries are imported in the setup?
Pandas and SQLAlchemy.
What is the path for the raw Excel file in OneLake?
“/OneLake/TestBankLakehouse/Raw/DP700_SkillsMeasured.xlsx”
What is the purpose of staging raw Excel in OneLake?
Upload DP700_SkillsMeasured.xlsx to /OneLake/TestBankLakehouse/Raw/ via Fabric UI.
How do you register a raw Lakehouse table?
Use T-SQL to map the Excel as a queryable table.
What is the SQL command to create the raw DP700 skills table?
CREATE TABLE TestBankLakehouse.Raw_DP700_Skills USING CSV OPTIONS ( path ‘/OneLake/TestBankLakehouse/Raw/DP700_SkillsMeasured.xlsx’, header ‘true’);
What is the purpose of preparing Q&A in Python?
Enrich each row with Question/Answer/Notes/Resources, then save as CSV.
What is the first step in preparing Q&A in Python?
Read the raw data using pandas.
What columns are added to the DataFrame for Q&A preparation?
Question, Answer, Notes, Resources.
What is the path for the prepared CSV file in OneLake?
“/OneLake/TestBankLakehouse/Prepared/TestBankEntries.csv”
How do you register the prepared Lakehouse table?
Map your enriched CSV as a second Lakehouse table.
What is the SQL command to create the TestBankEntries table?
CREATE TABLE TestBankLakehouse.TestBankEntries USING CSV OPTIONS ( path ‘/OneLake/TestBankLakehouse/Prepared/TestBankEntries.csv’, header ‘true’);
What is the purpose of creating a Fabric SQL Database & Schema?
Provision a SQL DB and define your schema/table.
What is the SQL command to create the schema and Questions table?
CREATE SCHEMA testbank;
CREATE TABLE testbank.Questions ( Category NVARCHAR(100), Subcategory NVARCHAR(100), Question NVARCHAR(MAX), Answer NVARCHAR(MAX), Notes NVARCHAR(MAX), Resources NVARCHAR(MAX));
What is the purpose of ingesting into SQL DB via Pipeline?
Build a Copy Data pipeline in Data Engineering.
What are the source and sink for the Copy Data pipeline?
Source: Lakehouse table TestBankLakehouse.TestBankEntries
Sink: SQL DB TestBankDB, Schema testbank, Table Questions.
What is the purpose of validating the load?
Quick check that everything landed correctly.
What is the SQL command to validate the load?
SELECT TOP 10 * FROM testbank.Questions;
What are the next steps and tips after the setup?
- Fill out all Q&A in the prepared CSV.
- Automate pipeline on a schedule (e.g., daily).
- Build Power BI or Notebook quiz UI on top of
testbank.Questions. - Celebrate progress! 🎉
