Question 1

Linked servers can be created, modified, or dropped by using a SQL query.

Accepted Answer

Linked servers can be managed by using SQL queries, such as creating, modifying, and dropping them.

Question 2

Which system database stores information related to jobs, schedules, and database backups?&#10;A)tempdb&#10;B)msdb&#10;C)model&#10;D)master

Accepted Answer

The msdb database stores information related to jobs, schedules, and database backups.

Question 3

Which of the following is a file extension used in the physical structure of a SQL database?&#10;A).ldf&#10;B).mdb&#10;C).txt&#10;D).dbf

Accepted Answer

".ldf" is a file extension used in the physical structure of a SQL database. It is the transaction log file that records all transactions and modifications made to the database.

Question 4

Which of the following enable frequently perform tasks to be stored as objects in the database?&#10;A)procedures&#10;B)views&#10;C)indexes&#10;D)constraints

Accepted Answer

Procedures are used to frequently perform tasks and can be stored as objects in the database. Views are used for data retrieval and do not store procedures. Indexes are used to improve query performance by creating pointers to data in the table, but do not store procedures. Constraints are used to enforce rules on data and do not store procedures.

Question 5

Which data format represents data as a series of ones and zeros?&#10;A)binary&#10;B)octal&#10;C)decimal&#10;D)hex

Accepted Answer

Binary is a data format that represents data using only two digits: 0 and 1, which correspond to off and on states of a signal. It is widely used in digital electronics and computing, as it allows for efficient storage, transmission, and processing of data. The other options, octal, decimal, and hex, are also data formats, but they use different bases and symbols to represent data. Octal uses a base of 8 and symbols 0-7, decimal uses a base of 10 and symbols 0-9, and hex uses a base of 16 and symbols 0-9 and A-F.

Question 6

Which service enables a client to connect to the SQL Server instance over a network?&#10;A)loopback&#10;B)listener&#10;C)SQLCMD&#10;D)shared memory

Accepted Answer

A listener is responsible for enabling clients to connect to a SQL Server instance over a network, by listening for incoming connection requests and routing them to the appropriate SQL Server instance. The other options are not relevant in this case: The loopback address (A) refers to the IP address 127.0.0.1, which is used to refer to the local computer itself; shared memory (D) is a type of inter-process communication mechanism that enables different processes to share memory segments directly, which is not used for network communication; SQLCMD (C) is a command-line utility for running SQL statements, but does not have a direct role in enabling network connectivity.

Question 7

Which of the following is a way of organizing data, with defined rules for storing, manipulating, and retrieving data?&#10;A)modeling format&#10;B)virtual instance&#10;C)physical architecture&#10;D)logical structure

Accepted Answer

The description provided fits the definition of a logical structure, which is a way of organizing data with defined rules for storing, manipulating, and retrieving data. Modeling format refers to the process of creating a representation of a system, virtual instance refers to a copy of an operating system or application running on a virtual machine, and physical architecture refers to the layout and design of hardware components in a computer system.

Question 8

The primary purpose of a database is to organize and store data in a secure manner.

Accepted Answer

The primary purpose of a database is indeed to organize and store data in a secure and efficient manner. A database is designed to hold large amounts of information that is easily accessible, searchable, and retrievable. It is also intended to ensure data integrity, confidentiality, and availability through the use of security measures such as user authentication, permission management, and backup and recovery mechanisms.

Question 9

Which of the following is a basic building block of a database that is used to improve the speed and efficiency of data access?&#10;A)table&#10;B)index&#10;C)constraint&#10;D)time stamp

Accepted Answer

An index is a basic building block of a database that is used to improve the speed and efficiency of data access. It works like an index in a book, organizing data based on specific fields. This allows for faster searching and sorting of data. Tables represent the actual data, constraints enforce rules on the data, and timestamps track when data was last updated but do not directly improve data access speed.

Question 10

What can be used to satisfy compliance aspects of business requirements by creating time stamps and audits?&#10;A)logical instance&#10;B)index&#10;C)constraint&#10;D)trigger

Accepted Answer

Triggers can be used to create time stamps and audits. They are often used to enforce business rules and ensure compliance with regulations by automatically recording changes to the database and creating a record of when and by whom the change was made. Logical instances, indexes, and constraints do not directly address the need for time stamps and audits.

Question 11

The master system database stores a database template that is used as a blueprint when creating a new user database.

Accepted Answer

The answer of The master system database stores a database...

Question 12

Which of the following is commonly referred to as a record?&#10;A)constraint&#10;B)column&#10;C)row&#10;D)attribute

Accepted Answer

The answer of Which of the following is commonly referred...

Question 13

What are int, date, and bit examples of in a SQL database?&#10;A)data type&#10;B)condition&#10;C)column name&#10;D)record

Accepted Answer

The answer of What are int, date, and bit examples...

Question 14

A linked server uses shared software components from the dynamic-link library on the server.

Accepted Answer

