feedburner
Enter your email address:

Delivered by FeedBurner

feedburner count
Custom Search

Part - 15 MCSE Interview

QUESTION 121
You work as the database administrator at Certkiller .com. The Certkiller .com
network consists of a single Active Directory domain named Certkiller .com. All
servers on the Certkiller .com network run Windows 2000 Server and all client
computers run Windows 2000 Professional. The Certkiller .com network contains a
SQL Server 2000 database server named Certkiller -DB01.
There are currently five databases that reside on the same instance of SQL Server
2000 in the Certkiller .com domain. You need to reduce administrative overhead and
thus want to appoint five of your assistants to fully manage the databases. Each of
these assistants will then be responsible for a single database. All these assistants
enjoy membership of a group names AdminAssist.
You now need to enable each of these assistants to manage their respective
databases.
What should you do?

A. You should carry out the following script for each database:
sp_grantlogin ' Certkiller \AdminAssist'
USE db_name
EXEC sp_grantdbaccess ' Certkiller \AdminAssist', AdminAssist
EXEC sp_addrolemember db_owner, AdminAssist
B. You should carry out the following script for each database:
sp_grantlogin ' Certkiller \AdminAssist'
USE db_name
EXEC sp_grantdbaccess ' Certkiller \AdminAssist', AdminAssist
EXEC sp_addsrvrolemember serveradmin, AdminAssist
C. You should carry our the following script with the appropriate user name and database name for each assistant:
sp_grantlogin ' Certkiller \user_name'
USE db_name
EXEC sp_grantdbaccess ' Certkiller \user_name', user_name
EXEC sp_addrolemember db_accessadmin, user_name
D. You should carry out the following script with the appropriate user name and database
name for each assistant:
sp_grantlogin ' Certkiller \user_name'
USE db_name
EXEC sp_grantdbaccess ' Certkiller \user_name', user_name
EXEC sp_addrolemember db_owner, user_name

Answer: D

Explanation: Each Windows domain user account of the five assistants must be granted
login in SQL Server. The user name must be preceded be the domain name and the
backslash. Once the login is granted, you should then switch to the context of the target database. Then you should create a user account in the database and map it to the appropriate login.

This can be done by using the sp_grantdbaccess stored procedure. Finally you should add the database user account to the db_owner fixed database role to allow these individual assistants to fully manage their assigned databases.

Incorrect answers:

A: If you granted database access to AdminAssist group and specified this group as the owner of each database, then each assistant will end up receiving administrative
privileges in all five databases.
B: If you added the AdminAssist group to the serveradmin fixed server role, then the
members of this group will end up being able to make changes that will affect the entire server and not just the database that they are supposed to manage.
C: If you added each assistant to the db_accessadmin fixed database role, then those
assistants would be able to add or remove database user accounts. Membership in this
database role would thus not be sufficient to fully manage their assigned databases
respectively.


QUESTION 122
You work as the database administrator at Certkiller .com. All servers on the
Certkiller .com network run Windows Server 2000 and all database servers run SQL
Server 2000. The Certkiller .com network contains a database server named
Certkiller -DB01.
You need to create an audit plan for Certkiller -DB01. The audit plan must
include the number of times a stored procedure executes. You want to gather the
data over a set period of time so you can estimate how often the stored procedure is
used in a typical load scenario. You want to obtain this information using the least
amount of administrative effort.
What should you do?

A. Modify the stored procedure to include the SET NOCOUNT ON statement.
B. Modify the stored procedure to send a message to the Application log.
C. Use the SQL Server Profiler to create a trace file.
D. Use System Monitor to monitor the execution of the stored procedure and save the
results to a file.

Answer: C

Explanation: You can use SQL Server Profiler to create a trace that includes
information that can be used to determine how many times the stored procedure has
been executed.

Incorrect Answers:

A: Altering the stored procedure to include the SET NOCOUNT ON statement will
reduce network traffic as clients do not receive messages indicating the number of rows affected by the stored procedure. However, it will not indicate how many times the stored procedure executed.
B: You can alter the stored procedure to send a message to the Application log every time it executes but you would need to check the Application log to determine how many times the stored procedure executed. This would require more administrative effort than using the SQL Server Profiler.
D: The System Monitor is used to monitor system resources. It is not used to monitor
stored procedures.


