Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . How many . ndf files can be created within a single database? _ _ _ _ _ 2 . What is the maximum
How many ndf files can be created within a single database?
What is the maximum size of a single mdf or ndf file in TB
How many instances of SQL Enterprise Edition can you install on a single Windows Server?
TCP port is used by SQL sessions, and TCP port is used by Database Mirroring Endpoints by default.
Adding hardware to an existing SQL server is called scaling whereas adding additional SQL servers is called scaling
Which database option is used to control the amount of information that is send to the transaction log
Which database option is used to cache transaction results in RAM for faster speed?
Which two database options are used to ensure that statistics are automatically obtained for your database?
What two recovery models are supported by Database Log Shipping?
What recovery model is supported by Database Mirroring?
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?
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?
To tune a SQL Server, you can create a performance trace using the utility, then analyze that performance trace using the utility.
What three areas are regularly monitored by the Performance Data Warehouse?
Which DBCC command can be used to repair a database called Lala:
The SQL Server is used to perform data mining, whereas the SQL Server is used to generate Webvisible reports.
Which option to the bcpexe command can be used to specify a comma delimeter within a text file that contains lines to be bulk imported?
What type of publication would you create to send a readonly copy of an entire table to another SQL server every hours?
What are the two agents called that provide the functionality for transactional replication?
When troubleshooting transactional replication using the Replication Monitor, what should you do to test whether a firewall is blocking the replication between snapshots?
Which counter in the Performance Monitor console can be used to monitor SQL RAM usage?
What must you type in the serverhost dialog box within SSMS to connect to a remote server called SQL using a dedicated administrator connection?
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 marks:
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 marks:
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?
What is the primary purpose of schemas?
What SQL feature can you create and enable to check all of your databases for a particular setting eg Recovery Model not equal to Simple every day?
After configuring an email account using Database Mail, what must you configure in order to send email to jason.eckert@trios.com?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started