Microsoft Azure Data Fundamental DP-900 Exam Study Notes
Below are the Microsoft Azure Data Fundamental DP-900 course content and Modules on Microsoft learn website.
*Explore Core Data Concepts:
-Data can be categorized into 3 types.
-Structured data — ex : tabular data in rows and columns
-semi-structured data — ex : JSON, XML
-Unstructured data — ex: audio, video files, images etc.,
-Data is processed either in Batches or as in when the data arrives in
real-time.
-Batch processing collects the data and then process it, on other hand
streaming data processes it as in when data arrives.
-Batch processing data examples- CSV files, one months of sales date
-Stream processing data examples- online gaming data, data from sensors.
-Data processing solutions are of two broad categories: analytical systems, and
transaction processing systems.
#Transactional
system: (OLTP)
Records transactions. Transactions are a small, discrete unit of work in real
time.
Ex: bank transactions. These systems are high-volume and handle millions of
transactions in a single day.
#Analytical
systems:(OLAP)
-concerned with capturing raw data, and using it to generate insights.
-data ingestion- process of collecting raw data from different sources
-data transformation- convert the raw data into a meaningful data
-data querying- To analyze the data and run ad-hoc queries
-data visualization- generate reports, charts, plots for further data
examination.
*Explore Relational DB in Azure:
1.Azure
SQL Database:
single Database- dedicated resources and managed by azure. Scale manually.
Elastic pool — similar to Single Database, except that by default multiple
databases can share the same resources
Managed Instance — fully controllable instance of SQL Server in the cloud, can
install multiple databases on the same instance.
*Explore Non -relational DB in Azure:
Below services are created on Azure using an azure storage account.
1.
Azure table storage:
-NoSQL key value model.
-Stores semi-structured data
-All rows in table must have a key and the columns vary from row to
-row(remember it is not a relational DB)
-No concept of relationships, Stored Procedures, indexes or FK’s (so data is
de-normalized)
-for faster access, azure table storage splits its data into partitions.
-partitions helps group rows based on its keys and a table can have as many
partitions as possible.
-So, a key in azure table storage has 2 parts to it. 1. partition key and 2.
the row key that identifies the row uniquely.
-a table can have up to max of 252 columns
-max row size is 1MB
#advantages: simple
to scale
-row insertion and retrieval is faster
-supports huge volumes of data. As you add rows to a table,
-Azure Table Storage automatically manages the partitions in a table and
-allocates storage as necessary. You don’t need to take any additional steps
yourself.
-high availability
#disadvantages: There’s
no referential integrity
-Consistency needs to be given consideration as transactional updates across
multiple entities aren’t guaranteed
-Azure Table Storage is an excellent mechanism for:
-Examples include product catalogs for eCommerce applications, and customer
information, where the data can be quickly identified and ordered by a
composite key
-Capturing event logging and performance monitoring data
-if you need to analyze an ordered series of events and performance measures
chronologically.
2.Azure Blob storage:
-allows to store unstructured data.
-for storing large binary object like images, audio files etc.
#Three
types of Blob:
block blob: data is stored in blocks. The block is the smallest amount of data
that can be read or written as an individual unit.
Block blobs are best used to store discrete, large, binary objects that change
infrequently.
page blob: A page blob is optimized to support random read and write
operations; you can fetch and store data for a single page if necessary.
Append Blob: You can only add blocks to the end of an append blob; updating or
deleting existing blocks isn’t supported.
An append blob is a block blob optimized to support append operations.
-Blob storage has 3 access tiers:
hot — default one for frequently used data.
cool — infrequently used data
archive- historic data
-Azure Blob Storage is an excellent mechanism for:
-streaming video and audio,
-Storing data for backup and restore, disaster recovery, and archiving
-Storing data for analysis by an on-premises or Azure-hosted service
-Other features available with Azure Blob storage include:
#Versioning-You
can maintain and restore earlier versions of a blob.
#Soft
delete- This feature enables you to recover a blob that
has been removed or overwritten, by accident or otherwise.
you can also Store, audit, and analyze changes to your objects, over any period
of time
#Snapshots- A
snapshot is a read-only version of a blob at a particular point in time.
3.Azure File Storage:
-allows you to share files with both apps running on cloud and also on-premise.
-you can upload files from portal or AzCopyUtility. To use Copy utility you
need to generate a SAS (Shared access signature) token using portal.
-Azure File Sync service to synchronize locally cached copies of shared files
with the data in Azure File Storage.
-offers two performance tiers — standard and premium
-premium offers more throughput at higher cost.
-All data is encrypted at rest, and you can enable encryption for data
in-transit between Azure File Storage and your applications.
-allows 2000 concurrent reads to a shared file, but writes must be carefully
managed using Lock file mechanism to maintain data consistency.
4.Azure cosmos DB:
-semi-structured data
-stores data as a partitioned set of documents. A document is a collection of
fields, identified by a key.
-The fields in each document can vary, and a field can contain child documents.
-uses JSON to represent the document structure.
-Cosmos DB provides support for existing applications via API
mongo DB API, Cassandra API, Gremlin API(Graph DB), SQL API and table API.
-Unlike Azure Table storage, documents in a Cosmos DB partition aren’t sorted
by ID. Instead, Cosmos DB maintains a separate index
-advantages: scalable, high availability, auto Index management,
supports five well-defined consistency choices — strong, bounded staleness,
session, consistent prefix, and eventual.
-Cosmos DB is highly suitable for the following scenarios:
-IoT and telematics, Gaming, Retail and marketing, web and mobile apps.
*Explore modern data
warehouse analytics in Azure:
1.Azure Data Factory :
-Its a data integration service. Does ETL / ELT
-Allows to get raw data in the form of batch/streaming data and helps clean and
transform into meaningful data.
-It connects to different sources via Linked services.
-Its work is defined as a pipeline of operations (series of steps).
pipelines can be triggered or run manually.
-Azure provides GUI for creating these pipelines.
-Azure Data Factory provides Poly Base support for loading data.
-Azure Data factory allows you to run your existing SSIS packages as part of a
pipeline in the cloud via SSIS Feature Pack for Azure.
-SSIS Feature Pack for Azure support transfer to or from Azure storage, Azure
Data Lake, and Azure HDInsight.
2.Azure Data Lake :
-A repo for large raw data that is not processed. Easy to load and read
it is a starting point for the ingested data to get stored.
-It organizes the data into directories and subdirectories
-Enables granular Role-Based Access Control (RBAC) on your data
-Is compatible with the Hadoop Distributed File System (HDFS)
3.Azure Data bricks:
-It is a Apache Spark environment running on Azure to provide big data
processing, streaming, and machine learning.
-It provides a graphical user interface where you can define and test your
processing step by step.
-You can create Data bricks scripts and query data using languages such as R, Python,
and Scala. You write your Spark code using notebooks.
4.Azure Synapse Analytics:
-Analytics engine.
-you can ingest data from multiple sources, process it and transform the data
for analytical purposes.
-It uses poly base that enables synapse to retrieve data from relational and
non-relational sources, such as delimited text files, Azure Blob Storage, and
Azure Data Lake Storage.
-Azure Synapse Analytics leverages massively parallel processing (MPP)
architecture which includes a control node(master) and pool of compute
nodes(salves).
-The master sends the queries to be executed to the compute nodes, and the
results are then sent back to the control node.
-Azure Synapse Analytics supports two computational models: SQL pools and Spark
pools.
-You can only scale a SQL pool when it’s not running a Transact-SQL query.
In a Spark pool, the nodes are replaced with a Spark cluster
you can run jobs on these spark nodes just like you run notebooks in data
bricks.
SQL pool — can add more nodes manually
Spark pool — auto scaling of nodes is enabled
-Azure Synapse Analytics can consume a lot of resources.
-If you aren’t planning on performing any processing for a while, you can pause
the service.
-This action releases the resources in the pool to other users, and reduces
your costs.
5.Azure Analysis:
-It does everything a synapse service can do but at a smaller scale and
additional allows visualization of data.
-Smaller volumes of data (a few terabytes).
-Multiple sources that can be correlated.
-High read concurrency (thousands of users).
-Detailed analysis, and drilling into data, using functions in Power BI.
-Rapid dashboard development from tabular data.
6. Azure HD Insight:
-This is similar to that used by Synapse Analytics, except that the nodes are
running the Spark processing engine rather than Azure SQL Database.

