Interviews Questions

What is SQL Server Management Studio?
SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server.

What is SQL Server Data Tools?

SQL Server Data Tools is a modern development tool that you can download for free to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

What is Symmetric Multi-Processing (SMP) System?
Symmetric Multi-Processing (SMP) is a tightly coupled multiprocessor system where processors share resources – single instances of the Operating System (OS), memory, I/O devices and connected using a common bus. 

What is Massively Parallel Processing (MPP) System?
Massively Parallel Processing (MPP) is the coordinated processing of a single task by multiple processors, each processor using its own OS and memory and communicating with each other using some form of messaging interface. MPP can be setup with a shared nothing or shared disk architecture.

What is Azure App Services?
Azure App Service is a one-of-a-kind cloud platform to build powerful web and mobile apps that connect to data anywhere, in the cloud or on-premises in a simpler way. These capabilities allows organizations to design and deliver amazing apps significantly faster than using traditional development process. 
Organizations can stop worrying about the infrastructure and platform capabilities instead focus on building great apps. The session will focus on different services that are part of Azure app services and also discuss about features specific to these services.

What is Azure Data Lake? 
Azure Data Lake (ADL) includes ADL store - a petabyte-scale repository, ADL analytics - a first of its kind Job-as-a-Service model and HDInsight - leading Hadoop distribution on cloud. The ADL tools for Visual studio provide a rich development platform, making Big Data easier and faster. The webinar will cover key features of ADL components and include demos of development toolkits.

What is OLTP?
In SQL Server database, OLTP is known as Online Transactional Processing where Transactions are for write operations and the OLTP model is optimised for this. Online customers do interact with business application to fulfil their needs such as online shopping carts e.g. Amazon. 

What is OLAP?
In SQL Server database, OLAP stands for Online Analytical Processing, Analysis being the keyword meaning lots of reads. Business users/ data analytics are the users for this type of the data to make the right decision for the business growth.

Why Index sizes are consolidated and separated?
Whenever we create a clustered index on a table then clustered index consist a data rows in a leaf node that’s why clustered index’s size is consolidated with table size.
But whenever we create any nonclustered index on a table then nonclustered index contains a row locator at leaf node that’s why index structure is totally separated from table data structure.

No comments:

Post a Comment

Popular Posts