Microsoft 70-762 Qustions Answers

You develop a Microsoft SQL Server 2012 database.
You need to create a batch process that meets the following requirements:
Returns a result set based on supplied parameters.
Enables the returned result set to perform a join with a table.
Which object should you use?

A. Inline user-defined function
B. Stored procedure
C. Table-valued user-defined function
D. Scalar user-defined function

Answer: C

https://www.microsoft.com/en-us/learning/exam-70-762.aspx

https://www.dumpspedia.co/70-762-dumps.html

Microsoft 70-762 Qustions 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-762 Qustions Answers

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-762 Qustion 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 70-762 Qustion Answer

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's Virtual Reality Attempt Fails To Impress

In October, Microsoft (NASDAQ: MSFT) entered the virtual reality business with its Windows Mixed Reality platform and its third-party headset line. The move was seen as an entry into a business that potentially was worth billions, and the mixed reality nickname indicates that the company has plans for more devices in the future.

It may make sense for Microsoft to try to build a virtual reality platform because the long-term gains will be with the company that owns the platform. But that potential also makes the virtual reality product disappointing for both consumers and investors.

The mixed reality of Microsoft is only a virtual reality of low quality

Facebook (NASDAQ: FB) Oculus Rift and HTC's Vive are the two high-end virtual reality platforms; both have been in the market since the spring of 2016. They have only sold around one million units each, but they are the clear leaders in the market. Microsoft saw an opening to build its own platform, and that is what is happening.

Instead of creating an RV product that works like Rift or Live, which uses external sensors to track the movement of a user in a hearing aid, Microsoft uses sensors in the hearing aid to track the movement. It's not exactly the unattached inside-out technology that VR users expect, but it's a unique way to track virtual reality.

The problem is that the two sensors that follow the movement of the head and the controllers leave many blind spots. Keep a controller close to your chest, and the system fails. In the game, that is a great weakness; it makes Windows Mixed Reality clearly inferior to Rift and Vive, despite having been released a year and a half later. Even the headset display and latency seem inferior to those of the competition.

What problem is Microsoft solving?

The question is: what problem in virtual reality is Microsoft trying to solve?

One could argue that their headphones require less computing power than Rift and Live and are less expensive, but the recent price reductions for Rift and Vive have undermined that differentiation. Executing VR on a laptop or on a less expensive desktop computer could also be attractive, but with computer prices falling, this advantage seems untenable.

Apart from some very small usability differences, the mixed reality of Microsoft does not offer any clear differentiation, and in my experience it is clearly inferior to Rift and Vive. So, why does the product exist?

Microsoft has just given up a major opening

A company only has one opportunity to make a first impression, and it seems that Microsoft did not impress consumers with its virtual reality game. That could turn off future consumers looking to buy a headset, directing them to platforms such as Rift and Live.

For developers, the impact could be even more important. Virtual reality developers want to create higher quality content for a large installed base of headphones. At this time, they can transfer existing content to the Microsoft platform, and the newly announced Steam access will be useful. But if Windows Mixed Reality is not considered a quality product and does not generate HTC or Oculus sales, they will abandon the platform.

All this is a risk to the future of Microsoft's X-reality. His first step in space seems a real failure.

10 actions that we like better than Microsoft

By investing geniuses, David and Tom Gardner have an inventory advice, you can pay to listen. After all, the bulletin that has been published for more than a decade, Motley Fool Stock Advisor, has tripled the market.

David and Tom have just revealed what they think are the 10 best stocks that investors can buy right now ... and Microsoft was not one of them! That's right, they believe that these 10 actions are even better purchases.

Satya Nadella’s Weakness Shows He’s Human Like The Rest Of Us

Satya Nadella grew up in Hyderabad, South India, and studied engineering at the Manipal Institute of Technology before moving to the United States. UU And go to the local office at Microsoft in 2014.

But the CEO of Mammoth Technology stayed close to his roots, making frequent trips to India, and often interacting and collaborating with Indian entrepreneurs. Today (Nov. 6), for example, Microsoft and online taxi aggregator Ola have announced an association to build a connected vehicle platform for automakers.

The 50-year-old man also took the stage at a business convention organized by the India Today group in New Delhi today and talked about his love for cricket, Mahatma Gandhi, and artificial intelligence . Excerpts from a conversation with journalist Rajdeep Sardesai:

Cricket or technology, what do you prefer?

One of the most amazing experiences in this book tour was to go to Lord for an interview with ESPN Cricinfo and talk about technology. Then he harmonized all my life for me. I went to Cricket Headquarters and talked about the two things I like the most.

Hyderabad or Redmond, where is the heart of Satya Nadella?

I grew up on the Deccan Plateau and now I live on the Sammamish Plateau, and both are a big part of my life. I always say that I am the product of two incredible American things: the American technology that came to me when I grew up and the American immigration policy that allowed me to live my life.

Choose one: does the iron work or pump?

Operation.

Choose one: ML Jaisimha (former Indian cricketer) or Sachin Tendulkar?

It's hard. But, look, I'm a romantic Hyderabadi in the heart and so ML Jaisimha.

Who is your favorite Indian? Someone who inspired you all these years.

Gandhi ji. There is no question. His life, his message, not only as an Indian but as a citizen of the world ... I think all he has represented is so current.

What do you think will be the next big thing in technology?

The three things I'm thinking about are mixed reality, artificial intelligence (AI), and now it's a little out there, but quantum (computer).

Is there an animated innovation application that you believe is destined to fail?

Whenever you think that's it, it's the final technology you need, it has a limited life.

What is your weakness?

I start a lot of books but I do not finish much.

What is your wish for India and the world in 2018?

I hope we will celebrate not only the incredible opportunity we have to create technology or use technology. But perhaps, the currency of our time will be the surplus (technology) that is created in us and around us. (We must make sure) how is it distributed equitably because that is what creates stability in democracies like India or the United States. This is what creates overall prosperity in the long run, so I hope we can find new growth models that will allow us to move forward.

There are many people who are worried about the impact that AI will have. Can you give them a message?

I firmly believe that technology is a tool. We humans must make decisions. As corporations, governments, policy makers, we will have to make decisions about how you use this technology to create the surplus. That's what will define whether we achieve equitable growth or not.

Can you share your vision for India in 2040?

As a technologist, one thing I try not to do is make these predictions because you will always be wrong. The only thing I believe is that the choices people make in this room in 2017 will define what will happen in 2040 because life depends on the past. Societies are dependent on the past. People who talk about AI - we have a choice in front of us. AI can empower us, AI can be inclusive - depending on the choices we make as AI designers rather than abdicating the responsibility for new technology.