Microsoft Acquires Cycle Computing

Microsoft today declared that it has procured Cycle Computing, a twelve-year-old Connecticut-construct organization that concentrations with respect to helping undertakings coordinate elite processing occupations, expansive information workloads and other "huge figuring" employments in the cloud. The money related subtle elements of the arrangement were not unveiled.

While Microsoft intends to utilize the organization's mastery to enhance its Azure administration for these sort of top of the line workloads, Cycle Computing's lead CycleCloud benefit constantly bolstered an extensive variety of cloud and on-premises stages, including AWS and the Google Cloud Platform. Microsoft takes note of that the Cycle Computing tech will enable it to enhance its help for Linux-based superior processing workloads.

Current Cycle Computing clients incorporate any semblance of Novartis, Pacific Life, MetLife and other significant assembling, protection, biotech and media organizations. Cycle Computing, which was bootstrapped and never raised a "genuine" financing round, says that its administration will oversee around a billion center hours of figure this year and that it has grown 2.7x at regular intervals.

"We've just observed hazardous development on Azure in the ranges of computerized reasoning, the Internet of Things and profound learning," Jason Zander, Microsoft's corporate VP of Azure, writes in the present declaration. "As clients keep on looking for speedier, more proficient approaches to run their workloads, Cycle Computing's profundity and aptitude around hugely adaptable applications make them an awesome fit to join our Microsoft group."

Cycle Computing fellow benefactor and CEO Jason Stowe composes that his organization will keep on supporting its current clients, however it's vague if this implies Microsoft will likewise keep on developing help for contending stages. We have connected with Microsoft for illumination and will refresh this post once we hear more.

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

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