Latest News
Azure Cosmos DB– Gaining the Azure Data Engineer Associate Certification
Azure Cosmos DB is a database administration feature. It will automatically administer DBMS updates and patching, storage capacity management, and autoscaling capabilities. From a storage perspective, the scale happens automatically and elastically. Elastically means that when the database needs more storage space, it gets allocated, and when it is no longer needed, it gets deallocated.…
Read MoreAzure Security– Gaining the Azure Data Engineer Associate Certification
Security is the most important aspect of IT. Networks, compute machines, data storage, and so on are important, but a data breach is almost, if not worse, than losing all your data. Knowing about the security products, features, and services that exist on Azure is an absolute must. Although your job as an Azure data…
Read MoreOther Products– Gaining the Azure Data Engineer Associate Certification
Here are some additional storage products that may be included on the exam. Even if they do not appear on the exam, it is good practice to know most of the Azure products, what they do, and why you would use them. Azure Data Explorer Azure Data Explorer (ADE) has been referred to often as…
Read MoreApache Cassandra– Gaining the Azure Data Engineer Associate Certification
If you have an on‐premises NoSQL Cassandra database and want to migrate to the Azure platform, choose this service. When you migrate to Azure, you no longer need to manage nodes, clusters, or the OS. All of that is outsourced to Azure. Data is queried using the Cassandra Query Language (CQL), and you can use…
Read MoreAzure SQL Database– Gaining the Azure Data Engineer Associate Certification
This product is on the other side of the cloud service spectrum when compared to SQL Server on Azure VMs. An Azure SQL Database (SQL DB) is a relational DBaaS that offers not only the outsourcing of network and hardware infrastructure, but also operating system and DBMS responsibilities. All you need to worry about is…
Read MoreReporting and Monitoring – Gaining the Azure Data Engineer Associate Certification
Since Azure AD is the place where most of your authentication and authorization activities will happen, it is very important to have some tools to make sure all is working. If you see in the audit logs that many of your employees are failing to be authenticated because of IP location, you might want to…
Read MoreAzure Key Vault – Gaining the Azure Data Engineer Associate Certification
It is unfortunately very common to store passwords and connection strings within application code. Sometimes they are stored in a configuration file along with the coded application. Even if the password or connection string is encrypted, it can still be compromised. This is because anyone with administrative access to the machine that decrypts the credential…
Read MoreBlob Storage – Gaining the Azure Data Engineer Associate Certification
If you need to store files such as JSON, XML, DOCX, MP3, PDF, or any other kind of file, then use Blob Storage. Blob Storage implements a flat namespace for organizing data, in contrast to the hierarchical namespace organization that comes with ADLS Gen2. Although you can create folders and place files within them when…
Read MoreAzure Data Lake Analytics – Gaining the Azure Data Engineer Associate Certification
Azure Data Lake Analytics is used to run on‐demand data analytic jobs in parallel. The parallelism is achieved using Microsoft Dryad, which can compute data represented in directed acyclic graphs (DAGs). A DAG is a model helpful in the calculation of the “traveling salesman” scenario, in which there can be sequential proposed directions that never…
Read MoreAzure Storage – Gaining the Azure Data Engineer Associate Certification
Azure Storage is a suite of modern storage solutions, all of which are massively scalable, secure, reliant, and accessible. When you need one of the offered Azure Storage services, you create what is called an Azure Storage Account. The storage account is where you can choose certain attributes that apply to all the services within…
Read More