What other steps are required?
You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2008 instance. You have received instructions from your boss, Miss Tess King, to comply
with a new set of users that will be hired by TestKing. The first user is KeithClark. Later a
new group of users named Hirelings will be added as well. They should all be able to:
view the definitions from all user-defined tables
read data from all user-defined tables
read data from all user-defined views
read data from all user-defined functions
You need to complete this task with the least amount of SQL administrative statements. You start by created the user KeithClark.
What other steps are required? Select all that apply.
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
Domain.com contains two SQL Server 2008 servers named CERTKILLER-DB1 and CERTKILLER-DB2.
CERTKILLER-DB1 does the transaction log backups and CERTKILLER-DB2 is to reset by using the SQL Server Surface Area Configuration.
However one morning you notice that the CERTKILLER-DB2 did not run the maintenance tasks automatically.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. Domain.com contains a SQL Server 2008 sample named CKSam that contains a
database named CK_DB. Furthermore, CK_DB does have a ProductItems table. A Replication
topology is needed to copy the ProductItems table to the SQL Server samples included in
computers. The only time the ProductItems will be refreshed, is when the computers do not link to
the Domain.com network. Furthermore, the Products table is from between reconnections
frequently. You need to run the Replication topology alongside the Subscription type with the
minimum amount of bandwidth usage.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1. The CK_DB1 database uses SQL
Server log shipping; however, log shipping will occur within the hour. You have received
instructions to make a full backup however; you need to cut the net bandwidth utilization when
maintenance takes place at night.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 sample named CKSmp1. Furthermore, CKSmp1 contains a database named CK_DB. The
CK_DB uses the bulk-logging recovery mode. You then use the WAN to log ship CK_DB.
Furthermore, CK_DB’s indexes are reproduces by a scheduled work. You then make certain that
the log shipping adds the number to the job. You need to minimize the size of the log backups
used by log shipping.
What should you do?
which result in that the database does not failover to the other partner. What should you have done?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains three databases named CK_DB1, CK_DB2 and CK_DB3. Each of
these databases runs on different servers.
CK_DB1 and CK_DB2 have an important database that is mirrored. CK_DB3 is a helper and
CK_DB1 is considered the principle database. You then implement a patch that requires CK_DB1
and CK_DB2 to be rebooted. However since the patching was done as quickly as possible the
database that was online at the time could not use the patch. This database cannot use the patch
present which result in that the database does not failover to the other partner.
What should you have done?
which searches use the most resources. What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2005 instance. The database enables the Domain.com users to operate both ad hoc and
predefined searches. There is however a suspicion that some searches will cost too much of the
available resources and you need to make sure which searches use the most resources.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1. Domain.com also contains an
application that makes use of the SELECT command that triggers the population of multiple
tables. This application also makes use of CK_DB1. One morning you have received several
complaints from the users that the application is performing very sluggish. You now need to
control the status of the sample without affecting the application performance.
What should you do?
What should you do?
You work as a database administrator at Domain.com. One morning you have received
numerous complaints from the users at Domain.com that the SQL Server 2008 application is
running very sluggish. You need to check the disk, CPU, and memory utilization; information and
still consider the network.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains databases that host two applications for acquiring and selling.
You were busy with the setting of the Resource Governor with the purpose of cutting the maximum
CPU search time permitted through the applications. However, after the setting, you notice that
some of the reports of the acquiring application does not execute successfully. You need to
ensure that you alter the Resource Governor settings to permit more CPU time.
What should you do?