1. 24, 62, 63, 64: Introduction, incl. flow types, templates, connectors, triggers Hello. And in this section, what we’re going to be doing is looking at Power Automate. Well, the website for Power Automate is fairly simple when you consider that Power Automate used to be called Floor. So it’s Microsoft.com on the floor. So […]

1. 55. Provision and create our first portal using the Portal from blank template Hello. In this section, we will be looking at PowerApps portals. So these are websites that can include data from the common data service or database. So, from the home menu, select Create and navigate to the portal from Blank. So […]

1. 60. Modify views Hello. And in this section, what we’re going to be doing is moving away from canvas apps and going to model-driven apps. So canvas apps are the ones that allow us to design pixel-perfect screens. We can say exactly where we want things to be. We look at data first in […]

3. 27. Identify use cases for custom connectors Now, it is possible that there is no connector for what you actually want. So you have a data source that is not one of these several hundred connectors. Well, you can write a custom connector. Now, this is complicated, and we don’t actually need to go […]

1. Data Visualization So the last topic of this exam and of this course is data visualization. Now, as the name implies, this is how you view the data within your databases. This is effectively a reporting function. The data visualization tool that will be used in this exam is generally Power Bi. And so […]

1. Modern Data Warehouse Now we’re going to dig into data warehouses a little bit more because one of the requirements of the exam is to describe the components of a modern data warehouse. And so in this video, we’re going to take a look at a typical architecture diagram of a data warehouse situation […]

1. Data Analytics Workloads So the fourth and final section of this exam and course focuses on data analytics. And that is where 25% to 30% of your score lies. Now, data analytics is effectively the reporting aspect of databases. It is how you’re going to extract your so-called business intelligence. It’s how you’re going […]

3. Use ARM Templates to Manage Cosmos DB So similar to the SQL database section, we’re going to look at what are called Arm templates for Cosmos DB. Now, I’m at the resource group level, and I went into deployments, and we can see the deployment that we made to create the Cosmos DB account. […]

1. 43, 50. implement index maintenance tasks Hello. And in this section, we’re going to be implementing performance-related maintenance tasks. I’m going to start with indexes. So we’re going to be looking at index maintenance tasks and assessing the growth and fragmentation of a particular index. So first of all, we’ve had a look before […]

1. 38. prepare an operational performance baseline – Metrics Explorer Hello. And in this section, we’re going to be monitoring activity and performance, and we’re going to start by preparing an operational performance baseline. So one way we can do this is by using metrics. Metrics are numerical values that are collected at regular intervals […]