Term
| What service is the primary database Service? |
|
Definition
|
|
Term
| What service provides connection details? |
|
Definition
|
|
Term
| What service Provides Message Queuing for asynchronous data transfer? |
|
Definition
|
|
Term
| what service is for extracting and transforming data? |
|
Definition
|
|
Term
| What service is for OLAP and datamining? |
|
Definition
| SQL Server Analysis Service |
|
|
Term
| what service is for scheduling and alerting? |
|
Definition
|
|
Term
| A recommended disk configuration for SQL is ________ |
|
Definition
| disk striping with parity |
|
|
Term
| You need to set up permissions to allow a new administrator to work with a SQL Server DB. Which tool would you use? |
|
Definition
| SQL Server Configuration Manager |
|
|
Term
| True or False, log files should be stored in filegroups along with DB data? |
|
Definition
|
|
Term
| The secondary database are stored in a file with an extension of _____ |
|
Definition
|
|
Term
| Transaction throughput is limited by the speed that the data can be written into the _____ |
|
Definition
|
|
Term
| You have written a new SQL command to create a new db structure and filegroups. You specified two filegroups, FG_A and FG_B. No data has been loaded in the DB, but you only want system objects in FG_A. What should you do? |
|
Definition
| FG_A is currently marked as the default group, you should change the default group to FG_B when done setting up. |
|
|
Term
| You are configuring a database that is used by a county tax agent to enter payments made by citizens at the county tax office. You want to minimize the amount of data that may be lost if the server experiences a hardware failure. Which recovery model should you select? |
|
Definition
|
|
Term
| If you define a column with the UNIQUE constant, you must also make this column the primary key? |
|
Definition
|
|
Term
| You are administering a db that is used during the day by company employees. At night a set of batch jobs are run to process data which comes in from branch offices. It is becoming difficult to finish the entire batch processing before employees arrive at 8am. What actions should you take? |
|
Definition
| Change the recovery model to bulk-logged after the employees are off-line, then change it back to full when batch jobs are done. |
|
|
Term
| You are administering a database that is used periodically throughout the day, but not heavily. Users complain that when they try to use the DB there is a lengthy delay for the first transaction. It has plenty of memory. What option should you configure to address this problem? |
|
Definition
|
|
Term
| The manager reports that employees cannot make any updates to data but can still read it. What database option change caused the problem? |
|
Definition
| The Database is set to READ_ONLY mode |
|
|
Term
| If you run DBCC CHECKDB and an index has an integrity error, what should you do to correct this? |
|
Definition
| Just drop and recreate the index |
|
|
Term
| what kind of index is created by using the WHERE clause on the CREATE INDEX statement |
|
Definition
|
|
Term
| What type of index does the leaf level consist of data pages? |
|
Definition
|
|
Term
| What type of index does the leaf level consist of pointers to data pages? |
|
Definition
|
|
Term
| what type of index is created on a column that has a data type of geometry or geography? |
|
Definition
|
|
Term
| what type of index can there only be one of per table? |
|
Definition
|
|
Term
| When designing a large company db that will store data on all aspects of the company, allowing each department's applications to see and use only the tables and views that are related to that department. Which of the following approaches will require the least effort and will accomplish this goal? |
|
Definition
| Create a schema for each department, and add the tables and views required by the department to it. |
|
|
Term
| T or F, Each SQL Server instance contains its own set of databases, security credentials and configuration settings? |
|
Definition
|
|
Term
| You have created two schemas, names schema1 and schema2. You decide to move the Products table from schema 1 to schema 2. Which happens? |
|
Definition
| All permissions on the Products table will be dropped, but the owner remains |
|
|
Term
| You are configuring a Database Mail feature of the Accounting DB to alert all DBAs when performance falls below certain thresholds. You want only the DBAs and the database itself to send mail messages through DB Mail, what should you do? |
|
Definition
| Create a private profile and assign permissions for the DBAs accounts to this profile |
|
|
Term
| You have a db named Personnel that contains an unindexed table named Category, it never changes. You want to create an index of this table so that the physical order of the rows in the table will be the same as the logical order of the index. What SQL Command should you use? |
|
Definition
CREATE UNIQUE CLUSTERED INDEX idx_Cat
ON Category (Cat_ID)
WITH FILLFACTOR = 100 |
|
|
Term
| ___ defines the character set supported for this DB. |
|
Definition
|
|
Term
| ___ defines the character set supported for this DB. |
|
Definition
|
|
