Foundation SQL Server Terms New
Version Exam And Answers 100%
correct
Database Management System (DBMS) - Answer - ✔✔A database management
system (DBMS) is system software for creating and managing databases. The DBMS
provides users and programmers with a systematic way to create, retrieve, update and
manage data.
Database Server - Answer - ✔✔A database server is a computer program that provides
database services to other computer programs or computers, as defined by the client-
server model. The term may also refer to a computer dedicated to running such a
program.
Microsoft SQL Server - Answer - ✔✔Microsoft SQL Server is a relational database
management system developed by Microsoft. As a database server, it is a software
product with the primary function of storing and retrieving data as requested by other
software applications—which may run either on the same computer or on another
computer across a network (including the Internet).
T-SQL - Answer - ✔✔T-SQL (Transact-SQL) is the secondary means of programming
and managing SQL Server. It exposes keywords for the operations that can be
performed on SQL Server, including creating and altering database schemas, entering
and editing data in the database as well as monitoring and managing the server itself.
Client applications that consume data or manage the server will leverage SQL Server
functionality by sending T-SQL queries and statements which are then processed by the
server and results (or errors) returned to the client application.
SQL Server Integration Services (SSIS) - Answer - ✔✔SQL Server Integration Services
(SSIS) provides ETL capabilities for SQL Server for data import, data integration and
data warehousing needs. Integration Services includes GUI tools to build workflows
such as extracting data from various sources, querying data, transforming data—
including aggregation, de-duplication, de-/normalization and merging of data—and then
exporting the transformed data into destination databases or files
SQL Server Analysis Services (SSAS) - Answer - ✔✔SQL Server Analysis Services
adds OLAP and data mining capabilities for SQL Server databases. The OLAP engine
supports MOLAP, ROLAP and HOLAP storage modes for data. Analysis Services
supports the XML for Analysis standard as the underlying communication protocol. The
cube data can be accessed using MDX and LINQ
Version Exam And Answers 100%
correct
Database Management System (DBMS) - Answer - ✔✔A database management
system (DBMS) is system software for creating and managing databases. The DBMS
provides users and programmers with a systematic way to create, retrieve, update and
manage data.
Database Server - Answer - ✔✔A database server is a computer program that provides
database services to other computer programs or computers, as defined by the client-
server model. The term may also refer to a computer dedicated to running such a
program.
Microsoft SQL Server - Answer - ✔✔Microsoft SQL Server is a relational database
management system developed by Microsoft. As a database server, it is a software
product with the primary function of storing and retrieving data as requested by other
software applications—which may run either on the same computer or on another
computer across a network (including the Internet).
T-SQL - Answer - ✔✔T-SQL (Transact-SQL) is the secondary means of programming
and managing SQL Server. It exposes keywords for the operations that can be
performed on SQL Server, including creating and altering database schemas, entering
and editing data in the database as well as monitoring and managing the server itself.
Client applications that consume data or manage the server will leverage SQL Server
functionality by sending T-SQL queries and statements which are then processed by the
server and results (or errors) returned to the client application.
SQL Server Integration Services (SSIS) - Answer - ✔✔SQL Server Integration Services
(SSIS) provides ETL capabilities for SQL Server for data import, data integration and
data warehousing needs. Integration Services includes GUI tools to build workflows
such as extracting data from various sources, querying data, transforming data—
including aggregation, de-duplication, de-/normalization and merging of data—and then
exporting the transformed data into destination databases or files
SQL Server Analysis Services (SSAS) - Answer - ✔✔SQL Server Analysis Services
adds OLAP and data mining capabilities for SQL Server databases. The OLAP engine
supports MOLAP, ROLAP and HOLAP storage modes for data. Analysis Services
supports the XML for Analysis standard as the underlying communication protocol. The
cube data can be accessed using MDX and LINQ
