$1.$ How many $.$ndf files can be created within a single database? $\_\_\_\_\_$

$2.$ What is the maximum size of a single $.$mdf or $.$ndf file in TB$?\_\_\_\_\_$

$3.$ How many instances of SQL Enterprise Edition can you install on a single Windows Server? $\_\_\_\_$

$4.$ TCP port $\_\_\_\_\_\_$ is used by SQL sessions, and TCP port $\_\_\_\_\_\_$ is used by Database Mirroring Endpoints by default.

$5.$ Adding hardware to an existing SQL server is called scaling $\_\_\_\_\_,$ whereas adding additional SQL servers is called scaling $\_\_\_\_\_\_.$

$6.$ Which database option is used to control the amount of information that is send to the transaction log$?\_\_\_\_\_\_\_\_\_\_\_\_\_$

$7.$ Which database option is used to cache transaction results in RAM for faster speed? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$8.$ Which two database options are used to ensure that statistics are automatically obtained for your database? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$9.$ What two recovery models are supported by Database Log Shipping? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$10.$ What recovery model is supported by Database Mirroring? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$11.$ During the configuration of Database Log Shipping, a backup of the database on the Primary server is restored to the Secondary server. What restore option must you select if you wish to query the copy of the database on the Secondary server? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$12.$ During the configuration of Database Mirroring, you must restore a backup of the database you wish to mirror on the second server. What restore option must you select? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$13.$ To tune a SQL Server, you can create a performance trace using the $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ utility, then analyze that performance trace using the $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ utility.

$14.$ What three areas are regularly monitored by the Performance Data Warehouse? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$15.$ Which DBCC command can be used to repair a database called $$Lala$$: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$16.$ The SQL Server $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ is used to perform data mining, whereas the SQL Server $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$ is used to generate Web$-$visible reports.

$17.$ Which option to the bcp$.$exe command can be used to specify a comma $(,)$ delimeter within a text file that contains lines to be bulk imported? $\_\_\_\_\_\_$

$18.$ What type of publication would you create to send a read$-$only copy of an entire table to another SQL server every $3$ hours? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$19.$ What are the two agents called that provide the functionality for transactional replication? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$20.$ When troubleshooting transactional replication using the Replication Monitor, what should you do to test whether a firewall is blocking the replication between snapshots? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$21.$ Which counter in the Performance Monitor console can be used to monitor SQL RAM usage? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$22.$ What must you type in the server$/$host dialog box within SSMS to connect to a remote server called SQL$5201$ using a dedicated administrator connection? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$23.$ You wish to create a series of maintenance plans to automate the maintenance of your SQL server. What tasks should you schedule daily at minimum? List $4(2$ marks$)$: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$24.$ You wish to create a series of maintenance plans to automate the maintenance of your SQL server. What tasks should you schedule weekly at minimum? List $3(2$ marks$)$: $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$25.$ What type of user account should you run the SQL Server Agent as if you wish it to perform actions on other computers within the domain? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$26.$ What is the primary purpose of schemas? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$27.$ What SQL feature can you create and enable to check all of your databases for a particular setting $($e$.$g$.$ Recovery Model not equal to Simple$)$ every day? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$

$28.$ After configuring an email account using Database Mail, what must you configure in order to send email to jason.eckert@trios.com? $\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_$