Question 1
Which data format represents data as a series of ones and zeros?
- Selected: binaryThis answer is correct.
- decimal
- octal
- hex
Correct! SQL Server encodes the data into a binary format, in which data is represented as a series of zeros and ones.
1/1
Question 2
Which of the following is a way of organizing data, with defined rules for storing, manipulating, and retrieving data?
- modeling format
- physical architecture
- virtual instance
- Selected: logical structureThis answer is correct.
Correct! A logical structure is a way of organizing data, with defined rules for storing, manipulating, and retrieving the data; client applications interact with these logical objects within a database, rather than with the physical files.
1/1
Question 3
Which of the following is NOT a reason for a database administrator to understand the main file types used in a SQL Server system?
- physical resources
- backup and recovery operations
- Selected: transparency to the userThis answer is correct.
- security
Correct! Although the physical file structure is generally transparent to an end user, it is important for a database administrator to understand the main file types and their implementation for a number of reasons, including: physical resources, backup and recovery operations, and security.
1/1
Question 4
Which system database stores information related to jobs, schedules, and database backups?
- tempdb
- model
- Selected: msdbThis answer is correct.
- master
Correct! Msdb stores information related to jobs, schedules, and database backups.
1/1
Question 5
Which service enables a client to connect to the SQL Server instance over a network?
- loopback
- SQLCMD
- Selected: listenerThis answer is correct.
- shared memory
Correct! A listener is a service that enables a client to connect to the SQL Server instance over a network.
1/1
Question 6
Which of the following is used by SQLCMD to test network connections used to remotely connect to a SQL Server instance?
- named pipes
- TDS packets
- SSRP
- Selected: loopback addressThis answer is correct.
Correct! You will then test these network connections from the SQLCMD prompt, which enables you to connect to the database and execute SQL commands and scripts using a loopback address. A loopback address is an IP address that sends outbound packets of data directly back to the host computer to simulate a physical network.
1/1
Question 7
Which system database stores information on the structure of other databases and their components?
- model
- msdb
- Selected: masterThis answer is correct.
- tempdb
Correct! Master stores information on the structure of other databases and their components, and also maintains configuration settings, including security.
1/1
Question 8
Which of the following is a file extension used in the physical structure of a SQL database?
- Selected: .ldfThis answer is correct.
- .txt
- .mdb
- .dbf
Correct! Each database that is mounted on a SQL Server instance has two main physical file types: Data Files (.mdf) and Log Files (.ldf).
1/1
Question 9
What should you do to prevent blockage of the port used to communicate with a SQL Server instance?
- disable the firewall on the client
- disable the firewall on the server
- Selected: configure a fixed portThis answer is correct.
- use named pipes
Correct! It is recommended that you configure a fixed port for each SQL Server instance and open the relevant port on the firewall to allow network traffic to reach the server.
1/1
Question 10
Select the network protocol below that utilizes local procedure calls to pass instructions to the SQL Server.
- TCP/IP
- named pipes
- Selected: shared memoryThis answer is correct.
- IPX/SPX
Correct! Shared memory is a local procedure call, and it requires the client application to be running on the same host as the SQL Server instance.