The answer of A linked server uses shared software components...

Question 15

Which of the following is NOT a reason for a database administrator to understand the main file types used in a SQL Server system?&#10;A)physical resources&#10;B)transparency to the user&#10;C)backup and recovery operations&#10;D)security

Accepted Answer

The answer of Which of the following is NOT a...

Question 16

Which tool allows you to create SQL queries to be executed against a database?&#10;A)Object Explorer&#10;B)Query Editor&#10;C)Analysis Services&#10;D)View Compiler

Accepted Answer

The answer of Which tool allows you to create SQL...

Question 17

Which of the following may require the database engine to perform a full scan on every record of the database?&#10;A)invalid constraints&#10;B)too many triggers&#10;C)no index is defined&#10;D)no secondary key

Accepted Answer

The answer of Which of the following may require the...

Question 18

Which system database stores information on the structure of other databases and their components?&#10;A)model&#10;B)master&#10;C)msdb&#10;D)tempdb

Accepted Answer

The answer of Which system database stores information on the...

Question 19

Which of the following is NOT a system database on a SQL Server system?&#10;A)model&#10;B)master&#10;C)directory&#10;D)resource

Accepted Answer

The answer of Which of the following is NOT a...

Question 20

Client applications can only connect to the SQL Server instance on the local computer.

Accepted Answer

The answer of Client applications can only connect to the...

Question 21

Describe the physical structure of a database.

Accepted Answer

The answer of Describe the physical structure of a database....

Question 22

What happens if there is no index defined for a query? What is its impact?

Accepted Answer

The answer of What happens if there is no index...

Question 23

When defining a ____________ server, it is possible to override the integrated authentication with a stored username and password.

Accepted Answer

The answer of When defining a ____________ server, it is...

Question 24

List and describe three of the five system databases found in an SQL Server 2012 system.

Accepted Answer

The answer of List and describe three of the five...

Question 25

What is a data type and how are they used in tables?

Accepted Answer

The answer of What is a data type and how...

Question 26

A ______________ is a physical unit of storage into which data files are subdivided.

Accepted Answer

The answer of A ______________ is a physical unit of...

Question 27

What are the roles of listeners and loopback addresses in SQL Server remote connections?

Accepted Answer

The answer of What are the roles of listeners and...

Question 28

What is the primary purpose of a database?

Accepted Answer

The answer of What is the primary purpose of a...

Question 29

Which of the following is used by SQLCMD to test network connections used to remotely connect to a SQL server instance?&#10;A)named pipes&#10;B)SSRP&#10;C)TDS packets&#10;D)loopback address

Accepted Answer

The answer of Which of the following is used by...

Question 30

LastName and FirstName are examples of ____________ in a database table.

Accepted Answer

The answer of LastName and FirstName are examples of ____________...

Question 31

Which of the following is NOT a network protocol supported by SQL Server 2012?&#10;A)shared memory&#10;B)named pipes&#10;C)NWLink&#10;D)TCP/IP

Accepted Answer

The answer of Which of the following is NOT a...

Question 32

What are the two basic building blocks of a database? Describe them.

Accepted Answer

The answer of What are the two basic building blocks...

Question 33

What is used to configure a connection to an external data source from within SQL Server?&#10;A)linked server object&#10;B)TDS packets&#10;C)listener&#10;D)named pipe

Accepted Answer

The answer of What is used to configure a connection...

Question 34

Which of the following is a data provider that enables a connection to be established to almost any database or file irrespective of the operating system?&#10;A)DLL&#10;B)ODBC&#10;C)Oracle&#10;D)Jet

Accepted Answer

The answer of Which of the following is a data...

Question 35

Describe the logical organization of a database.

Accepted Answer

The answer of Describe the logical organization of a database....

Question 36

Describe how TCP/IP is used in SQL Server 2012 remote connectivity.

Accepted Answer

The answer of Describe how TCP/IP is used in SQL...

Question 37

The ______________ system database stores the system objects in a read-only database.

Accepted Answer

The answer of The ______________ system database stores the system...

Question 38

What should you do to prevent blockage of the port used to communicate with a SQL Server instance?&#10;A)disable the firewall on the client&#10;B)configure a fixed port&#10;C)disable the firewall on the server&#10;D)use named pipes

Accepted Answer

The answer of What should you do to prevent blockage...

Question 39

In a _________________ database, tables are designed to model real-world objects and the relationships that exist between them.

Accepted Answer

The answer of In a _________________ database, tables are designed...

Question 40

Describe some of the components found in SQL Server Management Studio.

Accepted Answer

The answer of Describe some of the components found in...

Question 41

