This blog post will give a quick review of all the questions related to the Azure SQL Database that were discussed in our Microsoft Azure Data Fundamentals [DP 900]. The Azure DP900 Certification is for all those who are looking forward to starting working with or shifting their focus to Azure Cloud Data Services for various data-related tasks.
The previous week, In Day 1 session we got an overview of Relational & Non-Relational Data Types, Data Stores, Azure Data Tools, Data Analytics, and Data Visualization.
Microsoft Azure DP900 Certification gives a holistic overview of the most common services. It covers the types of SQL Server on Azure deployment methods and various database offerings in Azure.
We covered the following Modules in the Azure DP-900 Day 2 Session:
- Module 02: Explore Relational Data in Azure
Here are the questions that we discussed in the Azure DP900 Day 2 Session:
> Module 02: Explore Relational Data in Azure
This module covered all relational data offerings in Azure, and it will help you know about Azure Data services, the Difference between IaaS and PaaS, and also about SQL Server on Azure Data Virtual Machines.
We also covered some concepts like Query Relational data in Azure, Different SQL Statement types like DML, DDL, DCL. Also provisioning of a relational database on Azure along with security and connectivity parameters.
Check Out: What is Structured Data vs Unstructured Data.
>Relational Data Services in Azure
Q1: What are Azure Data services?
A: There are different types of Azure data services that are provided to us. Because Azure offers a range of options for running the DBMS in the Cloud like we can migrate our on-premises collection of Azure Virtual Machines. This approach still requires that we manage RDBMS and DBS carefully, and also, we can take advantage of various Azure relational database services available. These data services manage DBMS for that helps us to freely concentrate on the Data and Application that we are using.
Source: Microsoft
Q2: What is the difference between IaaS and PaaS?
A: IaaS(Infrastructure as a Service) gives complete control over the hardware that runs your application (servers, VMs, storage, networks & operating systems)
PaaS(Platform as a Service) provides an environment for building, testing, and deploying software applications.
Q3: What if my memory use increases across databases, will it slow down other databases’ performance?
A: Azure PaaS (Platform as a Software) Database Services take care of the proper distribution and allocation of memory and other resources to all databases in the background.
Q4: What is SQL Server on Azure Virtual Machines?
A: It is an IaaS solution that enables users to use full versions of SQL Server in the Cloud without having to manage any on-premises hardware
- Guaranteed compatibility to SQL Server on-premises.
- Customer manages everything, OS upgrade Software upgrade, backups.
- Pay for the server and Licensing, not per database.
Q5: What is Azure SQL Database?
A: Azure SQL Database is a PaaS offering where users create a managed database server in the cloud and then deploy the databases on the server.
Types Of Deployment Options for the Database:
- Single Database- Create and run a Database Server in the cloud and access the database through the server.
- Elastic Pool- Multiple databases share the same resources such as memory, storage, and processing power.
- Managed pool-It is a fully managed service. It’s for those companies who want to migrate their existing SQL workloads to the cloud.
Source: Microsoft
Check Out: Our blog post on Azure Cosmos DB.
Q6: For using elastic pools in Azure SQL Database, all the databases should be in the same resource group or region?
A: Yes, they need to be in the same resource group or region to share the resource pool.
Q7: What are the Benefits of Azure SQL Database for PostgreSQL, MySQL, MariaDB?
A: The benefits of Azure SQL Database are:
- It has a fully managed Community Database: Take advantage of a fully managed service while using tools and language.
- Built-in high availability for lowest TCO: Ensure your data is always available without the need for an additional database.
- Intelligent Performance and Scale: Improve Performance with built-in intelligence and up to 16TB storage.
- Industry-leading security and Compliance: Protect your data with enhanced security features including advanced threat protection.
- Integration with the Azure ecosystem: Build apps faster with Azure service and safeguard your innovation with Azure.
Q8: What are the different types of open-source databases?
A: The different types of Open-source databases are as follows:
- Azure Database for PostgreSQL- It is a relational database service in the Microsoft cloud based on the PostgreSQL community Edition Database Engine
- Azure Database for MySQL-It’s a PaaS implementation of MySQL in the Azure Cloud, based on MySQL Community Edition.
- Azure Database for MariaDB-It’s an implementation of the MariaDB Database management system adapted to run in Azure. It is based on the MariaDB Community Edition.
Q9. What is Maria DB? Does Azure offer MySQL databases?
A: Maria DB is an open-source relational database that provides an interface for MySQL. Azure does offer MySQL database services that can be deployed in three ways – Azure SQL Database for individual standalone database, Azure SQL Managed Instance for creating groups of SQL Databases and SQL Database on Azure Virtual Machine for creating SQL Servers
Q10: What is Azure Role-Based Access Control (RBAC)?
A: It helps you manage who has access to Azure resources, and what they can do with those resources. You control access to resources using role assignments. A role assignment. A role assignment consists of three elements:
- Security principal: an object that represents a user or service that is requesting access to an Azure resource
- Role: a collection of permission
- Scope: A lists the set of resources that the access applies to
Source: Microsoft
Q11: What is SQL Managed Instance?
A: This allows you to pre-provision compute resources and deploy several individual managed instances up to your pre-provisioned compute level.
- Automatic backups, software patching, database monitoring, and other administrative tasks
- Near 100% compatibility with on-premises SQL server
- Supported by other Azure services
Q12. What is the Difference between on-premises SQL and SQL on a virtual machine?
A: There is no difference in performance between on-premises SQL and SQL on a virtual machine. The only difference is in on-premises you have to buy your own servers and are responsible for the servers, whereas in SQL VM the servers are managed by the cloud providers and it is not our responsibility of the servers.
Q13. Which approach is recommended – Azure SQL or VM?
A: If you want to save cost then go for Azure SQL otherwise VM is good since you have full control over it.
SQL Server on an Azure virtual machine is referred to as infrastructure as a service (IaaS). You’re responsible for updating and patching the OS and SQL Server, apart from critical SQL Server security patches. But you have access to the full capabilities of SQL Server.
SQL Database is a PaaS deployment option of Azure SQL that abstracts both the OS and the SQL Server instance away from users. This deployment option allows you to just get a database and start developing applications.
Q14. Can You Provide Us with a Step by Step Guide to Set Up the Azure DB?
A: You can check our detailed blog on Azure SQL Database which covers everything from Azure SQL Services, Azure SQL Database, Deployment option, and how to work on it.
You can bookmark it for future references 🙂
Q15. What is the Difference Between the SQL DB and a SQL Data Ware-House on Azure?
A: Azure SQL DB and Azure SQL DW are cloud-based systems for hosting data, their purpose is different. The biggest difference is that SQL DB is specifically for Online Transaction Processing (OLTP). This means operational data with a lot of short transactions like INSERT, UPDATE and DELETE by multiple people and/or processes. The data is most often highly normalized stored in many tables.
On the other hand, SQL DW is specifically for Online Analytical Processing (OLAP) for data warehouses. This means consolidation data with a lower volume, but more complex queries. The data is most often stored de-normalized with fewer tables using a star or snowflake schema.
Q16. What is Virtualization?
A: Virtualization is a process that allows for more efficient utilization of physical computer hardware and is the foundation of cloud computing.
Virtualization enables cloud providers to serve users with their existing physical computer hardware; it enables cloud users to purchase only the computing resources they need when they need it, and to scale those resources cost-effectively as their workloads grow.
Q17. Is an autonomous database in Oracle cloud the same as a SQL database?
A: Yes, SQL DB is the same as that of oracle autonomous DB.
Q18. Can you connect to SQL from the laptop using DBeaver or others?
A: Yes, you can connect using DBeaver to the SQL server.
Q19. Is manage instance cost is more compared to the other 2 approaches?
A: Yes, managed instance costlier than VM and SQL DB approach.
Q20. what if in case we want to extend the DB size?
A: We can scale up or scale down the Azure DB.
Q21. SQLVM os / SQLVM (SQLOS) difference please
A: SQLVM is actually my Windows operating system. And we generally install our SQL server in windows. Actually, SQL server nowadays has their own SQLOS where you will be able to configure your drivers and other processes.
> Query Relational Data in Azure:
This topic covered about How is it possible to read the Data, Query the Data in the Azure portal. SQL (Structured Query language) is used to communicate with the relational databases it is the Standard language for the relational database management systems and SQL statements are used to perform task update data in Database retrieve from Database.
Some common relational database management systems that use SQL Microsoft Server, MySQL, PostgreSQL, MariaDB Oracle.
Q22: What are different SQL statement types?
A: Three types of SQL statements are:
- DML (Data Manipulation Language)- Used to query and Manipulation Data. The commands used are SELECT, INSERT, UPDATE, DELETE.
- DDL (Data Definition Language)- Used to Define database objects. The commands used are: CREATE, ALTER, DROP, RENAME.
- DCL (Data Control Language)– Used to Manage security premises. The commands used are: GRANT, REVOKE, DENY.
Q23: what is the use of DML commands?
A: There are 4 types of DML commands as follows:
- SELECT- Select/read from the tables.
- INSERT-Insert new rows in the table.
- UPDATE- Edit/Update existing rows in the table.
- DELETE– Delete Existing rows in the table.
Q24: What is the use of DDL commands?
A: There is 4 Type of DDL commands as follows:
- CREATE– Create a new object in the Database, such as a table or a view.
- ALTER– Modify the structure of an object. For instance, altering a table to add a new column.
- DROP– Remove an object from the database.
- RENAME-Rename an Existing object.
Q25: What is the difference between the Azure Table and a normal table in the Azure SQL Database?
A: SQL stores relational databases whereas Azure Tables stores the non-relational database of massive sizes.
Q26: What are the different types of Query tools?
A: Azure portal, SQL Management Studio, SQL Server Data Tools, Azure Data Studio, SQLCMD, Azure CCL/Cloud shell, etc.
Q26: What is an availability zone?
A: Availability Zones are unique physical locations within an Azure region.
Quiz Time (Sample Exam Questions)
With our Microsoft Azure Data Fundamental Program, we cover Over 150+ Sample questions to help you prepare for the Certification [DP-900]
Check out these Questions:
Ques: You work as a Data Associate in a cloud provider company and Data Scientist asks you for a suggestion on which cloud service a client should be used if he wants to get a fully managed platform to run his application, such that he will only use the software with no management. What would you suggest?
A: IaaS
B: PaaS
C: SaaS
D: He can choose anyone; all cloud services are fully managed and required no user management
Ques: Which of the following is used to create and modify the structure of database objects?
A: DQL (Data Query Language)
B: DDL (Data Definition Language)
C: DCL (Data Control Language)
D: DML (Data Manipulation Language)
References
- Exam DP-203: Data Engineering on Microsoft Azure
- Microsoft Certified Azure Data Engineer Associate | DP 203 | Step By Step Activity Guides (Hands-On Labs)
- Microsoft Certified Azure Data Fundamentals | DP 900 |
- Exam DP-900: Data Fundamentals on Microsoft Azure
- Azure SQL Data |All you need to know
Next Task For You
In our Azure Data Engineer training program, we will cover 40 Hands-On Labs. If you want to begin your journey towards becoming a Microsoft Certified: Azure Data Engineer Associate by checking our FREE CLASS.
Leave a Reply