QUESTION 123
You work as the network database administrator at Certkiller .com. The
Certkiller .com network consists of a single Active Directory domain named
Certkiller .com. All servers on the Certkiller .com network run Windows Server 2000
and all client computers run Windows 2000 Professional.
The Certkiller .com network contains ten Microsoft SQL Server 2000 servers which
you administer. Certkiller .com management has recently decided to tighten network
security. A new Certkiller .com security policy requires that only network users with
security clearance can manage security principals and roles. You additionally need
to audit the users who are currently making such changes on the database servers
whilst your solution does not impact performance more than required.
What should you do?

A. Object access event auditing should be enabled in Audit Policy.
B. Auditing for account management events should be enabled in Audit Policy.
C. C2 audit mode for the SQL Server instance must be enabled.
D. A SQL Server Profiler trace should be created.

Answer: D

Explanation: In the scenario you should consider making use of the SQL Server
Profiler trace as the Security Audit Event Category includes the events necessary
for the information required. You can further more tune the trace template so that
only the events you require are logged to keep trace from impacting performance.

Incorrect Answers:

A, B: The Audit Policy should not be used in the scenario because the Windows policy
setting controls auditing for the management of Windows accounts not SQL Server
accounts.
C: The C2 auditing mode should not be used in the scenario because the mode logs more
than just the required information taking up more resources than required.


QUESTION 124
You work as the network database administrator at Certkiller .com. The
Certkiller .com network consists of a single Active Directory domain named
Certkiller .com. All servers on the Certkiller .com network run Windows 2000 Server
and all client computers run Windows XP Professional.
You have recently configured a job and scheduled it to run in the background on a
SQL Server 200 computer when the CPU usage falls below a specified level. During
the course of the business week you discover that the job you scheduled only runs on
weekends. You later decide to monitor SQL Server activity and discover that the
CPU usage frequently fall below the specified level during business hours. You are
required to configure the job to run anytime the CPU usage falls below the specified
level.
What should you do?

A. A second schedule should be added to the job and specify that the job execute at lunch time.
B. The computer should be upgraded to a dual-CPU system.
C. In the job's schedule you should specify that the job should execute on weekdays.
D. The amount of time that the CPU usage must remain below the specified level should be reduced before the job will execute.

Answer: D

Explanation: In the scenario you should remember that you are able to schedule
routine tasks by creating jobs and you are capable of scheduling the jobs to execute
at any time. By reducing the amount of time the CPU is to remain under the
specified level should ensure that the task executes.

Incorrect Answers:

A: This option should not be used in the scenario because the job will execute at lunch time whether the CPU usage is below the specified level or not.
B, C: In the scenario you should remember that a job schedule is based on the CPU idle time and cannot be based on any other criteria such as days and times.


QUESTION 125
You work as the network database administrator at Certkiller .com. The
Certkiller .com network consists of a single Active Directory domain named
Certkiller .com. All servers on the Certkiller .com network run Windows 2000 Server
and all client computers run Windows XP Professional.
Certkiller .com makes use of a SQL Server 2000 database to store the business
information. Certkiller .com requires that the database is available at all times
during business hours. You are responsible for performing database maintenance
only in a specific period of time at the end of each day with which to backup the
database.

During the course of the week you discovered that as a result of substantial changes
to the data that one of the database files has become too large. You also know that
the database file is not to densely populated with data. You are required to shrink
the database file whilst not disrupting user activity during the day. You are not able to perform these activities out side business hours.
What should you do?

A. Data from the database file should be removed and archived to a decision-support
system (DSS) database.
B. A job should be created that executes a DBCC SHRINKDATABASE statement and
schedule the job to run during off-peak hours.
C. The database file should be shrunk during the designated maintenance time.
D. The database should be shrunk during the day.

Answer: D

Explanation: In the scenario you should always remember that the truncation of a
shrink operation can not be performed when a backup is in progress. This will cause
the shrink operation to fail so running this task during the day achieves the scenario objective.

