Microsoft 70-461 Exam Questions

Question: 19

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 runtime 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 LEVEL SNAPSHOT
D. SET IMPLICIT_TRANSACTIONS ON
E. SET XACT_ABORT ON
F. SET IMPLICIT TRANSACTIONS OFF

Answer: E

Read More

Microsoft 70-461 Exam Questions

Question: 18

You develop three Microsoft SQL Server 2012 databases named Database1, Database2, and Database3. You have permissions on both Database1 and Database2. You plan to write and deploy a stored procedure named dbo.usp_InsertEvent in Database3. dbo.usp_InsertEvent must execute other stored procedures in the other databases. You need to ensure that callers that do not have permissions on Database1 or Database2 can execute the stored procedure. Which Transact-SQL statement should you use?

A. USE Database2
B. EXECUTE AS OWNER
C. USE Database1
D. EXECUTE AS CALLER

Answer: B

Read More

Microsoft 70-461 Exam Questions

Question: 17

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

Read More

Microsoft 70-461 Exam Questions

Question: 16

You work as a database administrator at manufacturing company named ABC.com. ABC.com has a SQL Server 2012 database named ProductionDB. The ProductionDB database has a table named Sites that was created using the following Transact-SQL code:CREATE TABLE Sites (SiteID int NOT NULL PRIMARY KEY,Location int NOT NULL,Manager nvarchar(200) NOT NULL,Week smallint NOT NULL,ItemsProduced int NOT NULL )You want to write the Transact-SQL query that returns the number of items produced at each location for each week. In addition, you want the result set to include a column named PrevItemsProduced that holds the number of items produced at each location for the week before.What Transact SQL statement would accomplish this task?

A. SELECT Location, Week, ItemsProduced,LEAD(Items Produced, 1, 0) OVER (PARTITION BY Location ORDER BY Week) ASPrevItems Produced FROM Sites

B. SELECT Location, Week, ItemsProduced,FIRST_VALUE(ItemsProduced) OVER (PARTITION BY Location ORDER BY Week) ASPrevItems Produced FROM Sites

C. SELECT Location, Week, ItemsProduced,LAG(ItemsProduced, 1, 0) OVER (PARTITION BY Location ORDER BY Week) ASPrevItemsProduced FROM Sites

D. SELECT Location, Week, ItemsProduced,LAST_VALUE(ItemsProduced) OVER (PARTITION BY Location ORDER BY Week) ASPrevItemsProduced FROM Sites

E. SELECT Location, Week, ItemsProduced,CUME_DIST( ) OVER (PARTITION BY Location ORDER BY Week) AS PrevItemsProduced FROM Sites

Answer: C

Read More

Microsoft 70-461 Exam Questions

Question: 15

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

Answer: C

Read More

Microsoft has its own 'Bing Assistant' bot in the works

Microsoft is building a "caretaker Bing Bot" which is much like the Google Robot recently announced assistant.

Microsoft is building a robotic assistant that, at least on the surface, is very similar to the recently announced Google robot assistant

Called "Bing Bot Concierge," the productivity of the agent will be able to communicate through a variety of platforms conversations, including Skype, Messenger, SMS, WhatsApp and Telegram, a recent study by Microsoft in looking for an engineer to join the team building larval blowfly.

Workstation applications and services Group:
 
 "In Bing Bot Concierge Our team are building a very intelligent productivity of agents that communicates with the user through a platform of discussion as Skype, Messenger, SMS, WhatsApp, telegrams, etc. The agent would a human wizard: runs errands on behalf of the user, by automatically completing tasks for the user users talk with the natural language agent, and the agent answers natural language to gather all the information, once ready, it automatically. the task of the user by connecting to service providers, for example, the user can request "I make a reservation for one night Italian restaurant", and the agent will respond. for how many people '; after several such results back to confirm and book the restaurant that the user has chosen. "

Microsoft officials showed progress in a series of robots built with disposable Bot part of Microsoft, which is currently available in draft form at the company's Build conference in late March. Microsoft began Bot fill your directory with a number of robots developed by the company image as Bing Bot Bot Bot Bot Music Legend Summarize and Bing.

Earlier this week, Kik Interactive has announced that there is now an official channel Kik available on the Microsoft Bot connector. Kik is an email application that is widely used by teenagers and pre-teens.

From May 18 Kik blog about their work with Microsoft:

"After a month of close collaboration between the platform teams of Microsoft bot Kik and engineers, it is now possible for new and existing developers Bot executives have their robots work Kik with minimal effort."

In the same way that the Google search engine Google is able to feed Wizard, Bing is the secret ingredient for new and upcoming Microsoft robots.

In the same way that the Google search engine Google is able to feed Wizard, Bing is the secret ingredient for new and upcoming Microsoft robots.

The Bing team has developed a series of cognitive services and applications that Microsoft programming interfaces is available to bots manufacturers. Some of them include academic programming knowledge interface; interactive search structured data; entity relationship between services; recommendations; image search and news; and the Microsoft Translator service.

