Online Access Free 70-765 Practice Test

You have a database named DB1 that is 3 TB. obi contains a fact table that is 1.2 TB.
You load 200 GB of new data to the fact table from a line-of-business application.
Users of DB1 notice that reports render more slowly since you loaded the data.
What are two possible causes of the performance issue? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

• A.index fragmentation
• B.out-of-date statistics
• C.transaction log growth
• D.page corruption

You administer a Microsoft SQL Server 2014 instance that has multiple databases. You have a two-node SQL Server failover cluster. The cluster uses a storage area network (SAN). You discover I/O issues. The SAN is at capacity and additional disks cannot be added.
You need to reduce the I/O workload on the SAN at a minimal cost.
What should you do?

• A.Move the tempdb files to a local disk
• B.Move user databases to a local disk.
• C.Expand the tempdb data and log files
• D.Modify application code to use table variables

You plan to install a Microsoft SQL Server 2014 instance.
The instance will support a database that has the following requirements:
Store Excel workbooks on the file system.
Access the workbooks through Transact-SQL.
Include the workbooks in database backups.
During installation, you need to ensure that the requirements will be met.
Which feature should you use?

• A.FILESTREAM
• B.OpenXML
• C.Excel Services
• D.SQL Server Integration Services (SSIS)

You are deploying a Microsoft SQL Server database that will support a mixed OLTP and OLAP workload. The target virtual machine has four CPUs.
You need to ensure that reports do not use all available system resources.
What should you do?

• A.Set MAXDOP to half the number of CPUs available.
• B.Enable Auto Close.
• C.Increase the value for the Minimum System Memory setting.
• D.Increase the value for the Minimum Memory per query setting.

You have Microsoft SQL Server on a Microsoft Azure virtual machine.
You create a SQL Server Agent job by using the following statement.

You need to send an email message if the job fails.
Which stored procedure should you use?

• A.msdb.dbo.sp_add_notification
• B.msdb.dbo.sp_add_jobstep
• C.msdb. dbo. sp_updace_alerc
• D.msdb.dbo.sp_help_alert