great
ReplyDeletefor more info please visit at https://russianmarkkt.to
ReplyDeleteسئو سایت (SEO) شامل فرآیندها و استراتژیهایی است که به منظور بهبود رتبه سایت در نتایج موتورهای جستجو انجام میشود. این فرآیند توسط سئو سایت انگلیسی شامل تحقیق کلمات کلیدی، بهینهسازی محتوای صفحات وب، افزایش سرعت لود سایت، و بهبود ساختار لینکهای داخلی است. خدمات سئو به افزایش دیدهشدن سایت در جستجوهای مرتبط کمک میکند، که نتیجه آن افزایش بازدید ارگانیک و جذب کاربران هدف است. وب رمز با ارائه خدمات سئو حرفهای تلاش میکند تا سایتها را با استانداردهای گوگل هماهنگ کرده و رتبه بهتری برای آنها ایجاد کند.
ReplyDeleteResults-focused specialist in facebook ppc advertising, helping businesses increase visibility, leads, and sales through smart targeting, creative ads, and performance-driven strategies.
ReplyDeletefacebook ppc advertising
I enjoyed reading this article. The explanations are clear, and the practical examples make it even more useful. I like following different blogs to learn new ideas, and I also find helpful digital marketing resources at Riturn Digital Solutions .
ReplyDeleteSydney attracts students from around the world through its leading universities and diverse academic opportunities. Managing coursework, research projects, and strict submission schedules can often become challenging. assignment help sydney services provide professional assistance for essays, reports, dissertations, and subject-specific assignments across multiple disciplines. Experts deliver well-structured, original, and academically compliant content tailored to institutional guidelines. This support helps students improve subject comprehension, balance academic responsibilities efficiently, submit assignments on time, and achieve stronger academic results throughout their studies in Sydney
ReplyDeleteAn AI chatbot for small business website helps businesses provide instant customer support, capture leads, and answer inquiries 24/7. ALYX WEB develops intelligent chatbot solutions that improve user engagement and increase conversion rates without requiring constant manual assistance. Our custom AI chatbots integrate seamlessly with WordPress and other business websites, offering automated responses, appointment booking, and personalized customer interactions. Whether you run a startup or a growing company, ALYX WEB delivers affordable, scalable, and user-friendly AI chatbot solutions designed to enhance your website’s performance and customer experience.
ReplyDeleteWhen you need trusted repipe specialists california , River City Repipe delivers reliable plumbing solutions for homes and commercial properties. Our experienced team replaces aging or damaged pipes using high-quality materials that improve water flow, reduce leaks, and increase long-term system performance. We focus on efficient workmanship, minimal disruption, and lasting results tailored to your property’s needs. Whether you are upgrading outdated plumbing or solving recurring pipe issues, River City Repipe provides dependable repiping services backed by professional expertise, quality craftsmanship, and outstanding customer satisfaction throughout California.
ReplyDeleteSasun International Electric Co provides premium Load break switch tools South America designed for safe, efficient, and reliable medium-voltage power distribution. Our high-quality load break tools help utilities, contractors, and industrial facilities perform energized switching operations with enhanced safety and durability. Engineered to meet international performance standards, our solutions deliver dependable results in demanding electrical environments across South America. Whether for maintenance, installation, or grid modernization projects, Sasun International Electric Co offers trusted load break switch tools that improve operational efficiency and ensure long-lasting performance
ReplyDeleteLooking for trusted House Painters Corvallis OR homeowners rely on? Halcyon Painting delivers professional interior and exterior painting services that enhance beauty, protect surfaces, and increase property value. Our skilled painters use premium-quality paints and proven techniques to achieve smooth, long-lasting finishes for every project. Whether you need a complete home makeover, cabinet refinishing, or exterior repainting, we provide reliable workmanship with attention to detail. Choose Halcyon Painting for exceptional customer service, durable results, and beautiful residential painting solutions tailored to your Corvallis home.
ReplyDeleteepoxy floor coating from Eco Solutions delivers a durable, seamless, and professional finish for commercial, industrial, and residential spaces. Our high-performance coatings resist chemicals, stains, abrasions, and heavy foot traffic, making them ideal for warehouses, garages, workshops, and production facilities. We focus on proper surface preparation to ensure long-lasting adhesion and exceptional results. Whether you need a protective floor upgrade or a polished modern appearance, Eco Solutions provides reliable epoxy flooring solutions that improve safety, enhance durability, and reduce long-term maintenance costs.
ReplyDeleteSmoking Cessation Treatment can help individuals overcome nicotine dependence and build healthier habits for long-term wellness. Cornerstone Health MDMyEssay provides supportive, personalized guidance to help patients understand their options and develop an effective quitting strategy. Treatment may include behavioral support, lifestyle changes, counseling, and appropriate medical approaches based on individual needs. With professional guidance and consistent commitment, quitting smoking can become more manageable. Cornerstone Health MDMyEssay focuses on compassionate care, practical support, and personalized treatment plans designed to help individuals move toward a smoke-free, healthier future with confidenc
ReplyDeleteUnderstanding Social Security disability benefits can be overwhelming, especially when dealing with a long-term condition. A knowledgeable attorney can help explain your options, guide you through the claims process, and address potential challenges. Vijay "Jay" Deshpande, Attorney At Law, provides legal guidance for disability-related matters.
ReplyDeleteDiscover an exciting opportunity with a house for sale in palm springs ca , presented by Sharon Lucas. Whether you are searching for a peaceful retreat, a family home, or a smart real estate investment, Palm Springs offers beautiful surroundings, vibrant amenities, and a desirable lifestyle. Sharon Lucas provides knowledgeable guidance throughout the buying process, helping you explore available properties and find a home that fits your needs and budget. From modern residences to charming desert homes, discover your ideal Palm Springs property with trusted real estate support and personalized service from Sharon Lucas.
ReplyDeleteInfection Prevention and Control (IPC) Training with RIYAADA ACADEMY Institute for Leadership & Governance equips healthcare professionals with practical knowledge to prevent and control infections in healthcare settings. The training focuses on essential IPC practices, hygiene standards, risk assessment, safe patient care, and effective infection control procedures. Participants gain valuable skills to reduce healthcare-associated infections and promote safer environments for patients, staff, and communities. RIYAADA ACADEMY Institute for Leadership & Governance provides structured learning designed to strengthen healthcare leadership, improve compliance, and support sustainable infection prevention practices across healthcare organizations.
ReplyDeleteTws bluetooth earbuds with noise cancellation (cb201) by CB Fusion deliver an immersive audio experience for music, calls, and everyday entertainment. Designed for comfort and convenience, these wireless earbuds provide clear sound while noise cancellation helps reduce unwanted background distractions. Their compact, modern design makes them easy to carry, while the wireless connectivity supports a hassle-free listening experience. Whether you are commuting, working, exercising, or relaxing, CB201 earbuds offer dependable performance and stylish functionality. Choose CB Fusion for practical, user-friendly audio accessories designed to complement your daily lifestyle.
ReplyDeleteComply Sphere Advisory is a trusted sanctions compliance consultant helping businesses navigate complex and evolving international sanctions requirements. Our practical, risk-based approach supports banks, fintechs, multinational companies, and organizations operating across the GCC, CIS, and emerging markets. We provide sanctions risk assessments, transaction screening guidance, ownership reviews, compliance framework support, and regulatory advisory services. With a focus on accuracy, integrity, and actionable solutions, Comply Sphere Advisory helps organizations identify potential sanctions exposure, strengthen internal controls, and make informed compliance decisions. Partner with experienced advisors to manage sanctions risks confidently and effectively.
ReplyDeleteRiver City Phoenix In Sacramento is a phrase that may lead customers to information about local plumbing and repiping services. For reliable plumbing solutions, River City Repipe provides professional repiping services designed to address aging, damaged, or leaking pipes. The company focuses on helping homeowners improve plumbing performance through dependable solutions and experienced service. Whether you are dealing with recurring leaks, low water pressure, or outdated piping, River City Repipe can help identify suitable options. Choosing professional repiping support can improve water flow, reduce plumbing problems, and provide greater long-term peace of mind.
ReplyDelete