Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources
Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study
Go to the blog

Azure Data Services: IaaS, PaaS, SaaS and PaaS Category for Azure Data Services, Exams of Programming Languages

Knowledge Systems Institute (KSI)Programming Languages

Information about azure data services, explaining which category they fall into (paas), the currently available relational databases on azure (azure sql database, azure database for mysql servers, azure database for mariadb servers, azure database for postgresql servers), and the benefits of using azure data services such as reduced administration time and high availability. It also discusses the limitations of azure data services and how to get more control than what is offered. The document further compares running sql server on virtual machines versus using azure sql database and managed instance.

Typology: Exams

2023/2024

Available from 03/24/2024

star_score_grades
star_score_grades 🇺🇸

3.6

(19)

1.7K documents

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
PRACTICE QUESTIONS FOR AZURE
DATA DP-900 FUNDAMENTALS EXAM
PT.2
66. We have IaaS, PaaS, SaaS. In which category that Azure data services fall into? -
correct answer Azure Data Services fall into the PaaS category. These services are a series
of DBMSs managed by Microsoft in the cloud. Each data service takes care of the
configuration, day-to-day management, software updates, and security of the databases
that it hosts.
67. What are currently available relational databases on Azure? - correct answer Azure
SQL Database Azure Database for MySQL servers Azure Database for MariaDB servers
Azure Database for PostgreSQL servers
68. Using Azure Data Services reduces the amount of time that you need to invest to
administer a DBMS. Is this true? - correct answer True
69. What is the availability of these Azure Data Services? - correct answer Azure Data
Services ensure that your databases are available for at least 99.99% of the time.
70. How Azure data services cost you? - correct answer The base price of each service
covers underlying infrastructure and licensing, together with the administration charges.
Additionally, these services are designed to be always on. This means that you can't shut
down a database and restart it later.
71. What is the limitation of Azure data services? - correct answer Not all features of a
database management system are available in Azure Data Services. This is because Azure
Data Services takes on the task of managing the system and keeping it running using
hardware situated in an Azure datacenter. Exposing some administrative functions might
make the underlying platform vulnerable to misuse, and even open up some security
concerns.
you have no direct control over the platform on which the services run. - correct answer
pf3
pf4
pf5

Partial preview of the text

Download Azure Data Services: IaaS, PaaS, SaaS and PaaS Category for Azure Data Services and more Exams Programming Languages in PDF only on Docsity!

PRACTICE QUESTIONS FOR AZURE

DATA DP-900 FUNDAMENTALS EXAM