Incorrect Answers:

A: This option should not be considered in the scenario as it is stated that the database is not densely populated with data.
B: This option should not be used in the scenario because you are not required to shrink all the databases you are only required to shrink one database.
C: This option should not be considered in the scenario because it is stated that this task should not be performed out side business hours.


QUESTION 126
You work as the network database administrator at Certkiller .com. The
Certkiller .com network consists of a single Active Directory domain named
Certkiller .com. All servers on the Certkiller .com network run Windows 2000 Server
and all client computers run Windows XP Professional.
You are responsible for administering the SQL Server 2000 database of
Certkiller .com which is used to store business information. You are in the process of creating a job that will run automatically each time a SQL Server computer starts.
During the course of the day you turn off the SQL Server computer on Friday night
and turn it on Monday morning. You are required to select after which of the
following you should schedule the job to run.
What should you do?

A. You should schedule the job to run after the SQL Server Agent starts.
B. You should schedule the job to run at once.
C. You should schedule the job to run after the CPU becomes idle.
D. You should schedule the job to run every Monday at 8:00 A.M.
E. You should schedule the job to run after the SQL Server starts.

Answer: A

Explanation: In the scenario you should remember that jobs are primarily used to
automate certain tasks. Configuring the job to run after the SQL Server Agent
starts guarantees that any settings you configured will all successfully complete.

Incorrect Answers:

B: This option should not be used in the scenario because this would require the
administrator to specify a particular date and time or several respectively.
C: This option should not be used in the scenario as it is irrelevant to when the job you configures should start.
D: This option should not be used in the scenario as there is no guarantee that the
systems would be restarted the same times.
E: This solution is only partly correct because the SQL Server Agent service is also
required to ensure that all configured tasks will take place as scheduled.


QUESTION 127
You work as the database administrator at Certkiller .com. All servers on the
Certkiller .com network run Windows 2000 Server and all database servers run SQL
Server 2000. The Certkiller .com network contains a database server named
Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores
sales data for the company.
You create a maintenance named JobA that is run manually by Certkiller .com users
in the Sales department. A month later you become concerned that Sales
department users may neglect running JobA and want determine when JobA was
last run.
What should you do? (Choose all that apply.)

A. Run the sp_monitor stored procedure.
B. Run the sp_help_jobhistory stored procedure.
C. Run the sp_help_jobactivity stored procedure.
D. Run the sp_help_job stored procedure.

Answer: B, D

Explanation: The sp_help_job and the sp_help_jobhistory stored procedures
returns information about a job, including when the job was last run.

Incorrect answers:

A: The sp_monitor stored procedure returns server activity statistics. It does not return information related to when a job was last run.
C: SQL Server 2000 does not have an sp_help_jobactivity stored procedure.


QUESTION 128
You work as the network database administrator at Certkiller .com. The
Certkiller .com network consists of a single Active Directory domain named
Certkiller .com. All servers on the Certkiller .com network run Windows 2000 Server
and all client computers run Windows XP Professional.
You are responsible for administering the SQL Server 2000 database of
Certkiller .com which is used to store business information. You have recently
received instruction from the Certkiller .com CIO to create a multiserver job on a
master SQL Server 2000 computer. During the course of the day you modify the
multiserver job using the sp_update_jobstep stored procedure.
You are required to ensure that the target servers update the job information
immediately to run the modified version of the job by selecting which stored
procedure to execute.
What should you do?

A. You should execute the sp_post_msx_operation stored procedure.
B. You should execute the sp_msx_update stored procedure.
C. You should execute the sp_msx_defect stored procedure.
D. You should execute the sp_msx_enlist stored procedure.

Answer: A

Explanation: In the scenario you should always keep in mind that executing the
stored procedure updates the sysdownloadlist system table which contains job
information for the target servers. The Target server will download the complete
job definition again.

Incorrect Answers:

B: This option should not be considered for usage in the scenario because there is no
sp_msx_update stored procedure that exists in SQL Server 2000.
C: This option should definitely not be used in the scenario because the
sp_msx_defect stored procedure is used to remove the current server from consideration as a target server.
D: This option should not be used in the scenario because the sp_msx_enlist stored
procedure is used to configure an instance of SQL Server as a target server for a master server.


