Q. Which of the following option is used to find database objects by using filter criteria?

View solution

Q. Which is the most serious issue after migration of access database to SQL Server?

View solution

Q. Point out the wrong statement.

View solution

Q. __________ is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005.

View solution

Q. When you _______ an Access table from a SQL Server, SSMA restores the original Access table and its data.

View solution

Q. Point out the correct statement.

View solution

Q. The __________ is an Access add-in program that provides data analysis tools for financial analysis.

View solution

Q. Which of the following evaluation operation is provided in SSIS?

View solution

Q. A basic package in SSIS includes the following elements?

View solution

Q. Purpose of SQLISPackage_12546 event in SQLIS package is to _____________

View solution

Q. Which of the following is the event logged by the Integration Services?

View solution

Q. Which of the following error message indicates that the package cannot run in SSIS?

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following steps should be carried out using data types in SSIS for efficient results?

View solution

Q. When you execute SQL statements within Integration Services, the following optimization can be made?

View solution

Q. Point out the correct statement.

View solution

Q. Which of the following will increase the Rows/sec calculation in SSIS?

View solution

Q. ___________ represents how many network transfers per second are occurring.

View solution

Q. What do you understand by design limitation in SSIS package?

View solution

Q. The following Network perfom counters can help you tune your topology?

View solution