What should you do?
You work as the network administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com has its headquarters located in London and branch office located in Paris. All servers on the Domain.com network run Windows Server 2008 and all client computers run Windows Vista. Domain.com currently makes use two computers named CERTKILLER-SR01 and CERTKILLER-SR02 configured as DNS servers. The configuration of the DNS servers is shown in the exhibit below:
exhibit
During the course of the day you receive complaints from the network users that they are not able to connect to Internet websites while using CERTKILLER-SR02 as their preferred DNS server. Domain.com recently requested that you enable Internet name resolution for all client computers on the network.
What should you do?
What should you do?
You work as an enterprise administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2008. The Domain.com network contains two DNS servers.
The DNS servers are named CERTKILLER-SR13 and CERTKILLER-SR14. The exhibit below illustrates how the DNS servers are configured:
You receive numerous complaints from domain users that they are unable to establish a connection to Internet Web sites. You check and discover that the error occurs with the users that make use of CERTKILLER-SR14. To ensure that enhance productivity you need to ensure that the Internet name resolution is enabled for all user workstations.
What should you do?
What should you do?
You work as the network administrator at Domain.com. The Domain.com network consists of two Active Directory forests named Domain.com and us.Domain.com. All servers on the Domain.com network run Windows Server 2008 and all client computers run Windows Vista. Domain.com currently makes use of three computer named CERTKILLER-SR01, CERTKILLER- SR02 and CERTKILLER-SR03 which are configured as DNS servers. The settings of the DNS servers are shown in the exhibit below:
CERTKILLER-SR03 is configured for all workstations in the CertKiller-south.com domain as the DNS server. CERTKILLER-SR01 is configured as the DNS server for the other workstations. During routine monitoring you discover that employees from CertKiller-south.com are unable to connect to the servers belonging to CertKiller-north.com. You receive an instruction from the CIO
to make sure that all CertKiller-south.com queries can be resolved by employees at CertKiller- north.com.
What should you do?
Which view should you create for Region1?
You manage a SQL Server 2008 database that is located at your company’s corporate headquarters.
The database contains a table named dbo.Sales. You need to create different views of the dbo.Sales table that will be used by each region to insert, update, and delete rows. Each regional office must only be able to insert, update, and delete rows for their respective region.
Which view should you create for Region1?
Which catalog view should you use?
You need to identify which tables are referenced by name in a stored procedure that does not use dynamic SQL.
Which catalog view should you use?
Which Transact-SQL statement should you use?
You are given a database design to evaluate. All of the tables in this database should have a clustered index.
You need to determine the tables that are missing a clustered index by using the system catalog views.
Which Transact-SQL statement should you use?
Which permissions should be granted?
You attempt to query sys.dm_db_index_usage_stats to check the status on the indexes in the Contoso database. The query fails and you receive the following error:
"The user does not have permission to perform this action."
You need to have the least amount of permissions granted to access the dynamic management views.
Which permissions should be granted?
Which resource should you investigate first?
You notice that a database server is responding slowly to queries. You run the following dynamic management views (DMV) query on the server.
SELECT TOP (10) wait_type, wait_time_ms FROM sys.dm_os_wait_stats
ORDER BY wait_time_ms DESC;
The query returns a top wait type of SOS_SCHEDULER_YIELD.
You need to identify what is causing the server response issues. Which resource should you investigate first?
Which dynamic management view should you use?
You need to build CREATE INDEX statements for all the missing indexes that SQL Server has identified.
Which dynamic management view should you use?
Which format should you choose?
You are tasked with creating a workload that will be used by the Database Engine Tuning Advisor (DTA).
You need to create a workload in an appropriate format.
Which format should you choose? (Each correct answer represents a complete solution. Choose three.)