DP-900 Exam Dumps - Microsoft Azure Data Fundamentals

Answer below as:

Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built -in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructu re.

Azure SQL Database is relational database and a managed service.

Expl anation:

Box 1: Yes

Like IaaS, PaaS includes infrastructure – servers, storage, and networking – but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.

PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources

Box 2: Yes

You manage the applications and services you develop, and the cloud service provider typically manages everything else.

Box 3: No

There really is no way to pause / stop billing for your Azure SQL Database.

Microsoft ' s official answer " Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB. "

Azure Storage offers two options for copying your data to a secondary region:

Geo-redundant storage (GRS)

Geo-zone-redundant storage (GZRS)

With GRS or GZRS, the data in the secondary region isn ' t available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage ac count to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).