70-469 無料問題集「Microsoft Recertification for MCSE: Data Platform」
You have a database named Database1. You execute the following code:
You have the following query. (Line numbers are included for reference only.)
Users report that the query takes a long time to complete.
You create a full-text index for the Notes column.
You need to recommend changes to the query to reduce the amount of time it takes for the query to complete.
Which code segment should you use to replace line 03?
You have the following query. (Line numbers are included for reference only.)
Users report that the query takes a long time to complete.
You create a full-text index for the Notes column.
You need to recommend changes to the query to reduce the amount of time it takes for the query to complete.
Which code segment should you use to replace line 03?
正解：C
解答を投票する
DRAG DROP
You plan to deploy two stored procedures named SP1 and SP2 that read data from the database.
Your company identifies the following requirements for each stored procedure:
- SP1 must allow dirty reads.
- SP2 must place range locks on the data to ensure read consistency.
You need to identify which isolation level you must set for each stored procedure. The solution must minimize the number of locks.
Which isolation level should you identify?
To answer, drag the appropriate isolation level to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)
You plan to deploy two stored procedures named SP1 and SP2 that read data from the database.
Your company identifies the following requirements for each stored procedure:
- SP1 must allow dirty reads.
- SP2 must place range locks on the data to ensure read consistency.
You need to identify which isolation level you must set for each stored procedure. The solution must minimize the number of locks.
Which isolation level should you identify?
To answer, drag the appropriate isolation level to the correct stored procedure in the answer area. (Answer choices may be used once, more than once, or not at all.)
正解：
You have a SQL Azure database. You execute the following code:
The Sales.Customers table will contain 100,000 rows. You expect the FaxNumber column to contain a null value for 70 percent of the rows.
You need to create an index to support Sales.CustomersByFaxNumber. The solution must minimize the disk storage requirements.
Which code segment should you execute?
The Sales.Customers table will contain 100,000 rows. You expect the FaxNumber column to contain a null value for 70 percent of the rows.
You need to create an index to support Sales.CustomersByFaxNumber. The solution must minimize the disk storage requirements.
Which code segment should you execute?
正解：B
解答を投票する
You have a Microsoft SQL Azure database. You have the following stored procedure:
You discover that the stored procedure periodically fails to update Person.Contact.
You need to ensure that Person.Contact is always updated when UpdateContact executes. The solution must minimize the amount of time required for the stored procedure to execute and the number of locks held.
What should you do?
You discover that the stored procedure periodically fails to update Person.Contact.
You need to ensure that Person.Contact is always updated when UpdateContact executes. The solution must minimize the amount of time required for the stored procedure to execute and the number of locks held.
What should you do?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have an index for a table in a SQL Azure database. The database is used for Online
Transaction Processing (OLTP).
You discover that the index consumes more physical disk space than necessary.
You need to minimize the amount of disk space that the index consumes.
What should you set from the index options?
Transaction Processing (OLTP).
You discover that the index consumes more physical disk space than necessary.
You need to minimize the amount of disk space that the index consumes.
What should you set from the index options?
正解：C
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
DRAG DROP
You are designing a database for a university. The database will contain two tables named
Classes and StudentGrades that have the following specifications:
- Classes will store brochures in the XPS format. - The brochures must be structured in folders and must be accessible byusing UNC paths. - StudentGrades must be backed up on a separate schedule than the rest ofthe database.
You need to identify which SQL Server technology meets the specifications of each table. Which technologies should you identify? To answer, drag the appropriate technology to the correct table in the answer area.
You are designing a database for a university. The database will contain two tables named
Classes and StudentGrades that have the following specifications:
- Classes will store brochures in the XPS format. - The brochures must be structured in folders and must be accessible byusing UNC paths. - StudentGrades must be backed up on a separate schedule than the rest ofthe database.
You need to identify which SQL Server technology meets the specifications of each table. Which technologies should you identify? To answer, drag the appropriate technology to the correct table in the answer area.
正解：
