70-463 Exam Questions
184 real 70-463 exam questions with expert-verified answers and explanations. Page 2 of 4.
- Question #66Configure 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 mappingpackage variableparameter syntax - Question #68Configure and deploy SSIS solutions
You are designing a SQL Server Integration Services (SS1S) package that uploads a file to a table named Orders in a SQL Azure database. The company's auditing policies have the fol...
event handlersOnPostExecuteauditinglogging - Question #72Design and implement a data warehouse
You are designing a data warehouse for a fresh food distribution business that stores sates by individual product. It stores sales targets by product category. Products are classif...
dimension designsnowflake schemaproduct hierarchyfact table - Question #73Design and implement a data warehouse
You are reviewing the design of a student dimension table in an existing data warehouse hosted on SQL Azure. The current dimension design does not allow the retention of historical...
SCD Type 2historical trackingStartDate EndDatedimension redesign - Question #74Design 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 #75Design and implement a data warehouse
You are reviewing the design of an existing fact table named factSales, which is loaded incrementally from a SQL Azure database by a SQL Server Integration Services (SSIS) package...
fact table granularityperformance optimization4 billion rowsreporting - Question #76Configure and deploy SSIS solutions
You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages. The new capability is not available as an SSIS task. Each package must be extended...
custom taskSSIS extensibilityreusabilitypackage development - Question #77Extract 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 transformationcombining sourcesdata flow - Question #79Extract 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 SQL Azure. One of the columns i...
Script componentconditional routingdata flow streamsproduct code - Question #82Extract 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 JoinIsSorted propertySortKeyPositiondata flow transformation - Question #83Configure 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 procedureproject deployment - Question #84Configure and deploy SSIS solutions
You are developing a SQL Server Integration Services (SSIS) package. The package is stored as the myPackage.dtsx file in the root directory of the C drive of the SSIS server. You n...
dtexeccommand promptpackage executionfile system path - Question #86Configure and deploy SSIS solutions
You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions, the package execution does not finish and no data seems to have been trans...
SSIS loggingdtexecSQL Log providertroubleshooting - Question #88Configure 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...
sensitive parametersencryptionSSIS catalogproject deployment model - Question #89Extract 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 cleansingstring matching - Question #90Configure 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 catalog creationCLR integrationSQL Server Agentproject deployment model - Question #91Configure and deploy SSIS solutions
A SQL Server Integration Services (SSIS) package on a computer is failing periodically in production. The package was created less than one year ago and was deployed to the SSIS ca...
SSIS catalogexecution historySSISDB viewsauditing - Question #92Configure 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 Toolspackage migrationBIDS - Question #94Design 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...
time dimensionfact table granularityreferential integritydimension design - Question #97Design and implement a data warehouse
You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser...
row-level securitybridge tabledimension designSQL Azure - Question #98Design and implement a data warehouse
You are reviewing the design of an existing fact table named factSales, which is loaded from a SQL Azure database by a SQL Server Integration Services (SSIS) package each day. The...
fact table granularityperformance optimizationdata warehouse designaggregation - Question #99Design and implement a data warehouse
You are designing a data warehouse for a software distribution business that stores sales by software title. It stores sales targets by software category. Software titles are class...
dimension designconformed dimensionshierarchysnowflake schema - Question #101Configure and deploy SSIS solutions
You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed. You plan to deploy new SSIS packages to the server. The SSIS packages u...
SSIS catalogproject deployment modelenvironment variablesconfiguration - Question #102Extract 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 SQL Azure. One of the columns i...
Script Componentdata flow routingconditional processingproduct code - Question #106Extract and transform data
You work as a senior database administrator at ABC.com. The ABC.com network consists of a single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their envir...
Slowly Changing DimensionSCD transformation outputsHistorical AttributesDerived Column - Question #108Configure and deploy SSIS solutions
You are running a training exercise for Microsoft SQL Server 2012 junior developers. You are discussing the ValidateExternalMetaData property for a data flow. Which of the followin...
ValidateExternalMetaDatadata flow propertiesBoolean propertySSIS metadata - Question #110Extract and transform data
You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing Multicast transformation. Which of the following is TRUE with regards...
Multicast transformationlogical data copiesmultiple outputsdata flow - Question #112Build data quality solutions
You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured to make use of the Generate And Persist New Index Fuzzy Lookup t...
Fuzzy LookupGenerate And Persist New Indexreference indexmatching transformation - Question #113Configure and deploy SSIS solutions
You are in the process of creating a SQL Server Integration Services (SSIS) package. You have decided to make use of Expression Task. Which of the following is TRUE with regards to...
Expression Taskvariable valuesruntime expressionscontrol flow - Question #114Build data quality solutions
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing data quality projects. Which of the following are benefits of data quali...
data quality projectsDQS knowledge basedata cleansingdata matching - Question #115Configure and deploy SSIS solutions
You have been asked to revise a SQL Server Integration Services (SSIS) package. The package only includes Execute SQL tasks. To make sure that, in the event of an Execute SQL task...
TransactionOptiontransaction rollbackExecute SQL taskpackage transactions - Question #116Configure and deploy SSIS solutions
You have recently created an SQL Server Integration Services (SSIS) project catalog that contains two Environments. A single Environment Variable, named ConnectionString, of type s...
SSIS catalogEnvironment Variableparameter bindingproject deployment - Question #117Configure and deploy SSIS solutions
You are currently discussing an EventHandlerClass property that is used to retrieve or configure a value that indicates whether the container participates in transactions. Which of...
TransactionOption propertyEventHandlerClasscontainer transactionsSSIS properties - Question #118Configure and deploy SSIS solutions
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the effects of setting IsolationLevel transaction property of a Data Flo...
IsolationLevelChaos isolationtransaction isolation levelsData Flow task - Question #119Configure and deploy SSIS solutions
You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured to import data into a SQL Azure hosted data warehouse. You have...
package configurationEnvironment Variable configurationproperty pathconfiguration types - Question #120Build data quality solutions
You are hosting a training exercise for Microsoft SQL Server 2012 administrators. You are currently discussing the Fuzzy Lookup transformation. Which of the following is TRUE with...
Fuzzy Lookupsimilarity thresholdmatching accuracylookup performance - Question #121Configure and deploy SSIS solutions
You have created a SQL Server Integration Services (SSIS) project that you are preparing to deploy using the Integration Services Deployment Wizard. Which of the following is the t...
Deployment WizardSSIS deployment stepswizard sequenceproject deployment - Question #122Configure and deploy SSIS solutions
You have received reports regarding a current existing SQL Server Integration Services (SSIS) package not completing its execution, and not transferring data. You have decided to m...
Package Deployment ModelCLR integrationevent capturedeployment models - Question #123Configure and deploy SSIS solutions
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the use of the add_data_tap stored procedure. Which of the following is...
add_data_tapdata tap stored proceduretroubleshootingSSIS debugging - Question #124Extract and transform data
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing the use of Slowly Changing Dimension Transformation Outputs. One of the...
Slowly Changing DimensionChanging Attributes Updates OutputSCD outputslookup table - Question #125Configure and deploy SSIS solutions
You are in the process of creating a SQL Server Integration Services (SSIS) package. The package will be configured upload a file to a table in a SQL Azure database. You need to ma...
OnPostValidateevent handlersvalidation eventsSSIS executables - Question #126Design and implement a data warehouse
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are discussing replication type that is used when subscribers need to receive data, mak...
merge replicationoffline synchronizationreplication typespublisher subscriber - Question #127Extract and transform data
You are running a training exercise for Microsoft SQL Server 2012 junior developers. Which of the following represents the data type for this property?
SSIS metadataIDTSExternalMetadataColumn100data typesSQL Server 2012 - Question #128Configure and deploy SSIS solutions
You have received reports regarding a current existing SQL Server Integration Services (SSIS) package not completing its execution, and not transferring data. You have decided to m...
Project Deployment ModelCLR integrationSSISDB catalogevent logging - Question #129Design and implement a data warehouse
You are designing an extract, transform, load (ETL) process for loading data from a SQL Server database into a large fact table in a data warehouse each day with the prior day's sa...
fact table partitioningETL optimizationdata retentiontransaction log - Question #130Design and implement a data warehouse
You are designing a fact table in a SQL Server database. The fact table must meet the following requirements: - Include a columnstore index. - Allow users to choose up to 10 dimens...
fact table designcolumnstore indexdimensional keysquery performance - Question #131Build data quality solutions
You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online Transactional Processing (OLTP) data sources into a SQL Server data mart. You hav...
Data Profiling taskexception reportnull ratioscolumn distribution - Question #132Configure 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 ModelSSISDB loggingconnection string parametersdeployment model selection - Question #133Design and implement a data warehouse
You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of millions of new records are loaded into the data warehouse weekly, outside of business...
table partitioningpartition compressionquery optimizationdata warehouse performance - Question #135Design and implement a data warehouse
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 colum...
composite primary keyunique constrainttable designdata ordering