Free Microsoft 070-465 Exam Dumps Questions & Answers

You are designing a SQL Server database for an order fulfillment system. You create a table named Sales.Orders by using the following script:

----
Each order is tracked by using one of the following statuses:
Fulfilled
Shipped
Ordered
Received
You need to design the database to ensure that you can retrieve the status of an order on a given date. The solution must ensure that new statuses can be added in the future.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.  Create a new table named Sales.OrderStatus that contains three columns named OrderID, StatusDate, and Status. Insert new rows into the table as the order status changes.
• B.  To the Sales.Orders table, add three columns named FulfilledDate, ShippedDate, and ReceivedDate. Update the value of each column from null to the appropriate date as the order status changes.
• C.  To the Sales.Orders table, add a column named Status that will store the order status. Update the Status column as the order status changes.
• D.  Implement change data capture on the Sales.Orders table.

----
You have an SQL Server 2014 server named SQL1.
You are designing a performance monitoring solution.
You need to monitor the following events on SQL1:
A deadlock graph
Missing column statistics
CPU performance statistics
A batch of completed Transact-SQL statements
Which two tools should you use? Each correct answer presents a complete solution.

• A.  dynamic management views
• B.  Data Profile Viewer
• C.  Database Engine Tuning Advisor
• D.  SQL Server Profiler
• E.  Activity Monitor

You manage a SQL Server 2014 instance that contains a database named DB1.
Users report that some queries to DB1 take longer than expected. Although most queries run in less than one second, some queries take up to 20 seconds to run.
You need to view all of the performance statistics for each database file.
Which method should you use?

• A.  Query the sys.dm_os_performance_counters dynamic management view.
• B.  Query the sys.dm_os_tasks dynamic management view.
• C.  Examine the Data File I/O pane in Activity Monitor.
• D.  Query the sys.dm_io_virtual_file_stats dynamic management function.

You have a SQL Server 2014 environment that contains 20 servers. The corporate security policy states that all SQL Server 2014 instances must meet specific
security standards.
You need to recommend a management strategy for the SQL Server 2014 servers.
What should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.  Policy-Based Management
• B.  Maintenance plans
• C.  Common criteria compliance
• D.  Multi server jobs

You need to recommend a solution to ensure that USP_4 adheres to the security requirements.
What should you include in the recommendation?

• A.  Enable C2 audit tracing.
• B.  Configure data manipulation language (DML) triggers.
• C.  Enable SQL Server Audit.
• D.  Enable trace flags.