what should you do to reduce the effect on the disk space to the least?
You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named DBx1. There’s a table calledd TPV in DBx1 database.
This table is used to store information on all kinds of TPV cars. Users query the TPV table based on the BikeSize column frequently. Besides the NULL value for bikes, the BikeSize column also has the NULL value for all products. At present no index is related to the BikeSize column. Now you have to improve the query performance, meanwhile you must reduce the effect on the disk space to the least. So what should you do to ahieve this?
what should you do to make sure that the process can be repeated in the middle of each month
You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named DGTASK. There’re two tables in the DGTASK database, the table below displays this:The OrderHistory table includes two table partitions; one partition is empty while the other one contains all data. The Orders table includes a table partition for each month.Now you intend to create a process to perform a migration. You want to move data from the partition which contains data for the oldest month of the Orders table to the right partition of the OrderHistory table. So what should you do to make sure that the process can be repeated in the middle of each month.
what should you do first in order to create a spatial index on the TPXC column?
You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named DGTASK. There’s a table called TPV in DBx1 database. You add a column called TPXC to the TPV table. The TPXC column is of the Geography data type. There is no index in the TPV table. So what should you do first in order to create a spatial index on the TPXC column?
what should you do to achieve that a job named Job1 doesn’t run Wednesdays any longer?
You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains various SQL Server Agent jobs. The jobs use seven shared schedules to run each job every day. You have to make sure that a job named Job1 doesn’t run Wednesdays any longer. So what should you do to achieve this?
Which data source should you use?
You have a SharePoint Server 2010 Service Pack 1 (SP1) deployment.
You need to write a report that uses Microsoft SQL Server Reporting Services to monitor feature usage. The solution must minimize the amount of development effort.
Which data source should you use?
You need to ensure that all requests to the Business Data Connectivity Service service application are load ba
You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm. The farm contains three servers named WFE1, WFE2, and APP1.
User requests are load balanced by using a hardware load balancer.
The farm contains a Business Data Connectivity Service service application. The service application is configured to run on APP1.
You plan to add a new server named APP2 to the farm.
You need to ensure that all requests to the Business Data Connectivity Service service application are load balanced between APP1 and APP2.
What should you do?
Which editions should you recommend?
You are planning a SharePoint Server 2010 Service Pack 1 (SP1) server farm.
You need to recommend which editions of Microsoft SQL Server 2008 R2 must be deployed to support online index rebuilding.
Which editions should you recommend?
(Each correct answer presents a complete solution.Choose all that apply.)
What should you include in the recommendation?
You have a SharePoint Server 2010 Service Pack 1 (SP1) server farm. The farm contains a site collection named Collection1. You need to recommend a strategy to remove the draft versions from documents that were not modified for six months.
What should you include in the recommendation?
What should you include in the recommendation?
You are planning the search infrastructure for your company.
You need to recommend a search solution to meet the following requirements:
– Users must be able to preview the documents returned in search results.
– Users must be able to refine search results by using custom properties.
– Users must be able to search the content of PDF files.
– The solution must be able to index 1 million documents.
– The solution must minimize upfront software costs.
What should you include in the recommendation?
You need to ensure that all of the Enterprise features can be enabled in Collection1
You host a SharePoint Server 2010 Service Pack 1 (SP1) server farm for multiple tenants. The Enterprise license is activated for the farm.
You plan to deploy a web application that will contain two site collections named Collection1 and Collection2.
You need to ensure that all of the Enterprise features can be enabled in Collection1. The solution must ensure that only the features of Microsoft SharePoint Foundation can be enabled in Collection2.
What should you do?