Exam 70-464 topic 8 question 9 discussion

Actual exam question from Microsoft's 70-464

Question #: 9
Topic #: 8

DRAG DROP -
You need to redesign the system to meet the scalability requirements of the application.
Develop the solution by selecting and arranging the required code blocks in the correct order.
You may not need all of the code blocks.
Select and Place:

Show Suggested Answer

Suggested Answer:

Note:
* MEMORY_OPTIMIZED_DATA
First create a memory-optimized data filegroup and add a container to the filegroup.
Then create a memory-optimized table.
* You must specify a value for the BUCKET_COUNT parameter when you create the memory- optimized table. In most cases the bucket count should be between
1 and 2 times the number of distinct values in the index key.
* Example:
-- create a durable (data will be persisted) memory-optimized table -- two of the columns are indexed
CREATE TABLE dbo.ShoppingCart (
ShoppingCartId INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED, UserId INT NOT NULL INDEX ix_UserId NONCLUSTERED HASH WITH
(BUCKET_COUNT=1000000),
CreatedDate DATETIME2 NOT NULL,

TotalPrice MONEY -
) WITH (MEMORY_OPTIMIZED=ON)
GO

by Zikato at Dec. 14, 2020, 3:54 p.m.

Comments

Submit Cancel

Zikato

3 years, 9 months ago

The primary key block is swapped with the index block, the commas don't match this way.

upvoted 1 times

...

Most Voted

Save Cancel

Loading ...

Exam 70-464 topic 8 question 9 discussion

Comments

Zikato

Get IT Certification

New Version GCP Professional Cloud Architect Certificate & Helpful Information

The 5 Most In-Demand Project Management Certifications of 2019