You have an Azure subscription.You plan to deploy an app that will store data across multiple databases.You need to recommend a storage solution for the app. The solution must meet the following requirements:Ensure that queries can be executed simultaneously across all the databases.Minimize development effort.Minimize query latency.What should you include in the recommendation?
Answer(s): C
Azure SQL Database elastic queryApplies to: Azure SQL DatabaseThe elastic query feature (in preview) enables you to run a Transact-SQL (T-SQL) query that spans multiple databases in Azure SQL Database. It allows you to perform cross-database queries to access remote tables, and to connect Microsoft and third-party tools (Excel, Power BI, Tableau, etc.) to query across data tiers with multiple databases. Using this feature, you can scale out queries to large data tiers and visualize the results in business intelligence (BI) reports.
HOTSPOT (Drag and Drop is not supported)You have the following projects:Project1: A rapidly iterating cloud-based solution that integrates multiple Azure software as a service (SaaS)solutionsProject2: The migration of a 5-TB on-premises database to AzureProject3: The migration of a 30-TB on-premises database to AzureThe projects have the requirements shown in the following table.You need to recommend a database solution for the projects.What should you include in the recommendation for each project? To answer, select the appropriate options in the answer area.Note: Each correct selection is worth one point.Hot Area:
Answer(s): A
Box 1: SQL Server on Azure Virtual MachinesProject1: A rapidly iterating cloud-based solution that integrates multiple Azure software as a service (SaaS) solutionsRequirements:Minimize costs.Minimize administrative effort associated with operating system administration.In Azure, you can have your SQL Server workloads running as a hosted service (PaaS), or a hosted infrastructure (IaaS) supporting the software layer, such as Software-as-a-Service (SaaS) or an application.SQL Server on Azure Virtual Machines is a fast and straightforward migration infrastructure as a service (IaaS) option, but it requires a more hands-on approach to database administration.Box 2: Azure SQL Managed instanceProject2: The migration of a 5-TB on-premises database to Azure Requirements:Minimize how long it takes to migrate the database.Minimize administrative effort associated with operating system updates and backups.SQL Managed Instance supports database migration from on-premises with minimal to no database changes.Maximum database size: Up to 16 TB.Azure SQL Managed Instance falls into the industry category of Platform-as-a-Service (PaaS), and is best for most migrations to the cloud. SQL Managed Instance is a collection of system and user databases with a shared set of resources that is lift-and-shift ready.Incorrect:* Azure SQL DatabaseMigration from SQL Server might be challenging.Box 3: Azure SQL DatabaseProject3: The migration of a 30-TB on-premises database to Azure Requirements:Minimize how long it takes to migrate the database.Minimize administrative effort associated with operating system updates and backups.Azure SQL Databases of up to 128 TB.Migration from SQL Server might be challenging.Compatibility with the SQL Server version can be achieved only using database compatibility levels.
https://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview
You have 100 servers that run Windows Server and host Microsoft SQL Server 2014 instances. The instances host databases that have the following characteristics:Stored procedures are implemented by using CLR.The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.You plan to move all the data from SQL Server to Azure.You need to recommend a service to host the databases. The solution must meet the following requirements:Whenever possible, minimize management overhead for the migrated databases.Ensure that users can authenticate by using Azure AD credentials.Minimize the number of database changes required to facilitate the migration.What should you include in the recommendation?
Answer(s): B
SQL Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, SQL Managed Instance preserves all PaaS capabilities (automatic patching and version updates, automated backups, high availability) that drastically reduce management overhead and TCO.
You have an Azure subscription that contains an Azure Blob Storage account named store1.You have an on-premises file server named Server1 that runs Windows Server. Server1 stores 500 GB of company files.You need to store a copy of the company files from Server1 in store1.Which two possible Azure services achieve this goal? Each correct answer presents a complete solution.Note: Each correct selection is worth one point.
Answer(s): B,C
B: You can use the Azure Import/Export service to securely export large amounts of data from Azure Blob storage. The service requires you to ship empty drives to the Azure datacenter. The service exports data from your storage account to the drives and then ships the drives back.C: Big data requires a service that can orchestrate and operationalize processes to refine these enormous stores of raw data into actionable business insights. Azure Data Factory is a managed cloud service that’s built for these complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.
You have an Azure subscription that contains two applications named App1 and App2. App1 is a sales processing application. When a transaction in App1 requires shipping, a message is added to an Azure Storage account queue, and then App2 listens to the queue for relevant transactions.In the future, additional applications will be added that will process some of the shipping requests based on the specific details of the transactions.You need to recommend a replacement for the storage account queue to ensure that each additional application will be able to read the relevant transactions.What should you recommend?
Answer(s): D
A queue allows processing of a message by a single consumer. In contrast to queues, topics and subscriptions provide a one-to-many form of communication in a publish and subscribe pattern. It’s useful for scaling to large numbers of recipients. Each published message is made available to each subscription registered with the topic. Publisher sends a message to a topic and one or more subscribers receive a copy of the message, depending on filter rules set on these subscriptions.
Post your Comments and Discuss Microsoft AZ-305 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the AZ-305 content, but please register or login to continue.