The latest Microsoft AZ-303 Microsoft Azure Architect Technologies certification actual real practice exam question and answer (Q&A) dumps are available free, which are helpful for you to pass the Microsoft AZ-303 Microsoft Azure Architect Technologies exam and earn Microsoft AZ-303 Microsoft Azure Architect Technologies certification.
Exam Question 181
A company is migrating its on-premises datacenter to Azure. The solution should:
Support migration without database changes.
Provide for company control over maintenance and update schedules.
Provide for control over the recovery model.
You need to identify the appropriate database solution.
What solution should you choose?
A. Azure SQL Database Single Database
B. Azure SQL Database Elastic Pool
C. Azure SQL Database Managed Instance
D. SQL Server on Azure Virtual Machine (VM)
Correct Answer:
D. SQL Server on Azure Virtual Machine (VM)
Answer Description:
You should choose SQL Server on Azure VM. This is an Infrastructure-as-a-Service (IaaS) model that gives you complete control over the database server. This solution uses standard SQL Server editions that run on standard hardware, so no database changes are necessary. Because this is an IaaS deployment, the company has complete control over database engine management, including maintenance, update schedules, and the recovery model that is used.
You should not choose single database, elastic pool, or managed instance solutions. These are all Platform-as-a-Service (PaaS) models, where the company has limited control over the database engine. Activities such as maintenance and updates are under Microsoft’s schedule and control.
A single database or an elastic pool made up of single instance databases does not meet the requirements. These kinds of deployments are best matched to the development and deployment of cloud-based applications.
A managed instance deployment can often support migration from an on-premises deployment with little or no database changes, but it does not meet the company management requirements. It provides a near 100% compatibility with an on-premises SQL Server.
References:
Microsoft Docs > Choose the right deployment option in Azure SQL
Exam Question 182
A company is migrating its on-premises database to Azure. You use the following commands to create the database:
- New-AzSqlInstance
- New-AzSqlInstanceDatabase
You need to determine the features of this deployment.
Choose all that apply:
A. This deployment is limited to using the vCore purchasing model only.
B. The database can be moved to an existing elastic pool.
C. Migration can be completed with little or no changes to the on-premises database.
D. Microsoft is responsible for database engine updates and maintenance.
Correct Answer:
A. This deployment is limited to using the vCore purchasing model only.
C. Migration can be completed with little or no changes to the on-premises database.
D. Microsoft is responsible for database engine updates and maintenance.
Answer Description:
The commands are used to create an Azure SQL Database Managed Instance, which is a platform-as-a-service (PaaS) SQL database deployment. It is near 100% compatible with on-premises SQL Server editions and lets you use your existing SQL Server licenses to reduce migration costs.
Managed instance is limited to using the vCore purchasing model only. This purchasing model lets you choose compute and storage resources independently for your deployment. This is different from Azure SQL Database Single Instance and Elastic Pool deployments, which support both vCore and DTU purchasing options.
The database cannot be moved into an existing elastic pool, nor can a new elastic pool be created for the database. Elastic pools are supported for Azure SQL Database Single Instance deployments.
Because of the compatibility between on-premises instances and managed instances, migration can be completed with little or no changes to the on-premises database. This model is often used for migration from an on-premises datacenter.
Because this is a PaaS deployment, Microsoft is responsible for the updates and maintenance of the database. These also occur on Microsoft’s schedule.
References:
Microsoft Docs > Choose the right deployment option in Azure SQL
Microsoft Docs > New-AzSqlInstance
Microsoft Docs > New-AzuSqlInstanceDatabase
Microsoft Docs > What is Azure SQL Database managed instance?
Microsoft Docs > vCore model overview
Exam Question 183
A company is moving the database that is used to support an important application to an Azure SQL Database Managed Instance.
You need to review the source code of the application to identify potential incompatibilities.
Choose all that apply:
A. Filestream data types are supported for temporary tables.
B. Bulk insert operations are limited to importing from Azure Blob storage only.
C. Standard query operations, including SELECT, UPDATE, and DELETE, are supported. *
D. Commands that are executed using xp_cmdshell return JSON-formatted data instead of nvarchar(255) type data.
Correct Answer:
B. Bulk insert operations are limited to importing from Azure Blob storage only.
Answer Description:
Filestream data types are not supported for any type of database tables, including temporary tables. The filestream data type is not supported on Managed Instance databases, and filegroups cannot contain filestream data. Attempts to restore from backups that include filestream data will fail.
Bulk insert operations are limited to importing from Azure Blob storage only. Operations that use the BULK INSERT or OPENROWSET commands must include a DATASOURCE parameter that identifies the data source. A managed instance cannot access file shares or Windows folders. The same is true for restore operations, which must also specify Azure Blob storage as their data source.
Standard query operations, including SELECT, UPDATE, and DELETE, are supported. There is near 100% compatibility between on-premises SQL Server editions and Azure SQL Database Managed Instance. This means that few changes are usually needed during migration.
Azure SQL Database Managed Instance databases do not support executing commands through xp_cmdshell. In addition, sp_execute_external_scripts and extended stored procedures are not supported.
References:
Microsoft Docs > Managed instance T-SQL differences and limitations
Microsoft Docs > What is Azure SQL Database managed instance?
Exam Question 184
You are implementing a .NET Framework application that uses data sharded across multiple Azure SQL databases. The application must ensure transactional consistency for changes across different shards.
You need to manage the application transactions.
What should you do to meet the requirements?
A. Implement elastic transactions with horizontal partitioning.
B. Implement elastic transactions with vertical partitioning.
C. Move the databases to an elastic pool.
D. Implement distributed transactions with Microsoft Distributed Transaction Coordinator (DTC).
Correct Answer:
A. Implement elastic transactions with horizontal partitioning.
Answer Description:
You should implement elastic transactions with horizontal partitioning. This will allow you to run transactions that span across several Azure SQL databases. You should use horizontal partitioning to handle transactions that manipulate sharded data.
You should not implement elastic transactions with vertical partitioning. A vertically partitioned schema separates data by kind, such as tables provisioned in different databases. You should implement elastic transactions with vertical partitioning for these scenarios. In this scenario, data is partitioned horizontally by shards, and each database shares the same table schema.
You should not implement distributed transactions with DTC. You can implement distributed transactions with Microsoft DTC to manage transactions that use data sharded across multiple SQL Server databases. However, you can only use Microsoft DTC with on-premises SQL Server instances.
You should not move the databases to an elastic pool. You can use an elastic pool as a cost-effective solution for managing and scaling multiple Azure SQL databases that have unpredictable usage demands. Elastic pools are used to share compute resources across databases. You can run a sharded database in an elastic pool, but the databases in this pool can have completely different schemas.
References:
Microsoft Docs > Distributed transactions across cloud databases
Microsoft Docs > DTC Administration Guide
Microsoft Docs > Elastic pools help you manage and scale multiple databases in Azure SQL Database
Exam Question 185
You manage a pool of on-premises SQL Server 2019 databases. These databases are configured to use Database Mail and SQL Server agent to run scheduled tasks.
You need to migrate these databases to Azure with the least administrative effort.
Which service should you implement?
A. Azure SQL Database in an elastic pool
B. Azure SQL Managed Instance
C. Azure Synapse Analytics
D. SQL Server on an Azure Virtual Machine (VM)
Correct Answer:
B. Azure SQL Managed Instance
Answer Description:
You should implement an Azure SQL Managed Instance. You can use Managed instances to deploy Azure SQL databases with the latest SQL Server database engine, while reducing the administration effort by automatically applying security patching and version updates. Managed instances support both SQL Agent and Database Mail.
You should not implement an Azure SQL database in an elastic pool. You can use an elastic pool to manage and scale multiple Azure SQL databases in a cost-effective way. Azure SQL Database does not support Database Mail, and you need to rewrite SQL Agent Jobs scheduled tasks as elastic jobs.
You should not implement Azure Synapse Analytics. Synapse Analytics is a service that brings together enterprise data warehousing and Big Data analytics. You can use Synapse Analytics to run complex queries across a large amount of data by using massively parallel processing queries.
References:
Microsoft Docs > What is Azure SQL Managed Instance?
Microsoft Docs > What is Azure SQL?
Microsoft Docs > Elastic pools help you manage and scale multiple databases in Azure SQL Database
Microsoft Docs > What is Azure Synapse Analytics (formerly SQL DW)?
Microsoft Docs > What is SQL Server on Azure Virtual Machines (Windows)
Exam Question 186
A company’s operations are supported by an Azure Cosmos DB. The database is configured for single master replication across the North Central US and South Central US regions. The database is configured with Staleness bound consistency as its default consistency.
You need to determine how this impacts your company’s recovery objectives in case of a catastrophic regional failure.
What is the recovery time objective (RTO) for this configuration?
A. 0 minutes
B. Less than 15 minutes
C. Less than one week
D. Less than one day
Correct Answer:
B. Less than 15 minutes
Answer Description:
The RTO for this configuration is less than 15 minutes. The same value applies for Session, Consistent Prefix, and Eventual consistency for single master replication over multiple regions. It also applies to Strong consistency with single or multi-master replication.
RTO and recovery point objective (RPO) are key considerations in calculating recovery. RTO refers to maximum time a resource may be down after a catastrophic failure. RPO is related to allowable data loss and is the age of backups that must be recovered to restore data.
Supported consistency levels are:
- Strong – Reads always return the most recent committed version of an item.
- Bounded staleness – Reads might lag behind writes based on configured update versions (K) or time (t).
- Session – Scoped to a client session, and reads honor consistency guarantees including the consistent-prefix, monotonic reads, monotonic writes, read-your-writes, and write-follows-reads guarantees.
- Consistent prefix – Updates that are returned contain some prefix of all the updates, and reads never see out-of-order writes.
- Eventual – There is no ordering guarantee for reads, and replicas eventually converge.
RPO for the scenario configuration is based on the K and t values.
Multi-master replication over multiple regions provides an RTO of 0 minutes for all consistencies except Strong.
When deployed in a single region, the RTO is less than one week for any consistency.
References:
Microsoft Docs > Consistency levels in Azure Cosmos DB
Microsoft Docs > Consistency, availability, and performance tradeoffs
Microsoft Docs > High availability with Azure Cosmos DB
RPO vs. RTO: Understand the differences in backup metrics
Exam Question 187
A company wants to set up an elastic pool to support 20 single SQL databases that are managed as part of the same SQL database server. Database Transaction Unit (DTU) utilization is as follows:
- Average DTU utilization per database – 18
- Peak DTU utilization per database – 47
- Number of concurrently peaking databases – 2
You need to determine the size of the elastic DTU (eDTU) pool you need to configure.
Which pool size should you configure?
A. 360
B. 400
C. 100
D. 300
Correct Answer:
B. 400
Answer Description:
You should configure a 400 eDTU pool. The following are used to calculate the pool size:
- Number of databases * average DTU per database
- Number of currently peaking databases * peak DTU
- The larger value of the two is used to determine the eDTU pool.
- 20 (databases) * 18 (average DTU) = 360
- 2 (concurrent peaks) * 47 (peak DTU) = 94
- The larger value, 360, is used. The nearest fit from the supported eDTU pool sizes is 400.
You should not choose 100 or 200. Neither is sufficient to support the pool requirements.
You should not choose 360. This is not supported as a pool size.
References:
Microsoft Docs > Resources limits for elastic pools using the DTU purchasing model
Microsoft Docs > Service tiers in the DTU-based purchase model
Microsoft Docs > Elastic pools help you manage and scale multiple Azure SQL databases
Microsoft Docs > New-AzSqlElasticPool
Exam Question 188
You add a new Azure SQL Database single database to an existing database server.
You need to add the database to an existing elastic pool.
Which PowerShell cmdlet should you use?
A. Set-AzureRmSqlInstance
B. Set-AzureRmSqlDatabase
C. Set-AzureRmSqlDatabaseSecondary
D. Set-AzureRmSqlElasticPool
Correct Answer:
B. Set-AzureRmSqlDatabase
Answer Description:
You should use the Set-AzureRmSqlDatabase cmdlet. This cmdlet modifies the properties of an existing database, which includes adding the database to an elastic pool. You would run a command similar to the following:
Set-AzSqlDatabase -ResourceGroupName RGDB1 -ServerName DBServe1
-DatabaseName DB12 -ElasticPoolName MyPool
You should not use the Set-AzureRmSqlElasticPool cmdlet. This cmdlet lets you modify elastic pool properties, such as pool size, minimum DTUs, and maximum DTUs. It does not let you add databases to or remove databases from the pool.
You should not use the Set-AzureRmSqlDatabaseSecondary cmdlet. This cmdlet is not used to manage elastic pools. It is used to switch a secondary database to be the primary database to initiate failover in a fault tolerant configuration.
You should not use the Set-AzureRmSqlInstance cmdlet. This cmdlet is used to set properties for an Azure SQL Database Managed Instance. A managed instance cannot be part of an elastic pool.
References:
Microsoft Docs > Elastic pools help you manage and scale multiple Azure SQL databases
Microsoft Docs > Use PowerShell to create elastic pools and move a database between them
Microsoft Docs > Set-AzureRmSqlElasticPool
Microsoft Docs > Set-AzureRmSqlDatabase
Microsoft Docs > Set-AzureRmSqlDatabaseSecondary
Microsoft Docs > Set-AzureRmSqlInstance
Exam Question 189
You manage an Azure subscription that contains some Azure SQL servers. The Azure SQL servers contain elastic pools and Azure SQL databases as shown in the exhibit.
| Elastic Pool Name | Azure SQL server |
|---|---|
| Pool1 | Sql1 |
| Pool2 | Sql1 |
| Pool3 | Sql2 |
| Azure SQL database | Azure SQL server | Elastic Pool |
|---|---|---|
| DB1 | Sql1 | Pool1 |
| DB2 | Sql1 | Pool2 |
| DB3 | Sql2 | None |
You need to manage these databases across the elastic pools.
Choose all that apply:
A. You can remove DB1 from Pool1 and add it to Pool2.
B. You can remove DB2 from Pool2 and add it to Pool3.
C. You can add DB3 to Pool1.
Correct Answer:
A. You can remove DB1 from Pool1 and add it to Pool2.
Answer Description:
You can remove DB1 from Pool1 and add it to Pool2. You can move a database from one elastic pool to another if the pool is in the same Azure SQL server.
You cannot remove DB2 from Pool2 and add it to Pool3. You can remove DB2 from Pool2, but you cannot add it to Pool3 because this elastic pool belongs to a different Azure SQL server.
You cannot add DB3 to Pool2 because this belongs to Sql1 and DB3 is provisioned in Sql2. You can add DB3 to Pool3 instead because they belong to the same Azure SQL server.
References:
Microsoft Docs > Elastic pools help you manage and scale multiple databases in Azure SQL Database
Microsoft Docs > Manage elastic pools in Azure SQL Database
Exam Question 190
You manage an Azure SQL database named DB1.
You want to use the following SQL statements to create three tables in DB1.
Employees table:
CREATE TABLE Employees
(
EmployeeId INT IDENTITY PRIMARY KEY,
FullName NVARCHAR(256) NOT NULL,
BirthDate DATE NOT NULL,
CompanyId INT REFERENCES Companies (CompanyId)
)
Phones table:
CREATE TABLE Phones
(
PhoneNumber INT NOT NULL,
EmployeeId INT REFERENCES Employees (EmployeeId)
)
Companies table:
CREATE TABLE Companies
(
CompanyId INT IDENTITY PRIMARY KEY,
Name NVARCHAR(256) NOT NULL
)
You need to order the SQL statements to create the three tables.
Which statement order should you use to meet the requirements?
A. Employees, Phones, and Companies
B. Companies, Employees, and Phones
C. Companies, Phones, and Employees
D. Phones, Employees, and Companies
Correct Answer:
B. Companies, Employees, and Phones
Answer Description:
You should create the tables in the following order: Companies, Employees, and Phones. You should create the Companies table before the Employees table because Employees references Companies using a foreign key.
References:
Microsoft Docs > CREATE TABLE (Transact-SQL)
Microsoft Docs > Create Foreign Key Relationships