Q. Replication in SQL Server is used to overcome ________________

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following stored procedure provide replication support for AlwaysOn?

View solution

Q. How many types of replication components are present in SQL Server?

View solution

Q. Which of the following makes data available for replication?

View solution

Q. Two types of subscriptions present for replication is _____________

View solution

Q. SSMS provides different options to develop your SSIS package starting with ___________ wizard.

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following is the best practice related to SSIS?

View solution

Q. If SSIS is not able to drive close to 100% CPU load, this may be indicative of ____________

View solution

Q. Point out the wrong statement.

View solution

Q. The key counters for Integration Services and SQL Server are _______________

View solution

Q. _________ represents to total memory pressure on the system in SSIS.

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. Point out the correct statement.

View solution

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

View solution

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

View solution