Question 850
The planned architecture is: Use Azure Migrate database assessment and supported SQL assessment tools to identify blockers and target recommendations. Workload context: An enterprise plans to move a SQL Server estate but needs evidence on unsupported compatibility features and target readiness before choosing Azure SQL. Which acceptance test demonstrates that the required behavior works?
- Run assessment against a representative SQL Server and review compatibility findings before migration.
- Compare discovered machines and dependency maps to known inventory, then review assessment sizing results.
- Compare recommendation sizing and total cost model with sampled observed VM metrics and licensing.
- Rehearse replication/cutover, validate row counts and measure actual outage duration.
Explanation
Correct Answer
A:The decisive evidence is: Run assessment against a representative SQL Server and review compatibility findings before migration. This measures the mechanism of the planned change, not an unrelated Azure service: Use Azure Migrate database assessment and supported SQL assessment tools to identify blockers and target recommendations.
Incorrect Answers
B:This check validates a different workload: Compare discovered machines and dependency maps to known inventory, then review assessment sizing results. Its associated design is: Use Azure Migrate discovery and assessment with a suitable appliance and performance-based sizing. The required acceptance test here is: Run assessment against a representative SQL Server and review compatibility findings before migration.
C:That observation pertains to a separate failure: A migration proposal assumes every on-prem CPU must map to an equally large Azure VM. Its cause is: The cost model ignores actual measured utilization and licensing optimization. It does not confirm the result of this design. The direct proof would be: Run assessment against a representative SQL Server and review compatibility findings before migration.
D:The alternative test targets: Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability. The scenario's actual proposed remedy is: Use Azure Migrate database assessment and supported SQL assessment tools to identify blockers and target recommendations. Verify that one by: Run assessment against a representative SQL Server and review compatibility findings before migration.
Question 851
The customer states: An enterprise plans to move a SQL Server estate but needs evidence on unsupported compatibility features and target readiness before choosing Azure SQL. An incident reveals: Applications are moved to Azure SQL Database then break due to unassessed SQL Agent dependencies. What cause best accounts for this evidence?
- The cost model ignores actual measured utilization and licensing optimization.
- No structured server discovery and utilization assessment was completed.
- Database service selection preceded discovery of instance-level feature requirements.
- Migration mode and cutover sequencing do not meet the allowed service interruption.
Explanation
Correct Answer
C:This is the failure mechanism rather than an incidental symptom: Database service selection preceded discovery of instance-level feature requirements. It accounts for: Applications are moved to Azure SQL Database then break due to unassessed SQL Agent dependencies. The architectural repair is: Use Azure Migrate database assessment and supported SQL assessment tools to identify blockers and target recommendations.
Incorrect Answers
A:The alternative weakness is: The cost model ignores actual measured utilization and licensing optimization. Its associated failure is: A migration proposal assumes every on-prem CPU must map to an equally large Azure VM. Neither explains the present observation: Applications are moved to Azure SQL Database then break due to unassessed SQL Agent dependencies. The direct cause here is: Database service selection preceded discovery of instance-level feature requirements.
B:This cause would explain a different symptom: Migration planning uses manually guessed VM sizes and misses application dependencies. The mechanism for that event is: No structured server discovery and utilization assessment was completed. Here the stated symptom is: Applications are moved to Azure SQL Database then break due to unassessed SQL Agent dependencies. Its cause is: Database service selection preceded discovery of instance-level feature requirements.
D:The alternative weakness is: Migration mode and cutover sequencing do not meet the allowed service interruption. Its associated failure is: A single manual full backup transfer misses the approved migration downtime target. Neither explains the present observation: Applications are moved to Azure SQL Database then break due to unassessed SQL Agent dependencies. The direct cause here is: Database service selection preceded discovery of instance-level feature requirements.
Question 852
Workload context: An enterprise plans to move a SQL Server estate but needs evidence on unsupported compatibility features and target readiness before choosing Azure SQL. The implemented remedy is: Use Azure Migrate database assessment and supported SQL assessment tools to identify blockers and target recommendations. Which ongoing practice most specifically prevents recurrence of this failure: Applications are moved to Azure SQL Database then break due to unassessed SQL Agent dependencies.?
- Refresh the cost model when rightsizing and workload commitments change.
- Track assessment blockers and reassess when application versions change.
- Document rollback point and source write-freeze rules during migration.
- Refresh discovery data and application grouping before every migration wave.
Explanation
Correct Answer
B:The preventive control is: Track assessment blockers and reassess when application versions change. It targets the earlier cause: Database service selection preceded discovery of instance-level feature requirements. Confirm ongoing effectiveness by: Run assessment against a representative SQL Server and review compatibility findings before migration.
Incorrect Answers
A:The proposed control focuses on: The cost model ignores actual measured utilization and licensing optimization. For the design in the question, recurrence comes from: Database service selection preceded discovery of instance-level feature requirements. A precise prevention step is: Track assessment blockers and reassess when application versions change.
C:This is a reasonable safeguard for a different fault: A single manual full backup transfer misses the approved migration downtime target. That different mechanism is: Migration mode and cutover sequencing do not meet the allowed service interruption. The original incident here instead arises from: Database service selection preceded discovery of instance-level feature requirements. The directly relevant safeguard is: Track assessment blockers and reassess when application versions change.
D:The proposed control focuses on: No structured server discovery and utilization assessment was completed. For the design in the question, recurrence comes from: Database service selection preceded discovery of instance-level feature requirements. A precise prevention step is: Track assessment blockers and reassess when application versions change.
Question 853
A solution architect is reviewing a workload: A high-volume SQL Server database must be moved to Azure SQL Managed Instance with carefully controlled downtime and verification. The observed incident is: A single manual full backup transfer misses the approved migration downtime target. Which architecture choice most directly removes the identified weakness?
- Use the supported Azure Migrate server-migration workflow with replication, test migration and final cutover.
- Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability.
- Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination.
- Use Azure Migrate database assessment and supported SQL assessment tools to identify blockers and target recommendations.
Explanation
Correct Answer
B:The evidence (A single manual full backup transfer misses the approved migration downtime target.) identifies the following cause: Migration mode and cutover sequencing do not meet the allowed service interruption. The design that removes it is: Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability. The acceptance check is: Rehearse replication/cutover, validate row counts and measure actual outage duration.
Incorrect Answers
A:That design instead addresses another observed condition: A one-time disk copy causes extended outage and incomplete changes after initial transfer. Its technical cause is: A continuous migration replication and controlled cutover process was not planned. The current workload exhibits: A single manual full backup transfer misses the approved migration downtime target. Its targeted remedy is: Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability.
C:The option belongs to a different failure mechanism: The chosen copy workflow does not preserve required file migration semantics. That situation exhibits: A homegrown transfer misses file timestamps and directory layout on repeated retries. For the stated case, the remedy is: Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability.
D:That design instead addresses another observed condition: Applications are moved to Azure SQL Database then break due to unassessed SQL Agent dependencies. Its technical cause is: Database service selection preceded discovery of instance-level feature requirements. The current workload exhibits: A single manual full backup transfer misses the approved migration downtime target. Its targeted remedy is: Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability.
Question 854
An architect proposes this change: Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability. The workload context is: A high-volume SQL Server database must be moved to Azure SQL Managed Instance with carefully controlled downtime and verification. Which evidence would most directly validate the change?
- Run a test transfer and compare file tree, permissions/metadata and incremental changes.
- Run a nonproduction test migration and validate application services before committing final cutover.
- Run assessment against a representative SQL Server and review compatibility findings before migration.
- Rehearse replication/cutover, validate row counts and measure actual outage duration.
Explanation
Correct Answer
D:This observation directly verifies the intended design: Rehearse replication/cutover, validate row counts and measure actual outage duration. The architecture being tested is: Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability. The original symptom was: A single manual full backup transfer misses the approved migration downtime target.
Incorrect Answers
A:This check validates a different workload: Run a test transfer and compare file tree, permissions/metadata and incremental changes. Its associated design is: Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination. The required acceptance test here is: Rehearse replication/cutover, validate row counts and measure actual outage duration.
B:That observation pertains to a separate failure: A one-time disk copy causes extended outage and incomplete changes after initial transfer. Its cause is: A continuous migration replication and controlled cutover process was not planned. It does not confirm the result of this design. The direct proof would be: Rehearse replication/cutover, validate row counts and measure actual outage duration.
C:The alternative test targets: Use Azure Migrate database assessment and supported SQL assessment tools to identify blockers and target recommendations. The scenario's actual proposed remedy is: Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability. Verify that one by: Rehearse replication/cutover, validate row counts and measure actual outage duration.
Question 855
During architecture troubleshooting, a team reports: A single manual full backup transfer misses the approved migration downtime target. Context: A high-volume SQL Server database must be moved to Azure SQL Managed Instance with carefully controlled downtime and verification. Which underlying design mistake explains the observed behavior most precisely?
- Database service selection preceded discovery of instance-level feature requirements.
- A continuous migration replication and controlled cutover process was not planned.
- The chosen copy workflow does not preserve required file migration semantics.
- Migration mode and cutover sequencing do not meet the allowed service interruption.
Explanation
Correct Answer
D:The incident is explained by: Migration mode and cutover sequencing do not meet the allowed service interruption. The reported symptom is: A single manual full backup transfer misses the approved migration downtime target. The corresponding design fix is: Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability.
Incorrect Answers
A:This cause would explain a different symptom: Applications are moved to Azure SQL Database then break due to unassessed SQL Agent dependencies. The mechanism for that event is: Database service selection preceded discovery of instance-level feature requirements. Here the stated symptom is: A single manual full backup transfer misses the approved migration downtime target. Its cause is: Migration mode and cutover sequencing do not meet the allowed service interruption.
B:The proposed diagnosis fits another scenario: A continuous migration replication and controlled cutover process was not planned. It would typically be reflected by: A one-time disk copy causes extended outage and incomplete changes after initial transfer. The current evidence instead supports: Migration mode and cutover sequencing do not meet the allowed service interruption.
C:The alternative weakness is: The chosen copy workflow does not preserve required file migration semantics. Its associated failure is: A homegrown transfer misses file timestamps and directory layout on repeated retries. Neither explains the present observation: A single manual full backup transfer misses the approved migration downtime target. The direct cause here is: Migration mode and cutover sequencing do not meet the allowed service interruption.
Question 856
The design change is: Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability. The original failure was: A single manual full backup transfer misses the approved migration downtime target. Which ongoing control best prevents recurrence of the same root cause?
- Rehearse test migration, cleanup and rollback after source VM changes.
- Track assessment blockers and reassess when application versions change.
- Document rollback point and source write-freeze rules during migration.
- Run incremental delta verification before final user cutover.
Explanation
Correct Answer
C:The key follow-up control is: Document rollback point and source write-freeze rules during migration. It avoids recurrence of the scenario in which: A single manual full backup transfer misses the approved migration downtime target. It addresses: Migration mode and cutover sequencing do not meet the allowed service interruption.
Incorrect Answers
A:That safeguard manages another risk: A continuous migration replication and controlled cutover process was not planned. Its scenario is: A one-time disk copy causes extended outage and incomplete changes after initial transfer. The present recurring risk is: Migration mode and cutover sequencing do not meet the allowed service interruption. The proper ongoing control is: Document rollback point and source write-freeze rules during migration.
B:This is a reasonable safeguard for a different fault: Applications are moved to Azure SQL Database then break due to unassessed SQL Agent dependencies. That different mechanism is: Database service selection preceded discovery of instance-level feature requirements. The original incident here instead arises from: Migration mode and cutover sequencing do not meet the allowed service interruption. The directly relevant safeguard is: Document rollback point and source write-freeze rules during migration.
D:That safeguard manages another risk: The chosen copy workflow does not preserve required file migration semantics. Its scenario is: A homegrown transfer misses file timestamps and directory layout on repeated retries. The present recurring risk is: Migration mode and cutover sequencing do not meet the allowed service interruption. The proper ongoing control is: Document rollback point and source write-freeze rules during migration.
Question 857
A design workshop has this requirement: A company must migrate millions of SMB files from on-premises shares into Azure Files while maintaining hierarchy and metadata where supported. Operators currently observe: A homegrown transfer misses file timestamps and directory layout on repeated retries. Select the ONE design remedy that best addresses the root cause.
- Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination.
- Choose supported Azure Database Migration Service or equivalent approved migration workflow matching offline/online capability.
- Deploy Azure File Sync with a registered server endpoint and cloud endpoint for progressive file access migration.
- Use the supported Azure Migrate server-migration workflow with replication, test migration and final cutover.
Explanation
Correct Answer
A:The evidence (A homegrown transfer misses file timestamps and directory layout on repeated retries.) identifies the following cause: The chosen copy workflow does not preserve required file migration semantics. The design that removes it is: Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination. The acceptance check is: Run a test transfer and compare file tree, permissions/metadata and incremental changes.
Incorrect Answers
B:The option belongs to a different failure mechanism: Migration mode and cutover sequencing do not meet the allowed service interruption. That situation exhibits: A single manual full backup transfer misses the approved migration downtime target. For the stated case, the remedy is: Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination.
C:That design instead addresses another observed condition: Moving the entire share at once disrupts users dependent on local UNC paths. Its technical cause is: No staged file synchronization and local cache architecture was planned. The current workload exhibits: A homegrown transfer misses file timestamps and directory layout on repeated retries. Its targeted remedy is: Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination.
D:This choice mitigates an alternative scenario, where: A one-time disk copy causes extended outage and incomplete changes after initial transfer. The underlying issue there is: A continuous migration replication and controlled cutover process was not planned. Here the root issue is: The chosen copy workflow does not preserve required file migration semantics. Choose the corresponding action: Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination.
Question 858
The planned architecture is: Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination. Workload context: A company must migrate millions of SMB files from on-premises shares into Azure Files while maintaining hierarchy and metadata where supported. Which acceptance test demonstrates that the required behavior works?
- Rehearse replication/cutover, validate row counts and measure actual outage duration.
- Sync a test folder and verify cloud share content and on-prem client access remain consistent.
- Run a nonproduction test migration and validate application services before committing final cutover.
- Run a test transfer and compare file tree, permissions/metadata and incremental changes.
Explanation
Correct Answer
D:The acceptance test is specific: Run a test transfer and compare file tree, permissions/metadata and incremental changes. Its purpose is to establish that the proposed architecture works: Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination.
Incorrect Answers
A:That observation pertains to a separate failure: A single manual full backup transfer misses the approved migration downtime target. Its cause is: Migration mode and cutover sequencing do not meet the allowed service interruption. It does not confirm the result of this design. The direct proof would be: Run a test transfer and compare file tree, permissions/metadata and incremental changes.
B:The alternative test targets: Deploy Azure File Sync with a registered server endpoint and cloud endpoint for progressive file access migration. The scenario's actual proposed remedy is: Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination. Verify that one by: Run a test transfer and compare file tree, permissions/metadata and incremental changes.
C:This check validates a different workload: Run a nonproduction test migration and validate application services before committing final cutover. Its associated design is: Use the supported Azure Migrate server-migration workflow with replication, test migration and final cutover. The required acceptance test here is: Run a test transfer and compare file tree, permissions/metadata and incremental changes.
Question 859
The customer states: A company must migrate millions of SMB files from on-premises shares into Azure Files while maintaining hierarchy and metadata where supported. An incident reveals: A homegrown transfer misses file timestamps and directory layout on repeated retries. What cause best accounts for this evidence?
- No staged file synchronization and local cache architecture was planned.
- The chosen copy workflow does not preserve required file migration semantics.
- A continuous migration replication and controlled cutover process was not planned.
- Migration mode and cutover sequencing do not meet the allowed service interruption.
Explanation
Correct Answer
B:The recorded behavior follows from: The chosen copy workflow does not preserve required file migration semantics. The appropriate mitigation would be: Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination. Verify with: Run a test transfer and compare file tree, permissions/metadata and incremental changes.
Incorrect Answers
A:The proposed diagnosis fits another scenario: No staged file synchronization and local cache architecture was planned. It would typically be reflected by: Moving the entire share at once disrupts users dependent on local UNC paths. The current evidence instead supports: The chosen copy workflow does not preserve required file migration semantics.
C:This cause would explain a different symptom: A one-time disk copy causes extended outage and incomplete changes after initial transfer. The mechanism for that event is: A continuous migration replication and controlled cutover process was not planned. Here the stated symptom is: A homegrown transfer misses file timestamps and directory layout on repeated retries. Its cause is: The chosen copy workflow does not preserve required file migration semantics.
D:The proposed diagnosis fits another scenario: Migration mode and cutover sequencing do not meet the allowed service interruption. It would typically be reflected by: A single manual full backup transfer misses the approved migration downtime target. The current evidence instead supports: The chosen copy workflow does not preserve required file migration semantics.
Question 860
Workload context: A company must migrate millions of SMB files from on-premises shares into Azure Files while maintaining hierarchy and metadata where supported. The implemented remedy is: Use Azure Storage Mover or a suitable supported managed file migration workflow for the source and destination. Which ongoing practice most specifically prevents recurrence of this failure: A homegrown transfer misses file timestamps and directory layout on repeated retries.?
- Rehearse test migration, cleanup and rollback after source VM changes.
- Run incremental delta verification before final user cutover.
- Document rollback point and source write-freeze rules during migration.
- Monitor cloud tiering and synchronization errors during each cutover phase.
Explanation
Correct Answer
B:The key follow-up control is: Run incremental delta verification before final user cutover. It avoids recurrence of the scenario in which: A homegrown transfer misses file timestamps and directory layout on repeated retries. It addresses: The chosen copy workflow does not preserve required file migration semantics.
Incorrect Answers
A:This is a reasonable safeguard for a different fault: A one-time disk copy causes extended outage and incomplete changes after initial transfer. That different mechanism is: A continuous migration replication and controlled cutover process was not planned. The original incident here instead arises from: The chosen copy workflow does not preserve required file migration semantics. The directly relevant safeguard is: Run incremental delta verification before final user cutover.
C:That safeguard manages another risk: Migration mode and cutover sequencing do not meet the allowed service interruption. Its scenario is: A single manual full backup transfer misses the approved migration downtime target. The present recurring risk is: The chosen copy workflow does not preserve required file migration semantics. The proper ongoing control is: Run incremental delta verification before final user cutover.
D:This is a reasonable safeguard for a different fault: Moving the entire share at once disrupts users dependent on local UNC paths. That different mechanism is: No staged file synchronization and local cache architecture was planned. The original incident here instead arises from: The chosen copy workflow does not preserve required file migration semantics. The directly relevant safeguard is: Run incremental delta verification before final user cutover.
Designing Microsoft Azure Infrastructure Solutions (AZ-305) Practice Tests