70-457無料問題集「Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1」

質問 1

You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured as shown in the following table: At 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted on the transactional database. You need to ensure that the transactional database is restored. You also need to ensure that data loss is minimal. What should you do?

（A）Restore the latest full backup.

（B）Perform a point-in-time restore.

（C）Perform a page restore.

（D）Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.

（E）Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.

（F）Perform a partial restore.

（G）Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.

（H）Restore the latest full backup. Then, restore the latest differential backup.

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 2

You administer a Microsoft SQL Server 2012 database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.)

You need to display rows from the Orders table for the Customers row having the CustomerId value set to 1 in the following XML format.

Which Transact-SQL query should you use?

（A）SELECT Name AS 'Customers/Name', Country AS 'Customers/Country', OrderId, OrderDate, Amount FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers. CustomerId WHERE Customers.CustomerId = 1 FOR XML PATH ('Customers')

（B）SELECT Name, Country, OrderId, OrderDate, Amount FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers. CustomerId WHERE Customers.CustomerId = 1 FOR XML AUTO, ELEMENTS

（C）SELECT Name, Country, OrderId, OrderDate, Amount FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers.
CustomerId
WHERE Customers.CustomerId = 1
FOR XML AUTO

（D）SELECT OrderId, OrderDate, Amount, Name, Country FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers. CustomerId WHERE Customers.CustomerId = 1 FOR XML AUTO

（E）SELECT Name AS '@Name', Country AS '@Country', OrderId, OrderDate, Amount FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers. CustomerId WHERE Customers.CustomerId = 1 FOR XML PATH ('Customers')

（F）SELECT OrderId, OrderDate, Amount, Name, Country FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers. CustomerId WHERE Customers.CustomerId = 1 FOR XML AUTO, ELEMENTS

（G）SELECT OrderId, OrderDate, Amount, Name, Country FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers. CustomerId WHERE Customers.CustomerId = 1 FOR XML RAW, ELEMENTS

（H）SELECT OrderId, OrderDate, Amount, Name, Country FROM Orders INNER JOIN Customers ON Orders.CustomerId = Customers. CustomerId WHERE Customers.CustomerId = 1 FOR XML RAW

正解：F 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

You administer a Microsoft SQL Server 2012. A process that normally runs in less than 10 seconds has been running for more than an hour. You examine the application log and discover that the process is using session ID 60. You need to find out whether the process is being blocked. Which Transact-SQL statement should you use?

（A）SELECT * FROM sys.dm_exec_requests WHERE session_id = 60

（B）SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60

（C）EXEC sp_helpdb 60

（D）DBCC OPENTRAN

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 4

You have a database that contains the tables shown in the exhibit. (Click the Exhibit button).

You need to create a query for a report. The query must meet the following requirements:
NOT use object delimiters.
Return the most recent orders first.
Use the first initial of the table as an alias.
Return the most recent order date for each customer.
Retrieve the last name of the person who placed the order.
Return the order date in a column named MostRecentOrderDate that appears as the last column in the report.
The solution must support the ANSI SQL-99 standard.
Which code segment should you use?
To answer, type the correct code in the answer area.

（A）select C.Lastname, P.MostRecentOrderDate from customers AS C inner join ( select customID, MostRecentOrderDate=max(orderDate) from orders group by customID
)P
on C.customerID=P.CustomerID
order by P.MostRecentOrderDate desc

（B）SELECT LastName, O.OrderDate AS MostRecentOrderDate FROM Customers AS C INNER JOIN Orders AS O ON CustomerID = O.CustomerID ORDER BY O.OrderDate DESC

（C）SELECT c.CustomerID --optional c.LastName, max(o.OrderDate) 'MostRecentOrderDate' FROM Customer c LEFT OUTER JOIN Orders o ON o.CustomerID = c.CustomerID GROUP BY c.CustomerID, c.LastName ORDER BY 3 DESC

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of user should you create?

（A）SQL user with login

（B）Domain user

（C）User mapped to a certificate

（D）SQL user without login

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 6

You administer a Microsoft SQL Server 2012 instance that contains a database of confidential data. You need to encrypt the database files at the page level. You also need to encrypt the transaction log files. Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Build List and Reorder:

正解：

Explanation:
Reference: http://msdn.microsoft.com/en-us/library/bb510663.aspx Reference: http://msdn.microsoft.com/en-us/library/bb934049.aspx

質問 7

You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project Deployment Model together with parameters and Integration Services environment variables. You need to configure the SQL Server environment to support these packages. What should you do?

（A）Create SSIS configuration files for the packages.

（B）Create an Integration Services catalog.

（C）Install Master Data services.

（D）Install Data Quality Services.

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 8

質問 9

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012. You
attempt to add the [Corpnet\User1] login to the database. However, you receive the following error
message:
"User already exists in current database."
You need to configure the [Corpnet\User1] login to be able to access the Orders database and retain the
original permissions. You need to achieve this goal by using the minimum required permissions.
Which Transact-SQL statement should you use?

（A）DROP USER [User1]; CREATE USER [Corpnet\User1] FOR LOGIN [Corpnet\User1]; ALTER ROLE [db_owner] ADD MEMBER [Corpnet\User1];

（B）ALTER USER [Corpnet\User1] WITH LOGIN [Corpnet\User1];

（C）ALTER ROLE [db_owner] ADD MEMBER [Corpnet\User1];

（D）ALTER SERVER ROLE [sysadmin] ADD MEMBER [Corpnet\User1];

正解：B 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 10

You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. You discover performance issues when large amounts of data are written to tables under heavy system load. You need to limit the number of cores that handle I/O. What should you configure?

（A）Max worker threads

（B）Lightweight pooling

（C）Processor affinity

（D）I/O affinity

正解：D 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

70-457 無料問題集「Microsoft Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1」

弊社を連絡する

関連リンク

トップ試験