The Bing team also led the charge on the way to discern the intentions of users. For this, a service must be understood as a place of fields, time and others. (This is where Cortana received a lot of intelligence.) From Microsoft "Satori" - similar to the graphic knowledge of Google - is what helps translate search queries in a database of entities and relationships between entities data .

Because of its roots in the business world, Microsoft has also increased the knowledge of the entities associated with the activity around areas such as documents and meetings to help with users bots queries like "remind me to send my They document boss I was working last night. "

However, the company also has accumulated more / general knowledge entity consumers through searches using Bing and Cortana in areas such as sports, politics, entertainment and more.

I asked Microsoft for more information on Bot and Bing Concierge update this post if and when I hear back. I am particularly interested in whether the Bing Bot Concierge will be something that the powers of other robots under Microsoft Bot propulsion, or if it will be something that users interact directly.

Read More

Microsoft 70-461 Exam Questions

Question: 14

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. The new column is expected to be queried heavily, and you need to be able to index the column. Which Transact-SQL statement should you use?

A. ALTER TABLE Inventory
ADD TotalItems AS ItemslnStore + ItemsInWarehouse

B. ALTER TABLE Inventory
ADD TotalItems AS ItemsInStore + ItemsInWarehouse PERSISTED

C. ALTER TABLE Inventory
ADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse) PERSISTED

D. ALTER TABLE Inventory
ADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse)


Answer: B

Read More

Microsoft 70-461 Exam Questions

QUESTION 13

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

Read More

Microsoft 70-461 Exam Questions

QUESTION 11

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

Read More

Microsoft 70-461 Exam Questions

QUESTION 10

You develop a database for a travel application. You need to design tables and other database objects.
You create the Airline_Schedules table.
You need to store the departure and arrival dates and times of flights along with time zone information.
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.

Correct Answer: I

Read More

Microsoft 70-461 Exam Questions

QUESTION NO: 9

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


Correct Answer: B

Read More

Microsoft 70-461 Exam Questions

QUESTION NO: 8

Your database contains a table named Purchases. The table includes a DATETIME column named
PurchaseTime that stores the date and time each purchase is made. There is a non- clustered index on the
PurchaseTime column.
The business team wants a report that displays the total number of purchases made on the current day.
You need to write a query that will return the correct results in the most efficient manner.
Which Transact-SQL query should you use?

A. SELECT COUNT(*)
FROM Purchases
WHERE PurchaseTime = CONVERT(DATE, GETDATE())
B. SELECT COUNT(*)
FROM Purchases
WHERE PurchaseTime = GETDATE()
C. SELECT COUNT(*)
FROM Purchases
WHERE CONVERT(VARCHAR, PurchaseTime, 112) = CONVERT(VARCHAR, GETDATE(), 112)
D. SELECT COUNT(*)
FROM Purchases
WHERE PurchaseTime >= CONVERT(DATE, GETDATE())
AND PurchaseTime < DATEADD(DAY, 1, CONVERT(DATE, GETDATE()))

Answer: D

Section: (none)
Explanation

Explanation/Reference:
Explanation:
Two answers will return the correct results (the "WHERE CONVERT..." and "WHERE ... AND ... "answers).
The correct answer for Microsoft would be the answer that is most "efficient". Anybody have a clue as to
which is most efficient? In the execution plan, the one that I've selected as the correct answer is the query
with the shortest duration. Also, the query answer with "WHERE CONVERT..." threw warnings in the
execution plan...something about affecting CardinalityEstimate and SeekPlan.
I also found this article, which leads me to believe that I have the correct answer:
http://technet.microsoft.com/en-us/library/ms181034.aspx

Read More

Microsoft begins To Publicly Launch Of Window 10 Share Points

Microsoft today launched a website dedicated to keeping track of Windows 10 Release Notes. For more features, improvements and changes the company has grown, now you can only visit the historic upgrade Windows 10.

"After listening to comments on the level of disclosure for Windows 10 updates, we decided to implement a new communication system, which updates the operating system," a Microsoft spokesperson told VentureBeat. "We now present the historical update Windows 10, a center for the release notes that accompany each update and serve as a historical record of notes from the previous version."

The "feedback" that Microsoft refers to fund amounts to complaints from users of Windows 10 who wanted to know more about what the company pushed to their devices. In the future, each updating of the list is a summary of significant developments with links to product details.

Because Windows 10 updates are cumulative, you may need to scroll down a bit to find exactly when something has changed. For now, Microsoft lists only two changes (also released today as part of the monthly Patch Tuesday cycle of Microsoft), as there are two windows 10 branches:

The first part of July launch (build 10240) and updated in November (build 10586) branch. We have introduced new features of the operating system in November after seeing, or "flighted", insiders with windows between July and November. Most customers have moved automatically from July to November Rama Rama. Windows 10 Professional, Enterprise and Education customers publishers may postpone updating the branch in November and stay in the SET's role in July - up to 10 years for some corporate customers.

