70-463 Exam Questions
184 real 70-463 exam questions with expert-verified answers and explanations. Page 1 of 4.
- Question #1Design and implement a data warehouse
You are reviewing the design of a customer dimension table in an existing data warehouse hosted on SQL Azure. The current dimension design does not allow the retention of historica...
slowly changing dimensionsSCD Type 2customer dimensionhistorical tracking - Question #2Design and implement a data warehouse
You are implementing the indexing strategy for a fact table in a data warehouse. The fact table is named Quotes. The table has no indexes and consists of seven columns: - [ID] - [Q...
columnstore indexfact tableindexing strategyquery optimization - Question #3Design and implement a data warehouse
You are designing an enterprise star schema that will consolidate data from three independent data marts. One of the data marts is hosted on SQL Azure. Most of the dimensions have...
conformed dimensionstar schemadata mart consolidationgeography dimension - Question #4Configure and deploy SSIS solutions
To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is put in place. The methodology has the following requirements: - The d...
SSIS loggingProject Deployment ModelSSIS catalogcentralized logging - Question #5Configure and deploy SSIS solutions
You are developing a SQL Server Integration Services (SSIS) project that copies a large amount of rows from a SQL Azure database. The project uses the Package Deployment Model. Thi...
SSIS deploymentProject Deployment ModelSSIS catalogpackage migration - Question #6Configure and deploy SSIS solutions
You are developing a SQL Server Integration Services (SSIS) package. To process complex scientific data originating from a SQL Azure database, a custom task component is added to t...
SSIS custom componentGAC registrationgacutilSSIS deployment - Question #8Configure and deploy SSIS solutions
You develop and deploy a SQL Server Integration Services (SSIS) package. The package is stored in the file system. You need to execute the package without importing it to the SSIS...
dtexecSQL Server AgentSSIS executionfile system deployment - Question #10Extract and transform data
You are developing a data flow transformation to merge two data sources. One source contains product data and the other source contains data about the country in which the product...
Merge JoinSortKeyPositionIsSorted propertydata flow transformation - Question #11Extract and transform data
You are developing a SQL Server Integration Services (SSIS) package. You need to design a package to change a variable value during package execution by using the least amount of d...
Expression taskSSIS variablescontrol flowpackage execution - Question #13Extract and transform data
You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source con...
Union AllMerge transformationdata flowcombining data sources - Question #14Configure and deploy SSIS solutions
You are using SQL Server Data Tools to develop a SQL Server Integration Services (SSIS) project. The first package that you create in this project contains a package connection tha...
project Connection Managerpackage Connection ManagerSSIS projectflat file connection - Question #16Build data quality solutions
You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup transformation. The reference data to be used in the transformation does not change. Y...
Fuzzy Lookupmatch indexGenerateAndPersistNewIndexperformance optimization - Question #17Configure and deploy SSIS solutions
You are using a SQL Server Integration Services (SSIS) project that is stored in the SSIS catalog. An Environment has been defined in the SSIS catalog. You need to add the Environm...
SSIS catalogenvironment referencecatalog stored proceduresProject Deployment Model - Question #19Configure and deploy SSIS solutions
You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure. The package uses a Foreach container to process tex...
SSIS configurationenvironment variablesProject Deployment ModelSQL Server Agent - Question #22Extract and transform data
You are developing a SQL Server Integration Services (SSIS) package that imports data from a relational database to a data warehouse. You are importing data from a relational table...
change data captureCDC functionsincremental loaddata source query - Question #23Load data
You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse. You need to establish the correct order for loading each table to maximize p...
parallel loadingtable load orderdimension tablesfact tables - Question #24Configure and deploy SSIS solutions
You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table named Orders in a SQL Azure database. The company's auditing policies have the fol...
event handlersOnPostExecuteaudit loggingSQL Azure - Question #25Configure and deploy SSIS solutions
You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The package and all three Execute SQL tasks have their Tr...
TransactionOptiontransaction managementrollbackSequence container - Question #28Load data
You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing Dimension (SCD). You need to add a task or component to the package that...
Slowly Changing DimensionType 3 SCDSSIS componentsdimension management - Question #29Configure and deploy SSIS solutions
You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse. You add an Execute SQL task to the control flow. The task must execute...
Execute SQL taskOLE DB parameter syntaxparameter mappingvariable binding - Question #31Build data quality solutions
You are installing the Data Quality Client on user desktops. You need to ensure that the prerequisite software components are installed. Which components must be present to meet th...
Data Quality Clientinstallation prerequisites.NET Framework 4.0Internet Explorer - Question #34Build data quality solutions
You are creating a SQL Server Master Data Services (MDS) model. This model is used to store a master list of products. An attribute must be added to the Product entity to define th...
Master Data Servicesdomain-based attributedata validationentity attributes - Question #35Build 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...
DQS installationDQSInstaller.exepost-installation configurationData Quality Server - Question #36Build data quality solutions
You are creating a SQL Server Master Data Services (MDS) model for a company. The source data for the company is stored in a single table that contains the manager-to- subordinate...
Master Data Servicesrecursive hierarchyself-referencing relationshipsorganizational structure - Question #37Build data quality solutions
You are the data steward for a Business Intelligence project. You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Ser...
Data Quality Servicesduplicate detectiondata quality projectknowledge base - Question #38Build data quality solutions
You manage a SQL Server Master Data Services (MDS) environment. A new application requires access to the product data that is available in the MDS repository. You need to design a...
Master Data ServicesSubscription Viewdata accessMDS integration - Question #39Build data quality solutions
You are installing SQL Server Data Quality Services (DQS). You need to give users belonging to a specific Active Directory group access to the Data Quality Server. Which SQL Server...
DQS securityActive Directory groupsSQL Server Management Studiopermissions - Question #40Build data quality solutions
You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base. In the mapping configuration, two of the t...
Knowledge Discoverydomain mappingDQS knowledge basedomain creation - Question #41Build data quality solutions
You are maintaining a Data Quality Services (DQS) environment. The production server failed and a new server has been set up. The DQS databases are restored to a new server. All th...
DQS configurationCLR integrationSurface Area Configurationserver recovery - Question #42Configure and deploy SSIS solutions
Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not complete and nothing is processed. You need to ensure that package logging occu...
SSIS loggingdtexecuiSQL Log providerpackage execution - Question #43Configure and deploy SSIS solutions
You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system. Data integrity in the legacy system is very poor. Invalid rows are discar...
data taperror loggingdata flowCSV output - Question #44Configure and deploy SSIS solutions
You are developing a project that contains multiple SQL Server Integration Services (SSIS) packages. The packages will be deployed to the SSIS catalog. One of the steps in each pac...
SSIS parameterssensitive propertyencryptionSSIS catalog - Question #45Configure and deploy SSIS solutions
A SQL Server Integration Services (SSIS) package was deployed two weeks ago with the Project Deployment Model. Sometimes the package is started as part of a multistep SQL job. At o...
SSISDB catalogexecutions viewpackage monitoringproject deployment model - Question #47Configure and deploy SSIS solutions
You install a SQL Server 2012 database engine instance on a production server. A month later, you install SQL Server 2012 Integration Services (SSIS). You must develop an SSIS proj...
SSIS catalogCLR integrationSQL Server Agentoperations log - Question #48Configure 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 upgrade wizardpackage upgradeBIDSSQL Server 2012 - Question #49Configure and deploy SSIS solutions
You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. A package in the project uses a custom task component. You need to ensure that the c...
custom task componentgacutilGACdeployment - Question #50Configure and deploy SSIS solutions
You are deploying a project to the SQL Server Integration Services (SSIS) catalog. You need to ensure that the project is deployed to the production environment with the least amou...
Project Deployment WizardSSIS catalogdeploymentleast effort - Question #51Configure and deploy SSIS solutions
To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package logging methodology. The methodology has the following requirements: - Central...
SSIS loggingcentralized loggingpackage executionlog provider - Question #52Build data quality solutions
You are creating a SQL Server Master Data Services (MDS) model for a company. The source data for the company is stored in a single table that contains the manager-to- subordinate...
Master Data Servicesrecursive hierarchyorganizational structureMDS hierarchy types - Question #53Extract and transform data
You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data warehouse every night. The SQL Azure data contains many misspellings and variat...
Fuzzy Lookupsimilarity thresholddata cleansingtransformation - Question #54Extract and transform data
You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL Azure database into a data warehouse. The source system contains redundant or...
data tapinvalid rowserror outputdata flow - Question #55Build data quality solutions
You are the data steward for a Business Intelligence project. You must identify duplicate rows stored in a SQL Server table and output discoveries to a CSV file. A Data Quality Ser...
Data Quality Servicesduplicate detectionDQS knowledge basedata quality project - Question #56Build data quality solutions
You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client application to modify an existing knowledge base. In the mapping configuration, two of the t...
DQS Knowledge Discoverydomain mappingknowledge basecolumn mapping - Question #57Build data quality solutions
You are installing SQL Server Data Quality Services (DQS). You need to give specific users access to the Data Quality Server. Which SQL Server application should you use?
DQS installationuser accessData Quality ServerSQL Server Management Studio - Question #58Build data quality solutions
You manage a SQL Server Master Data Services (MDS) environment. A new application requires access to the product data that is available in the MDS repository. You need to design a...
Master Data ServicesSubscription Viewdata accessMDS repository - Question #59Build 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...
DQS installationData Quality Serverpost-installation configurationDQS setup - Question #60Configure and deploy SSIS solutions
You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasks and no other tasks. The three Execute SQL tasks modify products in staging ta...
SSIS transactionsTransactionOptionrollbackExecute SQL task - Question #61Configure and deploy SSIS solutions
You are developing a SQL Server Integration Services (SSIS) package that imports data into a data warehouse hosted on SQL Azure. The package uses a Foreach container to process tex...
SSIS parametersenvironment variableproject deployment modelpackage configuration - Question #64Extract and transform data
You are creating a SQL Server Integration Services (SSIS) package that implements a Type 3 Slowly Changing Dimension (SCD). You need to add a task or component to the package that...
SCD Type 3slowly changing dimensionMerge transformationdata flow - Question #65Load data
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on Server A . The package includes a data flow and is executed on ServerB....
OLE DB destinationFast Loadidentity columnbulk insert