You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit.Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record in theEmployee table. You need to assign the appropriate constraints and table properties to ensure data integrity and visibility. On which column in the Employee table should you create a unique constraint?
You administer a Microsoft SQL Server 2012 database. The database contains a table named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.)Confidential information about the employees is stored in a separate table named EmployeeData. One record exists within EmployeeData for each record in theEmployee table. You need to assign the appropriate constraints and table properties to ensure data integrity and visibility. On which column in the Employee table should you use an identity specification to include a seed of 1,000 and an increment of 1?
You are a database developer of a Microsoft SQL Server 2012 database. You are designing a table that will store Customer data from different sources. The table will include a column that contains the CustomerID from the source system and a column that contains the SourceID. A sample of this data is as shown in the following table. You need to ensure that the table has no duplicate CustomerID within a SourceID. You also need to ensure that the data in the table is in the order of SourceID and then CustomerID.Which Transact- SQL statement should you use?
HOTSPOT -You are designing a SQL Server Integration Services (SSIS) package configuration strategy.The package configuration must meet the following requirements:✑ Include multiple properties in a configuration.✑ Support several packages with different configuration settings.You need to select the appropriate configuration. Which configuration type should you use?To answer, select the appropriate option from the drop-down list in the dialog box.Hot Area:
You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.You have the following requirements:✑ Ensure that the deployment model supports changing the content of connection strings by using parameters at execution time.✑ Ensure that the deployment model automatically starts from calls to the catalog.start_execution stored procedure in the SSISDB database.✑ Maximize performance at execution time.✑ Minimize development effort.You need to design a solution that meets the requirements.What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence DevelopmentStudio (BIDS).The package includes custom scripts that must be upgraded.You need to upgrade the package to SQL Server 2012.Which tool should you use?
