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...

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....

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 :...

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...

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 assistantCalled "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...

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....

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:...

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...

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...

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....

Read More

Microsoft 70-461 Exam Questions

QUESTION NO: 8Your database contains a table named Purchases. The table includes a DATETIME column namedPurchaseTime that stores the date and time each purchase is made. There is a non- clustered index on thePurchaseTime 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 PurchasesWHERE PurchaseTime = CONVERT(DATE, GETDATE())B. SELECT COUNT(*)FROM...

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...

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...

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...

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....

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...

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...

Read More