You need to ensure that the following requirements are met: • Indexes are not modified when the subscriptions are reinitialized

HOTSPOT
You administer two Microsoft SQL Server 2012 databases named Contoso and
ContosoWarehouse.
You plan to replicate tables from the Contoso database to the ContosoWarehouse database.
Indexes will be added to the tables in ContosoWarehouse to improve the performance of
reports.
You need to ensure that the following requirements are met:
• Indexes are not modified when the subscriptions are reinitialized.
• Only the clustered index from Contoso will be replicated.
• Minimal transaction log activity during the reinitialization.
What should you do? Choose the correct option(s).

HOTSPOT
You administer two Microsoft SQL Server 2012 databases named Contoso and
ContosoWarehouse.
You plan to replicate tables from the Contoso database to the ContosoWarehouse database.
Indexes will be added to the tables in ContosoWarehouse to improve the performance of
reports.
You need to ensure that the following requirements are met:
• Indexes are not modified when the subscriptions are reinitialized.
• Only the clustered index from Contoso will be replicated.
• Minimal transaction log activity during the reinitialization.
What should you do? Choose the correct option(s).

Answer:



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Jane

Jane

for the last one, I think the answer should be “TRUNCATE all data in the existing object”, since the question asking for minimal transaction log..

anyone agree?

Dim

Dim

I also think that truncate is correct.

Faisal

Faisal

I agree too. That was my first reaction even before seeing any response.

R

R

Should Copy Clustered Indexes should be set to true? since on the question:
Only the clustered index from Contoso will be replicated.

R

R

Ooops Im wrong sorry.

kmr

kmr

damn .. not sure if the response given in the answer is to be specified in the actual test or go with what we know is right.

grako

grako

Since:
– “Indexes will be added to the tables in ContosoWarehouse” -> we cannot drop the table
– we must ensure “Minimal transaction log activity during the reinitialization” -> we cannot delete all data from existing tables

So we are only left with Truncate option