QUESTION 129
You work as the network database administrator at Certkiller .com. The
Certkiller .com network consists of a single Active Directory domain named
Certkiller .com. All servers on the Certkiller .com network run Windows 2000 Server
and all client computers run Windows XP Professional. Certkiller .com has a main
office and several branch offices.

You are responsible for administering 15 instances of SQL Server 2000 running on
different computers in several branch offices. The main office SQL Server is
configured as the master server and the remaining SQL Server instances are
configured as target servers. You have recently received instruction from the
Certkiller .com network CIO to implement a new SQL Server at the main office. The
new server will be configured as an additional master server.
You are required to configure 5 of the target SQL Server 2000 computers to use the
new master servers as their master using the least amount of administrative effort
to accomplish the task.
What should you do?

A. The 5 target servers should be defected on the original master server. The new
instance of SQL Server should then be defined as a master and enlist the 5 target servers.
B. All the target servers should be defected on the original master server. The new
instance of SQL Server should then be defined as a master server and enlist the 5 target servers. You should finally re-enlist the remaining 9 target server on the original master server.
C. The new instance of SQL Server should be defined as a master and enlist the 5 target servers.
D. The new instance of SQL Server should be defined as a master. You should then defect the 5 target servers from the original master server using the new instance of SQL. You should then finally enlist them as target servers of the new instance of SQL Server.

Answer: A

Explanation: In the scenario you should remember the you should use Enterprise
Manager to configure the new master server and enlist the 5 target servers. You
should also keep in mind that Enterprise Manager can accomplish the task as it
offers several methods of configuring master servers.

Incorrect Answers:

B: You should not take this action in the scenario as you are required to defect only 5 target server, this action creates additional administrative effort.
C: In the scenario you should remember that target servers can be registered to only one master server taking the actions in this option is incorrect.
D: You should not use this option in the scenario because Enterprise Manager can
accomplish the task as it offers several methods of configuring master servers. The
Enterprise Manager enables defecting a target server while connected to the target server or its master server.


QUESTION 130
You work as the database administrator at Certkiller .com. All servers on the
Certkiller .com network run Windows 2000 Server and all database servers run SQL
Server 2000. The Certkiller .com network contains a database server named
Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores
sales data for the company.

You create a maintenance job that runs two statements against the CK_Sales
database and schedule the job to run every evening at 7:30 P.M. The following
morning you confirm that the job ran on schedule. A month later you discover that
the job has failed and no longer runs on schedule. You need to determine the cause
of the problem.
What should you do?

A. Run the sp_monitor stored procedure.
B. Run the sp_trace_setstatus stored procedure.
C. Search the Application log in Event Viewer for SQL-related error messages.
D. Run the sp_help_jobhistory stored procedure.

Answer: D

Explanation: The sp_help_jobhistory stored procedure returns information about
the cause of a job failure.

Incorrect answers:
A: The sp_monitor stored procedure is used to enable and disable statistics about SQL
Server 2000. It does not return information about the cause of a job failure.
B: The sp_trace_setstatus stored procedure is used to start, stop or close a trace. It does not return information about the cause of a job failure.
C: You can use the Application log to determine the cause of a job failure as the
Application log does not record such events.





0 comments:

Post a Comment

Enter Valid e-mail to get all updates of this sites in mail

Enter your email address:

Delivered by FeedBurner

Cheapest predictive dialer for callcenter power dial

Power Dial predictive dialer for callcenter with less investment and more features based in the heart of Hyderabad AP India.Power Dial has setup more then 200 centers and more then 5000 seats supports is provided.
For best quotes, pricing and other details mail me asap at powerdial.hyd@gmail.com

Vivaan Kumar
http://powerdial.blogspot.com/
Cheapest Predictive Dialer power Dial
cheap pd power dial
predictive dialer
predictive dialer for callcenter with less investment power dial
predictive dialer for callcenter with low price
predictive dialer form india
predictive dialer from hyderabad
power dial predictive dialer