70-765 試験問題を無料オンラインアクセス

You administer a Microsoft SQL Server 2014 instance that contains a financial database hosted on a storage area network (SAN).
The financial database has the following characteristics:
The database is continually modified by users during business hours from Monday through Friday between 09:00 hours and 17:00 hours. Five percent of the existing data is modified each day.
The Finance department loads large CSV files into a number of tables each business day at 11:15 hours and 15:15 hours by using the BCP or BULK INSERT commands. Each data load adds 3 GB of data to the database.
These data load operations must occur in the minimum amount of time.
A full database backup is performed every Sunday at 10:00 hours. Backup operations will be performed every two hours (11:00, 13:00, 15:00, and 17:00) during business hours.
You need to ensure that the minimum amount of data is lost.
Which recovery model should the database use?

• A.NO_CHECKSUM
• B.Differential
• C.STANDBY
• D.SIMPLE
• E.SKIP
• F.CHECKSUM
• G.BULK_LOGGED
• H.Transaction log
• I.FULL
• J.RESTART
• K.CONTINUE AFTER ERROR
• L.DBO ONLY
• M.COPY_ONLY
• N.NORECOVERY

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets stated goals.
You have a mission-critical application that stores data in a Microsoft SQL Server instance. The application runs several financial reports. The reports use a SQL Server-authenticated login named Reporting_User. All queries that write data to the database use Windows authentication.
Users report that the queries used to provide data for the financial reports take a long time to complete. The queries consume the majority of CPU and memory resources on the database server. As a result, read-write queries for the application also take a long time to complete.
You need to improve performance of the application while still allowing the report queries to finish.
Solution: You create a snapshot of the database. You configure all report queries to use the database snapshot.
Does the solution meet the goal?

• A.No
• B.Yes

You have database that contains a 400-GB table that is read-only.
You need to enable the Stretch Database feature.
How should you complete the statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

正解：

Explanation:
Section: Deploy and migrate applications
To configure an existing table for Stretch Database, run the ALTER TABLE command.
Here's an example that migrates the entire table and begins data migration immediately.
USE <Stretch-enabled database name>;
GO
ALTER TABLE <table name>
SET ( REMOTE_DATA_ARCHIVE = ON ( MIGRATION_STATE = OUTBOUND ) ) ;
GO
References:
https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/enable-stretch-database-for-atable

You have on-premises database server.
The database files for a user database are configured as shown in the following table:

You plan to migrate the on-premises database server to Microsoft SQL Server on a Microsoft Azure virtual machine.
You need to provision storage for the virtual machine to meet the following requirements: Support the same configurations as the on-premises database server.
Provide a Service Level Agreement (SLA) for performance.
Minimize costs.
Which type of storage should you provision for each file type? To answer, drag the appropriate storage types to the correct file types. Each storage type may be used once, more than once or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

正解：

Explanation:
Standard Storage has varying latencies and bandwidth and is only recommended for dev/test workloads.
Production workloads should use Premium Storage.
References:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windowssql-performance

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains unique solution. Determine whether the solution meets the stated goals.
You deploy a new Microsoft Azure SQL Database instance to support a variety of mobile applications and public websites. You configure geo-replication with regions in Brazil and Japan.
You need to implement real-time encryption of the database and all backups.
Solution: You use the Always Encrypted Wizard to encrypt all possible columns for the tables in the primary instance.
Does the solution meet the goal?

• A.No
• B.Yes