Answer:- The database engine uses intent locks to protect placing a shared (S) lock or an exclusive (X) lock on a resource (lower in the lock hierarchy). Intent locks are named thus because they are acquired before a lock at the lower level and therefore signal the intent to place the locks at a lower level. Intent locks serve two purposes: • They prevent other transactions from modifying a higher-level resource in a way that would invalidate the lock at the lower level. • They improve the efficiency of the database engine in detecting lock conflicts at a higher level of granularity.

Answer:- The graphical execution plan should be read from Right to Left: • Check the graphical execution plan of a stored procedure/query • Table Scan: Index is missing • Index Scan: Proper indexes are not used • BookMark Lookup: Limits the number of columns in the select list • Filter: Removes any functions from the WHERE clause; may require additional indexes • Sort: Checks if the data really needs to be sorted, if an index can be used to avoid sorting, and if sorting can be done at the client-side more efficiently? • DataFlow Arrow (high density): Sometimes, we find few rows as the outcome, but the arrow line density indicates the query/proc processing huge number of rows • Cost: Easily finds out which table/operation taking much time

Answer:- Either a user must be mapped to sysadmin/db_owner/db_creator or the user will be granted the below permission: GRANT SHOWPLAN TO [username]

Answer:- Cloud service can convey multiple web applications in Azure, characterizing a number of parts to disseminate handling and permit adaptable scaling of your application. A cloud service comprises a minimum of one web part, as well as specialist parts, each with its own particular application documents and design. The fundamental favorable position of cloud service is the capacity to help more complex multilevel structures.

Answer:- Azure DevOps is a SaaS platform that provides development services for creating work plans, working together on code, developing applications, and deploying them. It offers an end-to-end DevOps toolchain for the development and deployment of software. It is able to integrate with a number of popular tools in the market and is a great way for setting up a DevOps toolchain.

Answer:- Azure AD is a cloud-based IAM solution and directory by Microsoft. It brings together application access management, core directory services, and identity protection and turns them into a single solution. It helps employees of an organization sign in and access resources such as: • External resources, including Microsoft 365, the Azure portal, and a big number of SaaS applications • Internal resources, such as apps on a corporate network and intranet, as well as any cloud-based apps built by that organization Azure AD is intended for use by: • IT Admins • App Developers • Azure, Office 365, Microsoft 365, or Dynamics CRM online subscribers

Answer:- Azure Data Factory is a serverless and cloud-based data integration service and platform used for the creation of ETL and ELT pipelines. It helps in the creation of data-driven workflows for the planning and execution of data movements and data transformation at scale.

Answer:- Azure Databricks is a Data Analytics platform that offers two environments for the development of data-intensive applications: • Azure Databricks SQL Analytics • Azure Databricks Workspace Azure Databricks’ integration with the security, compute, analytics, storage, and AI services that are natively provided by cloud providers facilitate the unification of data and AI workloads.

Answer:- Azure Data Lake is a cloud platform that supports Big Data Analytics through its unlimited storage for structured, semi-structured, or unstructured data of all types and sizes.

Answer:- Any entity managed by Azure can be referred to as an Azure resource. The following are some examples of Azure resources: Storage accounts, virtual networks, virtual machines, etc.

Answer:- • Web Role • Worker Role • Virtual Machine Role

Answer:- Web Role: It gives a web solution that is front-end. This is like an ASP.NET application. While under facilitating, Azure gives IIS and required services. Worker Role: It gives solutions for background service. It can run long activities. Virtual Machine Role: The roles of both web and worker are executed on virtual machines. The Virtual Machine Roles give the client the capacity to modify the Azure Virtual Machine on which the web and worker roles are running.

Answer:- Windows Azure has three principal segments: Compute, Storage, and Fabric. A. Windows Azure Compute Windows Azure gives a code that can be managed by the hosting environment. It gives the calculation benefit through parts. Windows Azure backs three types of roles: • Web roles utilized for web application programming and upheld by IIS7 • Worker roles utilized for foundation handling of web roles • Virtual machine (VM) roles utilized for moving windows server applications to Windows Azure in a simple way B. Windows Azure Storage It gives four types of storage services: • Queues for informing between web parts and worker roles • Tables for storing structural data • BLOBs (Binary Large Objects) to store contents, records, or vast information • Windows Azure Drives (VHD) to mount a page BLOB. These can be transferred and downloaded by means of BLOBs C. Windows Azure AppFabric AppFabric provides five services: • Service bus • Access • Caching • Integration • Composite

Answer:- Windows Azure Diagnostics empowers you to gather diagnostic data from an application running in Windows Azure. Diagnostic data is used for capacity planning and evaluation.