Microsoft 70-761 Questions Answers

You develop a Microsoft SQL Server 2012 database.
You need to create and call a stored procedure that meets the following requirements:
Accepts a single input parameter for CustomerID.
Returns a single integer to the calling application.
Which Transact-SQL statement or statements should you use? (Each correct answer presents part of the solution. Choose all that apply.)

A. CREATE PROCEDURE dbo.GetCustomerRating @Customer INT, @CustomerRatIng INT OUTPUT
AS
SET NOCOUNT ON SELECT @CustomerRating = CustomerOrders/CustomerValue FROM Customers WHERE CustomerID = @CustomerID
RETURN
GO
B. EXECUTE dbo.GetCustomerRatIng 1745
C. DECLARE @customerRatingBycustomer INT
DECLARE @Result INT
EXECUTE @Result = dbo.GetCustomerRating
, @CustomerRatingSyCustomer
D. CREATE PROCEDURE dbo.GetCustomerRating @CustomerID INT, @CustomerRating INT OUTPUT
AS
SET NOCOUNT ON
SELECT @Result = CustomerOrders/CustomerValue
FROM Customers WHERE CustomerID = @CustomeriD
RETURN @Result
GO
E. DECLARE @CustomerRatIngByCustcmer INT
EXECUTE dbo.GetCustomerRating @CustomerID = 1745,
@CustomerRating = @CustomerRatingByCustomer OUTPUT
F. CREATE PROCEDURE dbo.GetCustomerRating
@CustomerID INT
AS
DECLARE @Result INT
SET NOCOUNT ON
SELECT @Result = CustomerOrders/CustomerVaLue
FROM Customers
WHERE Customer= = @CustomerID
RETURNS @Result

Answer: AE

Microsoft 70-761 Questions Answers

You administer a Microsoft SQL Server 2012 database that contains a table named OrderDetail. You discover that the NCI_OrderDetail_CustomerID non-clustered index is fragmented. You need to reduce fragmentation.
You need to achieve this goal without taking the index offline. Which Transact-SQL batch should you use?

A. CREATE INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID WITH DROP EXISTING
B. ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REORGANIZE
C. ALTER INDEX ALL ON OrderDetail REBUILD
D. ALTER INDEX NCI_OrderDetail_CustomerID ON OrderDetail.CustomerID REBUILD

Answer: B


You develop a Microsoft SQL Server 2012 database. The database is used by two web applications that access a table named Products.
You want to create an object that will prevent the applications from accessing the table directly while still providing access to the required data.
You need to ensure that the following requirements are met:
Future modifications to the table definition will not affect the applications' ability to access data.
The new object can accommodate data retrieval and data modification. You need to achieve this goal by using the minimum amount of changes to the existing applications.
What should you create for each application?

A. views
B. table partitions
C. table-valued functions
D. stored procedures

Answer: A

Microsoft 70-761 Question Answer

You are a database developer at an independent software vendor. You create stored procedures that contain proprietary code. You need to protect the code from being viewed by your customers. Which stored procedure option should you use?

A. ENCRYPTBYKEY
B. ENCRYPTION
C. ENCRYPTBYPASSPHRASE
D. ENCRYPTBYCERT

Answer: B


You use a Microsoft SQL Server 2012 database.
You want to create a table to store Microsoft Word documents.
You need to ensure that the documents must only be accessible via Transact-SQL queries.
Which Transact-SQL statement should you use?

