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

You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders.
Users report that a query that filters on OrderDate is taking an exceptionally long time. You discover that an index named IX_OrderDate on the CustomerOrder table is heavily fragmented.
You need to improve the performance of the IX_OrderDate index. The index should remain online during the operation.
Which Transact-SQL command should you use?

• A.Option A
• B.Option C
• C.Option B
• D.Option D

You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure. You need to grant only the necessary permissions.
What should you do?

• A.Create a new database role. Grant EXECUTE permission on p_AddInventory to the newrole. Add all users to the role. Add all users to the db_datareader role.
• B.Add all users to the db_datawriter role. Add all users to the db_datareader role.
• C.Create a new database role. Grant EXECUTE permission on p_AddInventory to the new role. Grant VIEW DEFINITION to to the role. Add all users to the role.
• D.Add EXECUTE AS OWNER to the stored procedure. Add all users to the db_datareader role.

----
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:
A data file of 2 terabytes is located on a dedicated LUN (drive D).
A transaction log of 10 GB is located on a dedicated LUN (drive E).
Drive D has 1 terabyte of free disk space.
Drive E has 5 GB of free disk space.
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 your backup will continue if any invalid checksum is encountered.
Which backup option should you use?

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

You administer a Microsoft SQL Server 2012 database.
You create an availability group named haContosoDbs. Your primary replica is available at Server01\Contoso01.
You need to configure the availability group to minimize transaction latency on any available secondary databases. In the event of a database failure, the designated secondary database should come online automatically.
Which Transact-SQL statement should you use?

• A.Option A
• B.Option C
• C.Option B
• D.Option D

You develop a SQL Server Integration Services (SSIS) package that imports Windows Azure SQL Database data into a data warehouse every night.
The Windows Azure SQL Database data contains many misspellings and variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value. The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.
What should you do?

• A.Change the Exhaustive property to True.
• B.Decrease the maximum number of matches per lookup.
• C.Change the similarity threshold to 0.40.
• D.Change the similarity threshold to 0.55.