READ Free Dumps For Microsoft- 70-462
| Question ID 18889 | You administer a Microsoft SQL Server 2012 instance.
You need to configure a new database to support FILETABLES.
What should you do? Choose all that apply.
|
| Option A | Disable FILESTREAM on the Database.
|
| Option B | Enable FILESTREAM on the Server Instance.
|
| Option C | Configure the Database for Partial Containment.
|
| Option D | Create a non-empty FILESTREAM file group.
|
| Option E | Enable Contained Databases on the Server Instance.
|
| Option F | Set the FILESTREAM directory name on the Database.
|
| Correct Answer | B,D,F |
Explanation Explanation: http://msdn.microsoft.com/en-us/library/gg509097.aspx
| Question ID 18890 | 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).
|
| Option A | Answer :
|
| Correct Answer | A |
Explanation