A. CREATE TABLE DocumentStore
(
[Id] INT NOT NULL PRIMARY KEY,
[Document] VARBINARY(MAX) NULL
)
GO
B. CREATE TABLE DocumentStore
(
[Id] hierarchyid,
[Document] NVARCHAR NOT NULL
)
GO
C. CREATE TABLE DocumentStore AS FileTable
D. CREATE TABLE DocumentStore
(
[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE, [Document] VARBINARY(MAX) FILESTREAM NULL
)
GO

Answer: A

Microsoft 70-761 Question Answer

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 XACT_ABORT ON
B. SET ARITHABORT ON
C. TRY
D. BEGIN
E. SET ARITHABORT OFF
F. SET XACT_ABORT OFF

Answer: A


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?

A. SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM (
SELECT SalesOrderId, SalesAmount
FROM DomesticSalesOrders
UNION ALL
SELECT SalesOrderId, SalesAmount
FROM InternationalSalesOrders
) AS p
B. SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM (
SELECT SalesOrderId, SalesAmount
FROM DomesticSalesOrders
UNION
SELECT SalesOrderId, SalesAmount
FROM InternationalSalesOrders
) AS p
C. SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM DomesticSalesOrders
UNION
SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM InternationalSalesOrders
D. SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM DomesticSalesOrders
UNION ALL
SELECT COUNT(*) AS NumberOfSales, SUM(SalesAmount) AS TotalSalesAmount FROM InternationalSalesOrders

Answer: A

Microsoft's Windows 10 Free Accessibility Upgrade Offer Ends Dec. 31

Are you still attached to Windows 7 or Windows 8.1? Time is running out quickly for users who want to upgrade to Windows 10 at no cost, as long as they use the operating system support technologies.

Officially, the last day that users were able to obtain a free update of Windows 10 was on July 29. Users wishing to install Windows 10 on a PC now must pay for the operating system, which starts at $ 119 for the Home edition and $ 199 for Windows 10 Pro.

However, not everyone has to part with their money. Microsoft extended the deadline for users to trust the Windows screen reader, the magnifying glass, high contrast settings and other features that improve accessibility.

Now, when 2017 comes to an end, users only have a few days to get the free update.

The free upgrade offer for Windows 10 for assistive technology users expires on December 31. Microsoft does not restrict the offer to any specific use of its accessibility features, however, the company recommends that users check with third-party support technology providers to ensure that their applications are compatible with Windows 10.

According to Microsoft, users with disabilities and other conditions that have difficulties with the Windows stock experience will find many compelling reasons to upgrade to Windows 10.

First, the Windows text-to-speech engine got a major upgrade in the Windows 10 anniversary update of 2016. The voice technology of the operating system used in Narrator can now handle approximately 800 words per minute, twice the limit previous of around 400 words per minute.

The narrator is now available in several languages ​​and pairs of countries, which expands its international appeal. For example, Narrator can now speak Dutch in Belgium and the Netherlands or French in Canada when the corresponding localized version of Windows is purchased in those countries (also available as a separate download).

Narrator also won a scanning mode that allows users to activate a feature or item of interest more easily. Users can activate Scan Mode by pressing the Caps Lock and the space bar. Once enabled, users can activate actions, such as visiting a web link, simply by pressing the space bar.

Microsoft's accessibility efforts extend far beyond Windows.

On December 13, the software giant announced a major update to its Seeing AI application for iOS devices. The application uses an iPhone or iPad camera, along with Microsoft's artificial intelligence (AI) set of technologies to help visually impaired users experience the world around them with verbal descriptions of their physical environments, in addition to the people and the objects that inhabit them. .

The updated application now has handwriting recognition, which allows users to read personal notes or fonts that mimic handwritten text. Seeing AI also takes away some of the anxiety of buying or leaving a tip in cash at a restaurant with a new currency recognition feature. Currently, it supports US dollars, Canadian dollars, euros and pounds sterling.

Other new features include color recognition, a document reader and a musical light detector that generates an audible tone when the camera is held up to a light.

Microsoft 70-761 Question Answer

You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event names and their dates as parameters. 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 type.
G. Use the DATETIME data type.
H. Use the DATETIME2 data type.
I. Use the DATETIMEOFFSET data type.
J. Use the TODATETIMEOFFSET function.

Answer: E



You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders. The tables are related by a column named CustomerID.
You need to create a query that meets the following requirements:
Returns the CustomerName for all customers and the OrderDate for any orders that they have placed. 
Results must include customers who have not placed any orders.
Which Transact-SQL query should you use?

A. SELECT CustomerName, OrderDate
FROM Customers
RIGHT OUTER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
B. SELECT CustomerName, CrderDate
FROM Customers
JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
C. SELECT CustomerName, OrderDate
FROM Customers
CROSS JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
D. SELECT CustomerName, OrderDate
FROM Customers
LEFT OUTER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID

Answer: D

Microsoft Launches New Windows 10 Keyboard Which Includes A Hidden Security Update

 Microsoft unveiled its successor to the surface keyboard, the modern keyboard, which seems virtually identical to its predecessor.

However, hidden between the alt and ctrl keys is a hidden fingerprint scanner.

It is designed to blend into the keyboard so it looks like any other key to the eye without discernment.

Describing the feature, Microsoft said: "Our vision was to blend the fingerprint reader into a keyboard, so it would seem to be any other key.

"We've been iterating tirelessly to improve each layer, making sure that they teamed up to create a seamless typing experience that felt like any other key."

The fingerprint scanner allows users to log on to Windows 10 or websites with Windows Hello.

The modern keyboard will work with Windows 10, MacOS and the latest versions of Android.

The Microsoft product comes in a silver and gray finish, and can work as a wired keyboard, or wirelessly via Bluetooth 4.0.

Microsoft said the Modern Keyboard will work particularly well with Windows 10 Surface Studio, Pro and Laptop devices.

It will also work with computers that use Windows 8 and above, as well as Windows 10 Phone. In the United States it has traded at $ 129.99 (£ 101.58).

Microsoft also unveiled the modern mouse, which features invisible close-up buttons and a metal scroll wheel.

 It uses Bluetooth 4.0 and Microsoft promised the mouse boasts "exceptional precision.”

It requires a pair of AAA batteries, while the Modern Keyboard is powered off of a rechargeable battery.

No specific release date has been given, but both devices are “coming soon”.

The Surface Keyboard, which was only recently debuted, is currently available and costs £89.99 from the Microsoft Store.

In other Windows news, we recently revealed how - despite the free upgrade offer ending last year - you might still be able to upgrade Windows 10 free.