PT.

  1. We have IaaS, PaaS, SaaS. In which category that Azure data services fall into? - correct answer Azure Data Services fall into the PaaS category. These services are a series of DBMSs managed by Microsoft in the cloud. Each data service takes care of the configuration, day-to-day management, software updates, and security of the databases that it hosts.
  2. What are currently available relational databases on Azure? - correct answer Azure SQL Database Azure Database for MySQL servers Azure Database for MariaDB servers Azure Database for PostgreSQL servers
  3. Using Azure Data Services reduces the amount of time that you need to invest to administer a DBMS. Is this true? - correct answer True
  4. What is the availability of these Azure Data Services? - correct answer Azure Data Services ensure that your databases are available for at least 99.99% of the time.
  5. How Azure data services cost you? - correct answer The base price of each service covers underlying infrastructure and licensing, together with the administration charges. Additionally, these services are designed to be always on. This means that you can't shut down a database and restart it later.
  6. What is the limitation of Azure data services? - correct answer Not all features of a database management system are available in Azure Data Services. This is because Azure Data Services takes on the task of managing the system and keeping it running using hardware situated in an Azure datacenter. Exposing some administrative functions might make the underlying platform vulnerable to misuse, and even open up some security concerns. you have no direct control over the platform on which the services run. - correct answer
  1. How do you get more control than Azure Data Services allow? - correct answer you can install your database management system on a virtual machine that runs in Azure.
  2. Migrating from the system running on-premises to an Azure virtual machine is no different than moving the databases from one on-premises server to another. Is this correct? - correct answer True SQL Server running on an Azure virtual machine effectively replicates the database running on real on-premises hardware.
  3. When you are running SQL Server on Virtual Machines who takes care of maintaining the SQL Server software and performing the various administrative tasks to keep the database running from day-to-day. - correct answer Customer
  4. In Which situation you should run the Microsoft SQL Server on Virtual Machines? - correct answer This approach is optimized for migrating existing applications to Azure, or extending existing on-premises applications to the cloud in hybrid deployments. A hybrid deployment is a system where part of the operation runs on-premises, and part in the cloud. Your database might be part of a larger system that runs on-premises, although the database elements might be hosted in the cloud.
  5. What are the capabilities of running SQL Server on Virtual machines? - correct answer Create rapid development and test scenarios when you do not want to buy on-premises non-production SQL Server hardware. Become lift-and-shift ready for existing applications that require fast migration to the cloud with minimal changes or no changes. Scale up the platform on which SQL Server is running, by allocating more memory, CPU power, and disk space to the virtual machine. You can quickly resize an Azure virtual machine without the requirement that you reinstall the software that is running on it.
  6. What are the options available when selecting the Azure SQL database? - correct answer Azure SQL Database is a PaaS offering from Microsoft. Azure SQL Database is available with several options: Single Database, Elastic Pool, and Managed Instance. Single Database This option enables you to quickly set up and run a single SQL Server database. You create and run a database server in the cloud, and you access your database through this server. Microsoft manages the server, so all you have to do is configure the database, create your
  • It continuously monitors your database for suspicious activities and provides immediate security alerts on potential vulnerabilities, SQL injection attacks, and anomalous database access patterns.
  • SQL Database helps secure your data by providing encryption. For data in motion, it uses transport layer security. For data at rest, it uses transparent data encryption.
  1. What is the use case for Azure SQL server managed instance? - correct answer Consider Azure SQL Database managed instance if you want to lift-and-shift an on- premises SQL Server instance and all its databases to the cloud, without incurring the management overhead of running SQL Server on a virtual machine.
  2. What are MySQL - correct answer MariaDB, and PostgreSQL?, MySQL MySQL started life as a simple-to-use open-source database management system. It's available in several editions; Community, Standard, and Enterprise. The Community edition is available free-of-charge, and has historically been popular as a database management system for web applications, running under Linux. Versions are also available for Windows. MariaDB MariaDB is a newer database management system created by the original developers of MySQL. The database engine has since been rewritten and optimized to improve performance. MariaDB offers compatibility with Oracle Database (another popular commercial database management system). One notable feature of MariaDB is its built-in support for temporal data. A table can hold several versions of data, enabling an application to query the data as it appeared at some point in the past. PostgreSQL PostgreSQL is a hybrid relational-object database. You can store data in relational tables, but a PostgreSQL database also enables you to store custom data types, with their own non-relational properties. The database management system is extensible; you can add code modules to the database, which can be run by queries. Another key feature is the ability to store and manipulate geometric data, such as lines, circles, and polygons.
  3. PostgreSQL has its own query language called pgsql. Is this true? - correct answer True
  1. What are the deployment options for Azure Database for PostgreSQL? - correct answer Azure Database for PostgreSQL single-server The single-server deployment option for PostgreSQL provides similar benefits as Azure Database for MySQL. You choose from three pricing tiers: Basic, General Purpose, and Memory Optimized. Each tier supports different numbers of CPUs, memory, and storage sizes—you select one based on the load you expect to support. Azure Database for PostgreSQL Hyperscale (Citus) Hyperscale (Citus) is a deployment option that scales queries across multiple server nodes to support large database loads. Your database is split across nodes. Data is split into chunks based on the value of a partition key or sharding key. Consider using this deployment option for the largest database PostgreSQL deployments in the Azure Cloud.
  2. Scaling up or out will take effect without restarting the SQL database. Is this true? - correct answer True
  3. What is the best way to transfer the data in a PostgreSQL database running on- premises into a database running Azure Database for PostgreSQL service? - correct answer Use the Azure Database Migration Services
  4. When using an Azure SQL Database managed instance what is the simplest way to implement backups?, - correct answer Backups are automatically handled
  5. You're responsible for all software installation and maintenance and performing backups when SQL Server running on a virtual machine. Is this true? - correct answer True
  6. Describe provisioning PostgreSQL and MySQL? - correct answer https://docs.microsoft.com/en-us/learn/modules/explore-provision-deploy-relational- database-offerings-azure/4-describe-provision-postgresql-mysql
  7. Describe configuring Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL? - correct answer https://docs.microsoft.com/en-us/learn/modules/explore-provision-deploy-relational- database-offerings-azure/6-configure-sql-database-mysql-postgresql
  8. Consider the following SQL statement what is the table name and columns name? - correct answer SELECT *
  1. Which clause should you use with the SELECT, UPDATE, and DELETE statements to apply changes only for specific rows? - correct answer WHERE
  2. Which clause should you use t sort the data in the select query? - correct answer ORDER BY
  3. Which clause should you use to retrieve the related data from multiple tables? - correct answer JOIN A join condition defines the way two tables are related in a query by: Specifying the column from each table to be used for the join. A typical join condition specifies a foreign key from one table and its associated primary key in the other table. Specifying a logical operator (for example, = or <>,) to be used in comparing values from the columns.
  4. Consider the following SQL query which type of statement is this? - correct answer INSERT INTO MyTable(MyColumn1, MyColumn2, MyColumn3) VALUES (99, 'contoso', 'hello') DML
  5. Consider the following SQL query which type of statement is this? - correct answer CREATE TABLE MyTable ( MyColumn1 INT NOT NULL PRIMARY KEY, MyColumn VARCHAR(50) NOT NULL, MyColumn3 VARCHAR(10) NULL ); DDL