Windows 10 is a service. As we wrote in our deep dive into how Microsoft is still working on Windows 10, Windows are started then new construction, even if the operating system launched in July 2015.

Read More

How To Pass 70-461 Querying Microsoft SQL Server 2012

MCSA Querying Microsoft SQL Server 2012 Exam 70 461: Introduction

70-461 Question Answer:

You work as a database developer at ABC.com. ABC.com has a SQL Server 2012 database named SalesDB that has a table named WeeklySales. The WeeklySales table records the sales amount for each of ABC.coms 20 sales representitives. You need to write a Transact-SQL query that ranks the sales representatives by the average sales amount for the past year. You want the sales representatives with the same average sales amount to have the same rank with the subsequent rank being skipped. Which ranking function should you use?

A. The RANK( ) OVER function.
B. The NTILE( ) OVER function
C. The DENSE_RANK( ) OVER function
D. The ROW_NUMBER( ) OVER function
E. The FORMAT function.

Answer: C

Read More

Microsoft Bought The British Compan Swiftkey AI

Artificial intelligence firm UK SwiftKey was acquired by Microsoft, the company confirmed.

The Financial Times reports that the deal is valued at $ 250 million (£ 174 million).

SwiftKey is known for its predictive keyboard, which is installed on millions of smartphones.

The company said it was a "step" in its history.

"Our mission is to strengthen the interaction between people and technology. We believe this is a perfect match, and we believe part of Microsoft is just next leg of our journey," said the founder of SwiftKey Jon Reynolds and Ben Medlock in a blog.

The company is the latest farm UK artificial intelligence (AI) to be bought by a giant US technology.

Deepmind - which started at the University of Oxford - was bought by Google in 2014 for £ 400. Another firm, VocalIQ, was recently acquired by Apple.

And the popular smartphone app, SwiftKey is known for being the source of computer programs in the wheelchair Professor Stephen Hawking.

The agreement promotes the new Microsoft mobile strategy, led by CEO Satya Nadella.

Instead of focusing on the computer - where the company has a small market share with its range of Windows Phone - the company is seeking to develop a range of productivity software for use on any device.

Read More

Microsoft 70-461 Exam Questions

QUESTION NO: 7

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

Read More

Microsoft Buys Company That Helps Crunch Messy Data

Acquisition may beef up Microsoft’s big data analytics push.

Microsoft acquires Meta Nautix, a startup founded by engineers from Google and Facebook to help more people crack big data.

The terms were not disclosed, but based in Palo Alto California Metanautix had raised about $ 7 million in venture funding from Sequoia Capital and others since its founding in 2012.

A founder Theo Vassilakis, who led the development of Dremel, a system open for consultation of scattered data between different systems code. Dremel has become the core (GOOG ^ 2.02%) BigQuery highly regarded data analysis service of Google. Its co-founder is Apostolos Lerios, former Facebook (FB 3.07%) senior engineer who worked in the photo service of this company, which is home to billions of our own photos and other images.

Metanautix applies the SQL standard (the initials stand structure query language) is used to quiz data from traditional relational data bases to the wild and woolly that do not fit this mold line and  Microsoft exam dumps columns. SQL is the standard language used to ask questions relational databases such as Oracle (ORCL ^ 2.08%) and Microsoft SQL Server.

Being able to apply this same tool to messy non-relational data, in theory it means that companies can learn a lot from various data sources at once. And tens of thousands of SQL and experts can apply their existing skills to new data types.

Therefore, a business analyst for a product manufacturer may wonder how a product sold in the second quarter, but also analyze the messages on Twitter or Facebook to see how customers liked them and they liked what they bought. A set of information is one thing at a traditional database, another set of data is the disruption of social networks.

In a blog post announcing the deal, Joseph Sirosh, Microsoft (MSFT ^ 2.85%) vice president of corporate data do not provide much in the way of detailed plans for Metanautix other than to say that Microsoft technology in the global data platform Microsoft. These include the SQL Server data and Cortana above the products of data analysis.

It was hard to know if the product of years Metanautix the Quest data engine, which cost HP, Shutterfly, and the University of Chicago and customers even be offered separately or whether its technology will be integrated into the Microsoft offering. I guess the latter.

Read More

Microsoft 70-461 Sample Questions

QUESTION NO: 6

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 Inventory ADD TotalItems AS ItemsInStore + ItemsInWarehouse
B. ALTER TABLE Inventory ADD ItemsInStore - ItemsInWarehouse = TotalItemss
C. ALTER TABLE Inventory ADD TotalItems = ItemsInStore + ItemsInWarehouse
D. ALTER TABLE Inventory ADD TotalItems AS SUM(ItemsInStore, ItemslnWarehouse);

Answer: A

Read More