- All Exams Instant Download
What should you use to migrate the PostgreSQL database?
What should you use to migrate the PostgreSQL database?A . Azure Data BoxB . AzCopyC . Azure Database Migration ServiceD . Azure Site RecoveryView AnswerAnswer: C Explanation: Reference: https://docs.microsoft.com/en-us/azure/dms/dms-overview
Which counter should you monitor for real-time processing to meet the technical requirements?
Which counter should you monitor for real-time processing to meet the technical requirements?A . SU% UtilizationB . CPU% utilizationC . Concurrent usersD . Data Conversion ErrorsView AnswerAnswer: B Explanation: Scenario: Real-time processing must be monitored to ensure that workloads are sized properly based on actual usage patterns. To monitor the...
Which four actions should you perform in sequence to resolve the issue?
DRAG DROP You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database. A recent failure causes the master database to be lost. You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run on the virtual machine. Which four actions should you...
Which three actions should you perform in sequence?
DRAG DROP You create all of the tables and views for ResearchDB1. You need to implement security for ResearchDB1. The solution must meet the security and compliance requirements. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer...
Which feature should you use to provide customers with the required level of access based on their service agreement?
You are evaluating the business goals. Which feature should you use to provide customers with the required level of access based on their service agreement?A . dynamic data maskingB . Conditional Access in AzureC . service principalsD . row-level security (RLS)View AnswerAnswer: D Explanation: Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql- server-ver15
What should you create on VNet1?
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1. You need to implement connectivity between VM1 and SqlDb1 to meet the following...
What should you use?
You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?A . two Azure SQL Databases in an elastic poolB . two databases hosted in SQL Server on an Azure...
Which windowing function should you use to perform the streaming aggregation of the sales data?
Topic 3, ADatum Corporation This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that...
What should you include in the migration plan?
Topic 1, Litware Existing Environment Network Environment The manufacturing and research datacenters connect to the primary datacenter by using a VPN. The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering. The private peering connects to an Azure virtual network named HubVNet. Identity Environment Litware...
What should you run?
You have an Azure SQL database named sqldb1. You need to minimize the amount of space by the data and log files of sqldb1. What should you run?A . DBCC SHRINKDATABASEB . sp_clean_db_free_spaceC . sp_clean_db_file_free_spaceD . DBCC SHRINKFILEView AnswerAnswer: D Explanation: DBCC SHRINKDATABASE shrinks the size of the data and...
