Microsoft Unveils A Beautiful Cortana-powered Thermostat

Microsoft is banding together with Johnson Controls to assemble an indoor regulator. The product monster divulged the new GLAS indoor regulator in a YouTube video today. It's worked by Johnson Controls, producers of the main electric room indoor regulator. It gives the idea that GLAS will incorporate a translucent touchscreen show that will enable proprietors to change room temperatures, check vitality utilization and air quality, and see schedule data.

GLAS will keep running on Microsoft's Windows 10 IoT Core working framework, and will have Cortana voice administrations incorporated with the indoor regulator. It's one of the main indoor regulators to incorporate Cortana coordination, after Microsoft uncovered its intends to convey its computerized associate to ice chests, toasters, and indoor regulators. Microsoft takes note of that GLAS has sensors that recognize when you're in the room or not, and the indoor regulator will always screen indoor and outside air quality. These sensors are intended to spare vitality by changing settings on the fly, much like a Nest indoor regulator or the Ecobee4. Johnson Controls' GLAS indoor regulator contrasts from the Nest by including Cortana voice controls, yet contenders like the Ecobee4 do incorporate Alexa fabricated straight in.

Microsoft's special video seems to advertise this as an indoor regulator for organizations and business properties, because of the reality it's intended to be controlled by the organization's Azure cloud administrations. It's not clear if GLAS will be accessible to shoppers, or when the indoor regulator will dispatch. We've contacted Microsoft for more data, and we'll refresh you appropriately.

Read More

Microsoft 70-461 Exam Questions

Question No: 23

You develop a database for a travel application. You need to design tables and other database objects. You create a view that displays the dates and times of the airline schedules on a report. You need to display dates and times in several international formats. 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: C

Read More

Microsoft 70-461 Exam Questions

Question No: 22

A table named Profits stores the total profit made each year within a territory. The Profits table has columns named Territory, Year, and Profit. You need to create a report that displays the profits made by each territory for each year and its previous year. Which Transact-SQL query should you use?

A. SELECT Territory, Year, Profit,
LEAD(Profit, 1, 0) OVER (PARTITION BY Territory ORDER BY Year) AS PrevProfit FROM Profits

B. SELECT Territory, Year, Profit,
LAG(Profit, 1, 0) OVER (PARTITION BY Year ORDER BY Territory) AS PrevProfit FROM Profits

C. SELECT Territory, Year, Profit,
LAG(Profit, 1, 0) OVER (PARTITION BY Territory ORDER BY Year) AS PrevProfit FROM Profits

D. SELECT Territory, Year, Profit,
LEAD(Profit, 1, 0) OVER (PARTITION BY Year ORDER BY Territory) AS PrevProfit FROM Profits

Answer: C

Read More

Microsoft 70-461 Exam Questions

Question No: 21

You develop a database for a travel application. You need to design tables and other database objects. You create a view that displays the dates and times of the airline schedules on a report. You need to display dates and times in several international formats. 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: C

Read More

Microsoft 70-461 Exam Questions

Question No: 20

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

Answer: D

Read More

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