Match between columns&#10;                        Premises: provides a tree view of the different database schema objects organized as a series of folders&#10;provides a tree view of the different database schema objects organized as a series of folders&#10;provides a tree view of the different database schema objects organized as a series of folders&#10;provides a tree view of the different database schema objects organized as a series of folders&#10;provides a tree view of the different database schema objects organized as a series of folders&#10;provides a tree view of the different database schema objects organized as a series of folders&#10;provides a tree view of the different database schema objects organized as a series of folders&#10;provides a tree view of the different database schema objects organized as a series of folders&#10;provides a tree view of the different database schema objects organized as a series of folders&#10;provides a tree view of the different database schema objects organized as a series of folders&#10;a physical storage unit that is a collection of eight pages&#10;a physical storage unit that is a collection of eight pages&#10;a physical storage unit that is a collection of eight pages&#10;a physical storage unit that is a collection of eight pages&#10;a physical storage unit that is a collection of eight pages&#10;a physical storage unit that is a collection of eight pages&#10;a physical storage unit that is a collection of eight pages&#10;a physical storage unit that is a collection of eight pages&#10;a physical storage unit that is a collection of eight pages&#10;a physical storage unit that is a collection of eight pages&#10;organized as a two-dimensional structure consisting of rows and columns&#10;organized as a two-dimensional structure consisting of rows and columns&#10;organized as a two-dimensional structure consisting of rows and columns&#10;organized as a two-dimensional structure consisting of rows and columns&#10;organized as a two-dimensional structure consisting of rows and columns&#10;organized as a two-dimensional structure consisting of rows and columns&#10;organized as a two-dimensional structure consisting of rows and columns&#10;organized as a two-dimensional structure consisting of rows and columns&#10;organized as a two-dimensional structure consisting of rows and columns&#10;organized as a two-dimensional structure consisting of rows and columns&#10;constructed based on a unique key, and it contains pointers to the underlying rows within the table&#10;constructed based on a unique key, and it contains pointers to the underlying rows within the table&#10;constructed based on a unique key, and it contains pointers to the underlying rows within the table&#10;constructed based on a unique key, and it contains pointers to the underlying rows within the table&#10;constructed based on a unique key, and it contains pointers to the underlying rows within the table&#10;constructed based on a unique key, and it contains pointers to the underlying rows within the table&#10;constructed based on a unique key, and it contains pointers to the underlying rows within the table&#10;constructed based on a unique key, and it contains pointers to the underlying rows within the table&#10;constructed based on a unique key, and it contains pointers to the underlying rows within the table&#10;constructed based on a unique key, and it contains pointers to the underlying rows within the table&#10;a log of events on the database management system&#10;a log of events on the database management system&#10;a log of events on the database management system&#10;a log of events on the database management system&#10;a log of events on the database management system&#10;a log of events on the database management system&#10;a log of events on the database management system&#10;a log of events on the database management system&#10;a log of events on the database management system&#10;a log of events on the database management system&#10;the column or combination of columns that uniquely identify each record within a table&#10;the column or combination of columns that uniquely identify each record within a table&#10;the column or combination of columns that uniquely identify each record within a table&#10;the column or combination of columns that uniquely identify each record within a table&#10;the column or combination of columns that uniquely identify each record within a table&#10;the column or combination of columns that uniquely identify each record within a table&#10;the column or combination of columns that uniquely identify each record within a table&#10;the column or combination of columns that uniquely identify each record within a table&#10;the column or combination of columns that uniquely identify each record within a table&#10;the column or combination of columns that uniquely identify each record within a table&#10;a condition that imposes a limitation on a value or action&#10;a condition that imposes a limitation on a value or action&#10;a condition that imposes a limitation on a value or action&#10;a condition that imposes a limitation on a value or action&#10;a condition that imposes a limitation on a value or action&#10;a condition that imposes a limitation on a value or action&#10;a condition that imposes a limitation on a value or action&#10;a condition that imposes a limitation on a value or action&#10;a condition that imposes a limitation on a value or action&#10;a condition that imposes a limitation on a value or action&#10;provides the capability to execute queries against a remote data source for running distributed queries.&#10;provides the capability to execute queries against a remote data source for running distributed queries.&#10;provides the capability to execute queries against a remote data source for running distributed queries.&#10;provides the capability to execute queries against a remote data source for running distributed queries.&#10;provides the capability to execute queries against a remote data source for running distributed queries.&#10;provides the capability to execute queries against a remote data source for running distributed queries.&#10;provides the capability to execute queries against a remote data source for running distributed queries.&#10;provides the capability to execute queries against a remote data source for running distributed queries.&#10;provides the capability to execute queries against a remote data source for running distributed queries.&#10;provides the capability to execute queries against a remote data source for running distributed queries.&#10;an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts&#10;an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts&#10;an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts&#10;an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts&#10;an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts&#10;an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts&#10;an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts&#10;an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts&#10;an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts&#10;an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts&#10;a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data&#10;a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data&#10;a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data&#10;a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data&#10;a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data&#10;a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data&#10;a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data&#10;a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data&#10;a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data&#10;a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data

Accepted Answer

The Answer of linked server and primary key and named is...

Deck 3: Architecture and Configuration