What should you do?
You have a table named Table1. A sample of the data in Table1 is shown in the following table.
There is a defined nonclustered index on the SalesOrderNumber column.The following query executes against the table:
WHERE ‘SO3’ = LEFT(SalesOrderNumber,3)
You need to minimize the amount page I/O that is generated when the query runs. What should you do?
Which is the correct answer?
You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com.
The cube structure is listed below:
For one TestAccount member, the total value in the Ownership column is 100%.
The Ownership column includes decimal values which stand for percentage of ownership.
The measures listed below are developed:Ownershiper Number
You should make sure that the weighted value is computed according to the Ownership measure when you are computing against the TestCustomer dimension.
Which is the correct answer? (Exhibit)
So 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? (Exhibit)
which uses SQL Server2008. You work as the technical support. Now you are in charge of a SQL Server 2008 Analy
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) instance.
Now you get an e-mail from your company CIO, in the e-mail he wants you to run the Usage-Based Optimization Wizard.
You have to enable query logging. What action should you perform? (Exhibit)
You have a table with a string column
You have a table with a string column. A lot of data is duplicated. Need to optimize a stored procedure for performance with the following criteria
+ stored procedure takes a string parameter as input
+ stored procedure must be optimized for all input params
+ only one SELECT statement uses the string input parameter
What column type sholud you use ?
You want to store amount of money with decimal precision 5 digits (like 10.35762). What column type sholud you use ?
What should you do?
Your company has a single-domain Active Directory Domain Services (AD DS) forest. You are upgrading all client computers from Office 2003 to Office 2010. You are using Office Customization Tool (OCT) to prepare the Office 2010 deployment settings. While testing the deployment, you discover that users cannot open or edit specific Excel and Word documents that are located in multiple directories. Users receive the following error message: "Office has detected a problem with this file. To help protect your computer this file cannot be opened". You verify that users have the appropriate share and file permissions to edit the files. You need to ensure that users can edit the specific Word and Excel files and that all other Office files are validated before being opened.
What should you do?
What should you do?
Your company has a single-domain Active Directory Domain Services (AD DS) forest. All client computers run Windows Vista. You are migrating all client computers to Windows 7 by using User State Migration Tool (USMT) 4.0. You perform several test migrations. You discover that a set of files with the extension .
wxv, which should be restricted by NTFS permissions, were accessible to all users after the test migrations were completed.
You need to ensure that the .wxv files are migrated with all NTFS permissions intact.
What should you do?
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?
You must make sure that you can write the required information to the text file. So what action should you per
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 an OnError event handler, a data flow task contained in a For Loop container, and a Flat File destination component which uses a Flat File connection manager.
When the package meets an error, from an expression that includes the version of the package, you intend to write diagnostic information to a text file.
You must make sure that you can write the required information to the text file. So what action should you perform?