which one should be used?
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 you
get an order from your company CIO, you’re asked to develop a SQL Server 2008
Integration Services (SSIS) data flow. The data flow loads data to a SQL Server 2008
database. Using data from the rows in your data flow, you must make sure that the existing
records in the SQL Server database is updated by the data flow. Of the following data flow
components, which one should be used?
what should you do?
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 you get an order from your company CIO, you are asked to design a SQL Server 2008
Integration Services (SSIS) package.
The package contains a Data Flow task. According to the requirement of the company CIO,
the package has to be modified to write all rows by which errors are generated to a text file.
So what should you do? (choose more than one)
Which code segment should you use?
CORRECT TEXT
You have a database that contains the tables shown in the exhibit. (Click the Exhibit button).
You need to create a query for a report. The query must meet the following requirements:
NOT use object delimiters.
Return the most recent orders first.
Use the first initial of the table as an alias.
Return the most recent order date for each customer.
Retrieve the last name of the person who placed the order.
Return the order date in a column named MostRecentOrderDate that appears as the last column in
the report.
The solution must support the ANSI SQL-99 standard.
Which code segment should you use?
To answer, type the correct code in the answer area.
which XML for Analysis (XMLA) command should you choose?
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 you
are in charge of a SQL Server 2008 Analysis Services (SSAS) database. Now you get an email from your company CIO, according to his requirement, he wants the data in a partition
to be refreshed every two hours. He has assigned this task to you. You have to implement
the incremental processing strategy. Of the following options, which XML for Analysis
(XMLA) command should you choose?
You need to achieve this goal by ensuring minimum impact of performance on the server
You are designing the storage scheme for a new SQL Server 2008 database application.
The application will primarily be used to query data. The database will be initially populated
with 4 terabytes of data stored in 20 tables. The data is distributed evenly throughout all 20
tables. Every night, between 100 GB and 300 GB of new data will be loaded into 4 database
tables. The remaining 16 tables will remain static. The average CPU utilization of the server
where the application will reside is between 30 and 50 percent. You need to ensure that the
amount of disk space used is reduced. You need to achieve this goal by ensuring minimum
impact of performance on the server. What should you do? (More than one answer choice
may achieve the goal. Select the BEST answer.)
What action should you do?
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.
According to the requirement of the company, you’re deploying a SQL Server 2008
Integration Services (SSIS) package.
The XML configuration is not specified when deploying the package. You have to apply the
configuration to the deployed package. What action should you do?
What should you include in the query?
You plan to implement a Web-based application that will save XML data to a column in a
table. You need to design a query that ensures that before saving the XML data to the table,
the data contains valid elements. The solution must be developed by using the minimum
amount of effort. What should you include in the query?
which one should you use?
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.
According to the requirement of the company, you’re desinging a SQL Server 2008
Integration Services (SSIS) package.
The package contains a Data Flow task which copies several million rows. There is a
reference table that contains 10,000 rows.
The data flow needs a match against the reference table. During the data flow, each row in
the reference table will be used.
You must make sure that the data flow takes as little time to execute as possible. Of the
following data flow components, which one should you use?
what action should you perform?
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.
According to the requirement of the company, you are developing a SQL Server 2008
Integration Services (SSIS) data flow. The data flow extracts data from two sources. Each
source database is located on a different server. Each source is based on a SELECT
statement that uses an ORDER BY clause. Each source is based on a SELECT statement.
An ORDER BY clause is used by the statement. The following diagram presents the data
flow. The following error message pops up when the paths from the two sources are
connected to a Merge Join component. “Data Flow Task: The input is not sorted.
The ‘input “Merge Join Left Input” (80)’ must be sorted.”
You must make sure that data from each query is included in each row in the data flow. You
must achieve this goal by using as little execution time as possible.
So what action should you perform?
Which two actions should you perform before the upgrade?
You administer a SQL Server 2008 infrastructure. You plan to upgrade a Microsoft SQL
Server 2005 instance to SQL Server 2008 by using an in-place upgrade. All user databases
use the simple recovery model and have the PAGE_VERIFY option turned off. You need to
ensure that the database engine can identify I/O path errors and memory corruptions for the
data in tables. Which two actions should you perform before the upgrade? (Each correct
answer presents part of the solution. Choose two.)