[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 81-90

QUESTION 81 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. User mapped to a certificate B. SQL user without login C. Domain user D. SQL user with login   Correct Answer: C Explanation: http://msdn.microsoft.com/en-us/library/ff929071.aspx Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 71-80

QUESTION 71 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 without login B. SQL user with a custom SID C. SQL user with login D. Domain user   Correct Answer: D     QUESTION 72 You Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 61-70

QUESTION 61 You develop a Microsoft SQL Server 2012 database. You create a view from the Orders and OrderDetails tables by using the following definition.     You need to ensure that users are able to modify data by using the view. What should you do?   A. Create an AFTER trigger on the view. B. Modify the view to use the WITH VIEW_METADATA clause. C. Create an INSTEAD OF trigger on the view. D. Modify the view to an indexed view.   Correct Answer: C Explanation: Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 51-60

QUESTION 51 You are writing a set of queries against a FILESTREAM-enabled database. You create a stored procedure that will update multiple tables within a transaction. You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back. Which Transact-SQL statement should you include at the beginning of the stored procedure?   A. SET TRANSACTION ISOLATION LEVEL SERIALIZABLE B. SET XACT_ABORT OFF C. SET TRANSACTION ISOLATION Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 41-50

QUESTION 41 You have a database that contains the tables as shown in the exhibit.     You have the following query:     You need to recreate the query to meet the following requirements:   - Reference columns by using one-part names only. - Sort aggregates by SalesTerritoryID, and then by ProductID. - Order the results in descending order from SalesTerritoryID to ProductID. - The solution must use the existing SELECT clause and FROM clause.   Which code segment should Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 31-40

QUESTION 31 You are developing a database that will contain price information. You need to store the prices that include a fixed precision and a scale of six digits. Which data type should you use?   A. Float B. Money C. Smallmoney D. Numeric   Correct Answer: D Explanation: Numeric is the only one in the list that can give a fixed precision and scale. http://msdn.microsoft.com/en-us/library/ms179882.aspx     QUESTION 32 You administer a Microsoft SQL Server database Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 21-30

QUESTION 21 You develop a database for a travel application. You need to design tables and other database objects. You need to store media files in several tables. Each media file is less than 1 MB in size. The media files will require fast access and will be retrieved frequently. What should you do?   A. Use the CAST function. B. Use the DATE data type. C. Use the FORMAT function. D. Use an appropriate collation. E. Use a user-defined table type. F. Use the VARBINARY data Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 11-20

QUESTION 11 Your database contains two tables named DomesticSalesOrders and InternationalSalesOrders. Both tables contain more than 100 million rows. Each table has a Primary Key column named SalesOrderId. The data in the two tables is distinct from one another. Business users want a report that includes aggregate information about the total number of global sales and total sales amounts. You need to ensure that your query executes in the minimum possible time. Which query should you use?   Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-461 Real Exam 1-10

QUESTION 1 You develop a Microsoft SQL Server 2012 server database that supports an application. The application contains a table that has the following definition:   CREATE TABLE Inventory (ItemID int NOT NULL PRIMARY KEY, ItemsInStore int NOT NULL, ItemsInWarehouse int NOT NULL)   You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse values for each row. Which Transact-SQL statement should you use?   A. ALTER TABLE InventoryADD Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 231-240

QUESTION 231 Your network contains an Active Directory domain named contoso.com. Domain controllers run either Windows Server 2008, Windows Server 2008 R2, or Windows Server 2012. You have a Password Settings object (PSOs) named PSO1. You need to view the settings of PSO1. Which tool should you use?   A. Group Policy Management B. Get-ADFineGrainedPasswordPolicy C. Get-ADDefaultDomainPasswordPolicy D. Server Manager   Correct Answer: B     QUESTION 232 HOTSPOT Your Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 251-260

QUESTION 251 Your network contains an Active Directory domain named contoso.com. The domain contains 2 WSUS servers, ServerA and ServerB. ServerB is a replica server of ServerA. You need to configure WSUS to report data from SERVERB to SERVERA. What should you configure?   A. Update Reports B. Synchronization C. Computer Groups D. Reporting Rollup   Correct Answer: D   QUESTION 252 HOTSPOT Your network contains an Active Directory domain named adatum.com. You have a Group Read more [...]

[Free] Download New Updated (October 2016) Microsoft 70-411 Real Exam 241-250

QUESTION 241 You have a Direct Access Server named Server1 running Server 2012. You need to add prevent users from accessing websites from an Internet connection. What should you configure?   A. Split Tunneling B. Security Groups C. Force Tunneling D. Network Settings   Correct Answer: C     QUESTION 242 Your network contains an Active Direct ory domain named contoso.com. The domain does not contain a certification authority (CA). All servers run Windows Server 2012. Read more [...]