Monthly Archives: December 2022

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 […]

1. 34. apply a data classification strategy Now, some of your data is sensitive, but people might still need to be able to see it. So sensitive data includes data privacy, regulatory requirements, and national requirements. So we’ve talked extensively about GDPR and the California version. And maybe there are security scenarios that include controlling […]

5. 25, 113. configure security principals – individual permissions In the previous video, we had a look at grant, revoke, and deny for individual permissions, but what are these individual permissions that you can use? Let’s take a look, so let’s just break this down: we have authorization permission on securable name to principle, which […]

3. HVAC Consideration So this is Hawaii’s heating, ventilation, and air conditioning. So basically, there is an automatic air conditioner that adjusts as per the indoor temperatures. It goes on and off according to its needs, and it maintains a stable temperature. So normally, data centre heating, ventilation, and the AC units are turned on […]

7. [SAA/DVA] S3 Security & Bucket Policies Okay, so now let’s talk about Amazon security. So, it’s very complex, but first you have user-base security. So, our IAM users have IAM policies, and they authorise which API calls should be allowed. And if our user is authorized through our IAM policy to access our Amazon […]

1. [SAA/DVA] S3 Buckets and Objects Okay? So first, to talk about Amazon S3, we need to talk about buckets. So S Three is a system or a service that allows us to store objects. So files go into buckets or directories. And each bucket must have a globally unique name. As you’ll see, in […]