Which feature should you use to provide customers with the required level of access based on their service agreement?

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...

January 10, 2023 No Comments READ MORE +

Does this meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

January 10, 2023 No Comments READ MORE +

Which three actions should you perform?

You have a new Azure SQL database. The database contains a column that stores confidential information. You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed. Which three actions...

January 9, 2023 No Comments READ MORE +

What should you include in the solution?

HOTSPOT You have an Azure SQL database named DB1 that contains a table named Orders. The Orders table contains a row for each sales order. Each sales order includes the name of the user who placed the order. You need to implement row-level security (RLS). The solution must ensure that...

January 9, 2023 No Comments READ MORE +

Which two additional metrics should you monitor?

You have an Azure Stream Analytics job. You need to ensure that the job has enough streaming units provisioned. You configure monitoring of the SU % Utilization metric. Which two additional metrics should you monitor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one...

January 9, 2023 No Comments READ MORE +

What should you recommend?

HOTSPOT You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point....

January 9, 2023 No Comments READ MORE +

What should you include in the plan?

You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements. What should you include in the plan?A . Configure the Deleted databases settings for ResearchSrvOL B. Deploy and configure an Azure Backup server. C. Configure the Advanced Data...

January 9, 2023 No Comments READ MORE +

What should you use to minimize downtime and data loss during the migration?

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. You plan to migrate DB1 to an Azure SQL Database managed instance. What should you use to minimize downtime and data loss during the migration?A . distributed availability groups B....

January 8, 2023 No Comments READ MORE +

Which distribution type should you recommend to minimize data movement?

You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date dimension table will be used by all the fact tables. Which distribution type should you recommend to minimize data movement?A . HASH B. REPLICATE C. ROUND_ROBINView AnswerAnswer: B Explanation: A replicated table has...

January 8, 2023 No Comments READ MORE +

Which two actions should you perform?

You receive numerous alerts from Azure Monitor for an Azure SQL database. You need to reduce the number of alerts. You must only receive alerts if there is a significant change in usage patterns for an extended period. Which two actions should you perform? Each correct answer presents part of...

January 8, 2023 No Comments READ MORE +