Data Engineer Interview Questions and Answers: SQL Workload Migration to Microsoft Azure Database Platforms

data-engineer-interview-questions-and-answers

In this article, we will talk about various inquiries that you may confront when being met to a Microsoft Azure Data Engineer position. These inquiries will concentrate on the way toward moving the SQL Server databases from the on-premises occasions to the Microsoft Azure database administrations.

Before talking about the inquiries questions and replies, it is smarter to show quickly what the distinction between the database chairman and the Microsoft Azure Data Engineer positions is. Essentially, while moving from the on-premises SQL Server databases organization to administrating Azure database stages, known as the Data Engineer, you will stretch out your duties to administrate the unstructured data and new data types, for example, streaming data. It requires likewise figuring out how to utilize new arrangement of instruments, stages, extra advancements like HDInsight and Cosmos DB, and dialects, for example, Hive or Python.

Q1: You are functioning as a data engineer in an organization. You are mentioned to move four databases to Microsoft Azure. These databases contain cross-database inquiries that recover data from different databases. What is the objective Azure data stage that you will use to meet your necessities?

SQL Server on Azure Virtual Machine is the best option that helps in migrating multiple databases that can interact together using cross-database queries.

Q2: As a data engineer in a global organization, you are mentioned to relocate 18 OLTP databases to Microsoft Azure. During the greater part of the weekdays, the databases usage isn’t high. In any case, during barely any days from every week, countless records will be stacked to these databases, requiring extra resources to load and procedure the data. What is the objective Azure data stage that you will use to meet your prerequisites?

Azure SQL Database Elastic Pools is the best choice for the hosting databases with unstable workload in Azure.

Q3: Before moving your database to Microsoft Azure, you need a device to draw a stock for you SQL servers, the servers setups and the administrations introduced in every server. Which instrument will meet your necessities?

The Microsoft Assessment and Planning Toolkit.

Q4: You are functioning as a data engineer in a worldwide organization. You are utilizing the Microsoft Assessment and Planning Toolkit to create a stock for your on-premises servers before relocating the database facilitated in these servers to Microsoft Azure. At the point when you surveyed the stock, it is discovered that a few servers are missed from the rundown. What could be the explanation for missing these servers?

The servers could be missed from the list because the Remote Administration is not enabled on these servers or these servers are not within the scope of the used discovery method.

Q5: You are attempting to utilize the Data Migration Assistant apparatus to survey in excess of 35 databases facilitated in an on-premises SQL Server case before relocated it to the Microsoft Azure database stage, however the evaluation procedure planned out. How might you alleviate that break issue?

You should change the assessment parallelDatabases option from the dma.exe.config configuration file from 8 to 1.

Q6: You are attempting to utilize the Data Migration Assistant apparatus to evaluate your databases that are facilitated in an on-premises SQL Server occurrence before relocated it to the Microsoft Azure database stage, yet the appraisal procedure fizzled with an authorization blunder. How might you relieve that authorization issue?

Add the user who is running the Data Migration Assistant tool to the sysadmin SQL Server fixed role.

Q7: Working as a data engineer in a worldwide organization that has a Microsoft Enterprise Agreement including all SQL Servers facilitated in your system, you intend to relocate these SQL Server databases to a SQL Server example facilitated in an Azure VM. What is the appropriate permit mode for the SQL Server on Azure VM stage that meets your situation?

Bring Your Own License (BYOL) mode.

Q8: You are attempting to relocate a huge SQL Server database that is facilitated in an on-premises server to a SQL Server example that facilitated in an Azure VM. You intend to utilize the Backup and Restore movement strategy and the normal size of the compacted reinforcement file is 1.5TB. which circle volume type ought to be utilized to have the created reinforcement?

As the maximum size of the VM disk is 1 TB, you should use stripped disk volume for any backup file larger than 1 TB.

Q9: You are filling in as a data engineer in an organization. You are mentioned to move two business-basic SQL Server databases that are facilitated in a SQL Server 2008 R2 and SQL Server 2012 occurrences to Microsoft Azure with the insignificant conceivable personal time. Which strategy will you use to meet your prerequisites?

You can use the Transactional Replication method to migrate the database hosted in the SQL Server 2008 R2 instance and the Always On Availability Group for the database hosted in the SQL Server 2012 instance to Microsoft Azure with minimal downtime.

Q10: You are setting up an arrangement to move your SQL Server databases to Microsoft Azure. Before relocating it, you have to survey these databases for any similarity or movement blocking issue. Which device will you use to meet your necessities?

The Data Migration Assistant tool.

Q11: You are attempting to reestablish a reinforcement file taken fourteen days prior from the Azure SQL Database, sent utilizing Standard assistance level. Will you have the option to reestablish that reinforcement?

Yes, as backup file that is automatically taken from Azure SQL Database can be kept up to 35 days.

Q12: You are approached to move your SQL Server databases facilitated in on-premises servers to Azure SQL Database Managed Instance. What is the most minimal similarity level for the databases that will be considered in that relocation venture?

SQL Server 2008 with compatibility level 100 is the lowest supported version in Azure SQL Database Managed Instance.

Q13: You are attracting an arrangement to relocate your SQL Server databases to Microsoft Azure. In your arrangement, you have to choose which choice can be utilized to make a private and secure association between your on-premises foundation and the Azure datacenters. Which organizing alternative will meet your necessities?

ExpressRoute is the best option for building a private and secure connection between on-premises and Azure.

Q14: You are intending to relocate your SQL Server database from an on-premises SQL Server case to Azure SQL Database. While getting ready for the movement procedure, you find that the SQL Agent Jobs that are planned on the source database and ought to be booked on the database after the relocation. How you could alleviate that issue in Azure?

As the SQL Agent jobs are not supported in Azure SQL Database, you can use the Azure Automation and Elastic Database jobs to schedule your tasks in Azure.

Q15:While attempting to move you databases from an on-premises SQL Server case to an Azure SQL Database Managed Instance utilizing Backup/Restore from URL, you find that you can’t associate with the provisioned Azure SQL Database Managed Instance utilizing the SQL Server Managed Studio introduced in your machine, so as to reestablish the database reinforcement. How might you relieve that issue?

As the Azure SQL Database Managed Instance is securely isolated, there are two methods that can be used to connect to it: configuring a point-to-site VPN connection from on-premises to Azure MI or installing a new Virtual Machine in the same VNET of the Azure SQL Database MI under another subnet.