70-463 Practice Questions
184 real 70-463 exam questions with expert-verified answers and explanations. Page 3 of 4.
- Question #137
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.) C...
- Question #138
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.) C...
- Question #139
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 th...
- Question #140
A SQL Server Integration Services (SSIS) package imports daily transactions from several files into a SQL Server table named Transaction. Each file corresponds to a different store...
- Question #141
You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job....
- Question #142
Your team is creating SQL Server Integration Services (SSIS) packages that have several dependencies. The packages use parameters for configuration purposes. Your company's IT poli...
- Question #143
You are developing a SQL Server Integration Services (SSIS) package. The package sources data from an HTML web page that lists product stock levels. You need to implement a data fl...
- Question #144
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model. The project is deployed to a single SSIS catalog, and transfers data to a...
- Question #145
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system. Depending on the va...
- Question #146
You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages. All packages in the project must connect to th...
- Question #147
You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services (DQS). You need to complete the post-installation configuration. What s...
- Question #148
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model, The project will be deployed to an SSIS catalog folder where Environments...
- Question #149
You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse. The package consists of several data flow tasks. The package experiences int...
- Question #150
You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2012. The con...
- Question #151
You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A package in the project extracts data from a Windows Azure SQL Database databas...
- Question #152
You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection Manager and multiple packages. All packages in the project must connect to th...
- Question #153
You are developing a SQL Server Integration Services (SSIS) package. The package sources data from an HTML web page that lists product stock levels. You need to implement a data fl...
- Question #154
You are deploying a new SQL Server Integration Services (SSIS) package to five servers. The package must meet the following requirements: - .NET Common Language Runtime (CLR) integ...
- Question #160
You develop a SQL Server Integration Services (SSIS) package that imports Windows Azure SQL Database data into a data warehouse every night. The Windows Azure SQL Database data con...
- Question #163
You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS). The package inclu...
- Question #164
You are preparing to install SQL Server 2012 Master Data Services (MDS). You need to ensure that the database requirements are met. What should you install?
- Question #165
You are installing the Data Quality Server component of Data Quality Services. You need to provision the hardware and install the software for the server that runs the Data Quality...
- Question #166
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database database. The package has been de...
- Question #169
You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Databa...
- Question #171
You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job....
- Question #173
You are the administrator of a server that hosts Data Quality Server for a large retail company. The server had a hardware failure during business hours. You need to restore the se...
- Question #174
You are designing an extract, transform, and load (ETL) solution that loads data into dimension tables. The ETL process involves many transformation steps. You need to ensure that...
- Question #175
To support the implementation of new reports, Active Directory data will be downloaded to a SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package. The...
- Question #178
You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of the data. You need to use DQS profiling to obtain the required statistics. W...
- Question #179
You are developing a SQL Server Integration Services (SSIS) project to read and write data from a Windows Azure SQL Database database to a server that runs SQL Server 2012. The con...
- Question #180
A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows Azure SQL Database database. To improve sales data accuracy, exchange rates must...
- Question #181
You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a source system into a data warehouse hosted on Windows Azure SQL Database. One...
- Question #182
You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012. Package developers in your company must have permission t...
- Question #183
To support the implementation of new reports, Active Directory data will be downloaded to a SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package. The...
- Question #184
You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a Windows Azure SQL Database database into a SQL Server database. The SSIS package ha...
- Question #185
You are implementing a SQL Server Integration Services (SSIS) 2012 package that loads data from various flat files and a Windows Azure SQL Database database. Daily transactions mus...
- Question #186
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft Excel workbook data into a Windows Azure SQL Database database. The package has been de...
- Question #187
You are preparing to install SQL Server 2012 Master Data Services (MDS). You need to ensure that the database requirements are met. What should you install?
- Question #188
You are installing the Data Quality Server component of Data Quality Services. You need to provision the hardware and install the software for the server that runs the Data Quality...
- Question #189
You are designing a data warehouse that contains a customer dimension. The customer dimension contains the original customer attributes as well as the most recent set of updated at...
- Question #193
You are designing a data warehouse hosted on Windows Azure SQL Database. The data warehouse currently includes the dimUser and dimRegion dimension tables and the factSales fact tab...
- Question #195
You are developing a SQL Server Integration Services (SSIS) package. The package uses a data flow task to source data from a SQL Server database for loading into a dimension table...
- Question #206
You are designing a data warehouse with two fact tables. The first table contains sales per month and the second table contains orders per day. Referential integrity must be enforc...
- Question #207
You are deploying a new SQL Server Integration Services (SSIS) package to several servers. The package must meet the following requirements: - .NET Common Language Runtime (CLR) in...
- Question #208
You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS). The package inclu...
- Question #209
You administer a SQL Server Integration Services (SSIS) solution in the SSIS catalog. A SQL Server Agent job is used to execute a package daily with the basic logging level. Recent...
- Question #210
You are developing a SQL Server Integration Services (SSIS) package to load data into a Windows Azure SQL Database database. The package consists of several data flow tasks. The pa...
- Question #211
You are developing a SQL Server Integration Services (SSIS) project with multiple packages to copy data to a Windows Azure SQL Database database. An automated process must validate...
- Question #212
You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment Model. All packages in the project must log custom messages. You need to produce...
- Question #213
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system that uses the SQL Se...