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:

Explanation:

Show Hint

Leave a Reply 5

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

Shak

Shak

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

Reply

Donk

Donk

Agree with Shak

Reply

God

God

False, all options + Delete data…

Reply

kmr

kmr

did you take the exam recently?

Reply