×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You administer a single server that contains a Microsoft SQL Server 2012 default instance. You plan to install a
new application that requires the deployment of a database on the server. The application login requires
sysadmin permissions. You need to ensure that the application login is unable to access other production
databases. What should you do?
2.
You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. You discover
performance issues when large amounts of data are written to tables under heavy system load. You need to
limit the number of cores that handle I/O. What should you configure?
3.
You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage
area network (SAN). The financial database has the following characteristics:
4.
You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage
area network (SAN). The financial database has the following characteristics:
5.
You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage
area network (SAN). The financial database has the following characteristics:
6.
You administer a Microsoft SQL Server 2012 instance named SQL2012 that hosts an OLTP database of 1
terabyte in size. The database is modified by users only from Monday through Friday from 09:00 hours to 17:00
hours. Users modify more than 30 percent of the data in the database during the week. Backups are performed
as shown in the following schedule:
The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch process
will take a maximum of 8 hours to complete. The batch process will update three tables that are 10 GB in size.
The batch process will update these tables multiple times. When the batch process completes, the Finance
department runs a report to find out whether the batch process has completed correctly. You need to ensure
that if the Finance department disapproves the batch process, the batch operation can be rolled back in the
minimum amount of time. What should you do on Saturday?
7.
You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail
sales application. The application generates hundreds of transactions per second and is online 24 hours per
day and 7 days per week. You plan to define a backup strategy for the database. You need to ensure that the
following requirements are met:
8.
You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size. The Sales
database is configured as shown in the following table.
You discover that all files except Sales_2.ndf are corrupt. You need to recover the corrupted data in the
minimum amount of time. What should you do?
9.
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need
to write messages to the Application Log when users are added to or removed from a fixed server role in
Server01. What should you create?
10.
You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01. You need
to be notified immediately when fatal errors occur on Server01. What should you create?