Which two actions should you perform?
You administer a SQL Server 2008 infrastructure. You partition the largest table in a
database into four equal-sized parts. The first two partitions are rarely queried. The third
partition is frequently queried by several reports. The last partition is heavily queried and
frequently modified. You need to minimize the disk space of the table and ensure that this
has minimum effect on the query performance. Which two actions should you perform?
(Each correct answer presents part of the solution. Choose two.)
Which is the correct answer?
You are developing a SQL Server 2008 Analysis Services (SSAS) method for
Company.com.
There is a dimension called TestProduct which includes the listed properties.
* Product
* City
* Country
The TestProduct dimension is connect with a measure group named Products which owns
the Granularity attribute link to City. It is a key for Product. You should make sure that you
could search values according to the City and Country properties.
Which is the correct answer?
which is the correct answer?
You are creating a Microsoft SQL Server 2005 Analysis Services (SSAS) project for
Company.com.
In order to move database from Analysis Services 2000 to Analysis Services 2008, which is
the correct answer?
Which is the correct answer?
You are developing a SQL Server 2008 Analysis Services (SSAS) method for
Company.com.
There is a table called Product which includes listed columns below:
* ProductKey
* Logger
* ProductNumber
Firstly you develop a dimension called DimProductOrders from the Product table, and then
configure the ProductKey as a key column and the Logger column as a property.
At last you create a measure group called FactProductOrders from the Product table.
You should make sure that you could develop a dimension relationship .
Then you could make ProductNumber column gathered by the Logger column.
Which is the correct answer?
You need to ensure that if a supplier is deleted, the SupplierID value in the Product table is set to 0
You are a database developer. You plan to design a database solution by using SQL Server
2008. The database contains two tables named Supplier and Product. There is a foreign
key constraint between the Supplier and Product tables on the SupplierID column. The
Supplier table contains a row that has the SupplierID value as 0. The 0 value indicates that
the supplier is deleted. Certain transactions delete the supplier records from the Supplier
table. You need to ensure that if a supplier is deleted, the SupplierID value in the Product
table is set to 0. What should you do?
You need to select a technology that meets the requirements by using the minimum amount of development effort
You administer a SQL Server 2008 infrastructure. You plan to design a solution to obtain
hardware configurations, such as the number of processors on a computer and the
processor type of all SQL Server 2008 computers. The solution must meet the following
requirements: It is hosted on the central computer. It can verify hardware configurations
for multiple servers. You need to select a technology that meets the requirements by using
the minimum amount of development effort. What should you do?
Which is the correct answer?
You are creating a SQL Server 2008 Analysis Services (SSAS) database which contains
some measure groups for Company.com.
One of measure groups Product Data allows refresh Than others’ frequently.
You should make sure that Product Data measure group would operate on a schedule
managed through SSAS.
Which is the correct answer?
You need to create a deployment manifest for all packages in the project
You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You
work as the technical support.
Now in Business Intelligence Development Studio, you are developing a SQL Server 2008
Integration Services (SSIS) project.
You configure the project properties as shown in the following image.
You need to create a deployment manifest for all packages in the project.
What should you do?
what should you do to achieve this goal?
You are a database developer and you have about two years experience in reating business
Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008.
You work as the technical support. Now you are in charge of an instance of a SQL Server
2008 server.
You use the server to execute SQL Server 2008 Integration Services (SSIS) packages.
Now you get an e-mail from your company CIO, according to the requirement of the CIO, the
server must only execute only correctly signed packages.
The company CIO assigns this task to you. So what should you do to achieve this goal?
You need to improve the performance of the query
You use a Microsoft SQL Server 2012 database that contains two tables named SalesOrderHeader
and SalesOrderDetail. The indexes on the tables are as shown in the exhibit. (Click the Exhibit
button.)
You write the following Transact-SQL query:
You discover that the performance of the query is slow. Analysis of the query plan shows table scans
where the estimated rows do not match the actual rows for SalesOrderHeader by using an
unexpected index on SalesOrderDetail.
You need to improve the performance of the query.
What should you do?