NEW
Font size
WorksheetsEDP 20 Quizz
Total questions: 27
Worksheet time: 14mins
Which Team usually handles local generic changes, CAB 1 and BYOD requests:
Data Availability
Service Operations
DevOps
L3 Support
Change in ADF configuration requires a:
CAB 2
CAB 1
BYOD Request
CAB 3
Shortcut creation is requested through:
Service Now Generic Change
Service Now CAB 3
Service Now CAB 2
Access request for Shortcuts is a Generic Change that requires
1. Shortcut Template to be filled
2. Line Manager approval
3. Activation Lead / Data Owner approval
True
False
The ODS layer is the:
Initial landing zone where raw data is ingested from source systems without transformations, preserving its original
structure for further processing.
A centralized repository housing all data sources used across the platform including data transformation as per business needs.
Presentation Layer of EDP 2.0
UNIFIED_ODS stands for:
Various Lakehouses for Global Data Sources
Spoke Shortcuts
Single Lakehouse for the LOCAL Data Sources
When querying tables should be used:
Fully qualified name format [lakehouse_name].[ODS_name].[object_name]
Fully qualified name format [lakehouse_name].[schema].[object_name]
ODS stands for:
Own Data Storing
Operational Data Store
Orchestration Data System
Once the development and testing is done, the codes need to be merged to the Development branch. How do you do it?
By raising a Service Now Incident
By Raising a PR (Pull Request)
By Raising a Generic Change Request
How to Request a Deployment to Production?
Request via email to DevOps.
Raise a Bug in ADO.
Raise a Pull Request for Prod deployment.
To move changes/new developments to TEST, a PR is raised from dev to uat branch, deploying to the TEST workspace.
True
False
Select correct statement:
Commit to push to higher environments from dev workspace all the existing code not only the changes.
Change request from service now is required for all production deployment including hotfix.
Unused Notebooks available in the fabric workspaces should be kept.
Lakehouse views will be created and executed by
developers in the DEV workspace using:
Python
Notebook
Shortcuts
Folders and files in Lakehouse Folder should not contain any environment values i.e DEV,UAT,PROD
TRUE
FALSE
Its developer responsibility to maintain the version control of the Lakehouse views and no support from Platform team will be there to share the Prod DDL to the user.
TRUE
FALSE
As an RGM Data Engineer I will need to raise request Global Data Acquisition
Developer role.
TRUE
FALSE
In Kimball’s dimensional modeling approach, which of the following best describes the purpose of a fact table?
Store descriptive attributes like product names, customer details, and geographic regions.
Store quantitative, measurable business data at a defined level of granularity.
To define business rules and data governance policies.
In the occasion that subsequent change request is
submitted, the developer needs to ensure the following
attachment are updates in the Release Testing task:
1. UAT documentation with the CR reference
2. Sign-off email with the CR reference
1. Sign-off email with the CR reference
1. Sign-off email with the CR reference
2. Business Sign-Off
To access data from the ODS layer ........................................... will be utilized,
and users can easily provision these shortcuts through a service now
request.
Fabric shortcuts
BYOD
Gold Layer
BYOD (Bring Your Own Data) is applicable for both local and global data sources.
True
False
Select the FALSE Statement:
GIT commit needs to strictly follow the
Branching Strategy.
A new Semantic model must be created for
each report.
Test deployment and testing automation are
mandatory for deployments; no exceptions
allowed
Understanding EDP layers is mandatory.
Microsoft Fabric WorkspaceNaming Convention is:
Non-Prod Environment : df-nd-we-bap-<spoke>-nprd-01
Prod Environment : df-pd-we-bap-<spoke>-prod-01
nProd Environment : KV-<subscription>-WE- <project/spoke>-NPRD-01
Prod Environment : KV- <subscription>-WE- <project/spoke>-PROD-01
BAP_D_<Spoke Name> → Development Workspace
BAP_T_<Spoke Name> → UAT/Test Workspace
BAP_P_<Spoke Name> → Prod Workspace
The standard naming convention for Job names for different layers in EDP is as follows:
JOB_<SPOKE>_<SOURCENAME>_<LAYERNAME>_<TABLE/FUNCTIONAL Name>
JOB_<SOURCENAME>_<LAYERNAME>_<SPOKE>_<TABLE/FUNCTIONAL Name>
<LAYERNAME>_<TABLE/FUNCTIONAL Name>
Key Playbooks to consult for Deployment to Production are: 1. EDP Deployment Guide, 2. EDP Development Guide and 3. CAB Process Explained guardrails for more details about the CAB process.
True
False
All fabric data science components and all data engineering components seamlessly integrate with GIT,
and it's essential to create the repository before initiating
development activities.
True - for Data Science & Data Engineering
False for Data Science
True for PBI Developers
In the context of Power BI, using an ..................... allows you
to connect to your EDP 2.0, to access and analyze your data
using Power BI's reporting and visualization capabilities.
SQL Endpoint
Shortcuts
Data Sharing
The deployment processes used today in EDP 2.0 are:
Standard
Feature
Hotfix
Standard
Hotfix
Epic
Feature
Standard
![Review Pengenalan BB dan Sampling [by DMM]](https://cf.quizizz.com/image/image-loader.svg)
