70-463 Exam Questions
184 real 70-463 exam questions with expert-verified answers and explanations. Page 3 of 4.
- Question #137Design and implement a data warehouse
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...
unique constraintdata integritytable constraintsemployee schema - Question #138Design and implement a data warehouse
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...
identity specificationseed incrementsurrogate keytable design - Question #139Configure and deploy SSIS solutions
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...
Project Deployment Modelcatalog.start_executionSSISDBpackage execution - Question #140Load data
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...
OLE DB destinationfast load modeRow per Batchpackage performance - Question #141Configure and deploy SSIS solutions
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....
execution performance reportSSIS monitoringProject Deployment ModelSSMS reporting - Question #142Configure and deploy SSIS solutions
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...
.ispac deployment fileSSIS deploymentchange controlProject Deployment Model - Question #143Configure and deploy SSIS solutions
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...
dtutil utilitypackage deploymentSSIS package transfercommand line tools - Question #144Configure and deploy SSIS solutions
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...
SSIS catalog environmentsmulti-server deploymentenvironment variablesProject Deployment Model - Question #145Extract and transform data
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...
Conditional Split transformationrow redirectionincremental loaddata flow - Question #146Configure and deploy SSIS solutions
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...
project Connection Managerproject parametersRequired propertymulti-package configuration - Question #147Build data quality solutions
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...
DQSInstaller.exeDQS post-installationData Quality ServerDQS configuration - Question #148Configure and deploy SSIS solutions
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...
SSIS catalog deploymentProject Deployment Modelenvironment bindingispac deployment - Question #149Configure and deploy SSIS solutions
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...
SSIS logginglog providerOnError eventOLE DB connection - Question #150Configure and deploy SSIS solutions
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...
Azure SQL Databaseproject parametersconnection managerdata flow performance - Question #151Configure and deploy SSIS solutions
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...
DTEXEC utilitydebug dump filespackage troubleshootingDumpOnError - Question #152Configure and deploy SSIS solutions
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...
project connection managerproject parametersRequired propertyProject Deployment Model - Question #153Extract and transform data
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...
data flow sourcescustom source componentHTML data extractionSSIS source types - Question #154Configure and deploy SSIS solutions
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...
SSIS deploymentdtutilpackage deploymentconnection manager configuration - Question #160Extract and transform data
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...
Fuzzy Lookupsimilarity thresholddata matchingreference table - Question #163Configure and deploy SSIS solutions
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...
SSIS package upgradeSQL Server 2012 migrationSSIS Upgrade WizardSSMS - Question #164Build data quality solutions
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?
Master Data ServicesMDS prerequisitesSQL Server 2012 Enterpriseinstallation requirements - Question #165Build data quality solutions
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...
Data Quality ServicesDQS prerequisitesData Quality ServerSQL Server Database Engine - Question #166Extract and transform data
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...
Excel sourceACE driver64-bit compatibilityOLE DB source - Question #169Configure and deploy SSIS solutions
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...
SSIS performance tuningparallel execution treesdata flow optimizationengine threads - Question #171Configure and deploy SSIS solutions
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....
SSIS monitoringexecution performance reportSSISDBpackage duration trends - Question #173Build data quality solutions
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...
DQS disaster recoverydatabase restoreDQS_MAINRestoreDQDatabases - Question #174Load data
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...
data lineageETL auditingcompliance trackingrecord identification - Question #175Extract and transform data
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...
Active Directory integrationscript componentrecursive hierarchyLDAP - Question #178Build data quality solutions
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...
DQS profilingcleansing activitydata accuracy statisticsdata quality metrics - Question #179Configure and deploy SSIS solutions
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...
project connection managerADO.NETAzure SQL DatabaseSSIS connections - Question #180Extract and transform data
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...
Script taskHTTP downloadCSV fileflat file source - Question #181Extract and transform data
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...
Script componentconditional routingdata flow transformationdata warehouse loading - Question #182Configure and deploy SSIS solutions
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...
SSIS catalog securitydb_ssisoperatorSSISDB rolesSSIS permissions - Question #183Extract and transform data
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...
Script componentActive Directorydata sourcerecursive traversal - Question #184Load data
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...
OLE DB destinationbulk loadtransaction logperformance optimization - Question #185Configure and deploy SSIS solutions
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...
Expression taskSSIS variablespackage initializationcontrol table - Question #186Configure and deploy SSIS solutions
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...
Excel source32-bit runtimeACE driver64-bit compatibility - Question #187Build data quality solutions
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?
Master Data ServicesMDS prerequisitesSQL Server editioninstallation requirements - Question #188Build data quality solutions
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...
Data Quality ServicesDQS prerequisitesData Quality ServerSQL Server Database Engine - Question #189Design and implement a data warehouse
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...
Type 3 SCDcustomer dimensionslowly changing dimensiondata warehouse design - Question #193Design and implement a data warehouse
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...
row-level securitydimension table designdata access controlAzure SQL Database - Question #195Extract and transform data
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...
Lookup transformationMulticast transformationincremental loadchange detection - Question #206Design and implement a data warehouse
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...
fact table granularitytime dimensiondata warehouse designdimensional modeling - Question #207Configure and deploy SSIS solutions
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...
SSIS deploymentdtutilconnection managerspackage configuration - Question #208Configure and deploy SSIS solutions
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...
SSIS upgradeSQL Server Data ToolsBIDS migrationpackage upgrade - Question #209Configure and deploy SSIS solutions
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...
SSIS catalogexecution reportserror loggingpackage monitoring - Question #210Configure and deploy SSIS solutions
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...
event handlersOnTaskFailedSSIS auditingdata flow tasks - Question #211Configure and deploy SSIS solutions
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...
SSIS validationenvironment referencesparameter validationautomated deployment - Question #212Configure and deploy SSIS solutions
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...
SSIS loggingServerExecutionIDcustom log messagesexecution reports - Question #213Extract and transform data
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...
CDC Splitterchange data captureincremental loaddata flow transformation