Exam MB-500 topic 15 question 2 discussion

Actual exam question from Microsoft's MB-500

Question #: 2
Topic #: 15

HOTSPOT -
The system includes the following code: (Line numbers are included for reference only.)

You need to apply changes to address User2's issues.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

by sadoki9311 at Sept. 4, 2020, 1:56 p.m.

Comments

Submit Cancel

yankyraman

Highly Voted 3 years, 9 months ago

Yes: Select firstonly increase performance and with field list it is added performance boost. No: No need for Cluster index setting here Yes: Configure Primary index on table is must Yes: RecId in select list will help avoiding load on DB to fetch full list of fields

upvoted 20 times

juversg

8 months ago

I would say Clustered index is useful here. Check this reference: https://learn.microsoft.com/en-us/dynamicsax-2012/developer/clustered-indexes Organizing your tables with a clustered index usually has performance advantages. The general rules are as follows: - If only one index is created on the table, make it clustered. - Create a clustering index on the key on all group and main tables.

upvoted 1 times

...

Nkraa

2 years, 5 months ago

i assume the primary Index is already configured as stated in the requirements : "Create an index for the table named PrimaryIdx that uses the following fields: CustAccount, ItemId, VendAccount." why would i configure it again?

upvoted 2 times

...

MsPandiPanda

Most Recent 3 weeks, 4 days ago

Yes, Yes, No(Yes), Yes Yes : The firstOnly keywords speed up the fetch by returning a limited number of rows. Yes : A clustered index defines the physical storage order of data, optimizing retrieval based on frequent query patterns. Adapting the clustered index to the created index would improve performance. No (Yes): A primary index identifies each row uniquely, ensuring data integrity. For SELECT statement performance, it is not the main index to look at. Note : I would still have set the PrimaryIndex to the newly created index if it is not done yet. Yes : Select RecId from vendExclusion where ... Selecting only one field (RecId) instead of retrieving all the fields is a good practice. This will help SQL uses specific indexes (INDEX SEEK) instead of doing TABLE SCAN, or other slower operations.

upvoted 1 times

...

globeearth

1 month, 1 week ago

Yes: Select firstonly increase performance and with field list it is added performance boost. No: No need for Cluster index setting here Yes: Configure Primary index on table is must No: RecId selected by default. we dont have to specify explicitly

upvoted 1 times

...

Prollyx

2 years, 3 months ago

Yes: always use firstonly keyword when you want to fetch just single record No: records are physically ordered by clustered index in the database → nothing about the performance No/Yes: index on these fields is already created in requirement, but if It wasn't it would definitely help with the performance to create it Yes: term is usually "field list" not "column list". Fetching only required fields surely helps with the performance here and only RecId is actually required here.

upvoted 3 times

...

faycal

2 years, 5 months ago

For me it will be Yes,Yes,No,Yes

upvoted 2 times

...

Pir

3 years, 5 months ago

Yes, No, Yes, Yes. Clustered index are necessarily unique combination which is required in this case for exclusion list, Customer, Item and Vendor. First only and selecting fields used are best practices to increase performance by decreasing packet size during round trip.

upvoted 2 times

...