70-463 | A Review Of Free 70-463 Actual Exam

Your success in Microsoft 70-463 is our sole target and we develop all our 70-463 braindumps in a way that facilitates the attainment of this target. Not only is our 70-463 study material the best you can find, it is also the most detailed and the most updated. 70-463 Practice Exams for Microsoft MCP 70-463 are written to the highest standards of technical accuracy.

Online 70-463 free questions and answers of New Version:

NEW QUESTION 1
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 variations of abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching string from a reference table of allowed values. The number of rows in the reference table is very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value. The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading performance.
What should you do?

  • A. Change the Exhaustive property to True.
  • B. Decrease the maximum number of matches per lookup.
  • C. Change the similarity threshold to 0.85.
  • D. Increase the maximum number of matches per looku

Answer: C

NEW QUESTION 2
DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package to insert new data into a data mart. The package uses a Lookup transformation to find matches between the source and destination.
The data flow has the following requirements:
• New rows must be inserted.
• Lookup failures must be written to a flat file.
In the Lookup transformation, the setting for rows with no matching entries is set to Redirect rows to no match output. You need to configure the package to direct data into the correct destinations.
How should you design the data flow outputs? (To answer, drag the appropriate transformation from the list of answer options to the correct location in the answer area.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
Records that have no match in the destination are new records and so should be inserted. Any errors should be recorded in the flat file.
References:
http://msdn.microsoft.com/en-us/library/ms141821.aspx http://msdn.microsoft.com/en-us/library/bb895366.aspx
https://www.simple-talk.com/sql/ssis/implementing-lookup-logic-in-sql-server-integration-services/

NEW QUESTION 3
HOTSPOT
You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools.
A package Connection Manager has been parameterized with project scope.
You need to display the parameters that have been generated for the Connection Manager. What should you use? To answer, select the appropriate setting or settings in the answer area.
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
70-463 dumps exhibit

NEW QUESTION 4
DRAG DROP
You develop a SQL Server Integration Services (SSIS) project by using the Project Deployment model.
The project contains many packages. It is deployed on a server named Development1. The project will be deployed to several servers that run SQL Server 2012.
The project accepts one required parameter. The data type of the parameter is a string.
A SQL Agent job is created that will call the master.dtsx package in the project. A job step is created for the SSIS package.
The job must pass the value of an SSIS Environment Variable to the project parameter. The value of the Environment Variable must be configured differently on each server that runs SQL Server. The value of the Environment Variable must provide the server name to the project parameter.
You need to configure SSIS on the Development1 server to pass the Environment Variable to the package.
Which four actions should you perform in sequence by using SQL Server Management Studio? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
References:
http://msdn.microsoft.com/en-us/library/hh479588.aspx http://msdn.microsoft.com/en-us/library/hh213230.aspx http://msdn.microsoft.com/en-us/library/hh213214.aspx
http://sqlblog.com/blogs/jamie_thomson/archive/2010/11/13/ssis-server-catalogs-environmentsenvironment- variables-in-ssis-in-denali.aspx

NEW QUESTION 5
DRAG DROP
You administer a large and complex SQL Server Integration Services (SSIS) solution in the SSIS catalog.
You are instructed to execute a package by using PowerShell. You need to create the correct PowerShell command.
How should you place the four code segments in sequence? (To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
Note: Example:
ProjectInfo testProject = isserver.Catalogs["SSISDB"].Folders["TEST"].Projects["Integration Services Project2"];
PackageInfo testPackage = testProject.Packages["Package.dtsx"]; Full example:
class Program
{
static void Main(string[] args)
{
SqlConnection conn = new SqlConnection("Data Source=localhost;Initial Catalog=SSISDB;Integrated Security=SSPI;");
IntegrationServices isserver = new IntegrationServices(conn);
ProjectInfo testProject = isserver.Catalogs["SSISDB"].Folders["TEST"].Projects["Integration
Services Project2"];
PackageInfo testPackage = testProject.Packages["Package.dtsx"]; testProject.Parameters["ProjectTestParam1"].Set(ParameterInfo.ParameterValueType.Referenced, "661");
testPackage.Parameters["PackageTestParam1"].Set(ParameterInfo.ParameterValueType.Referenced, "662");
testPackage.Execute(false, null);
}
}
}

NEW QUESTION 6
DRAG DROP
You need to design a data load strategy for a data warehouse fact table. The solution must use an ordered data load.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
70-463 dumps exhibit

NEW QUESTION 7
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 this goal? (Each correct answer presents part of the solution. Choose all that apply.)

  • A. SQL Server Management Studio
  • B. Internet Explorer 6.0 SP1 or later
  • C. Microsoft Silverlight 5
  • D. .NET Framework 3.5 SP1
  • E. .NET Framework 4.0
  • F. Microsoft Silverlight 4
  • G. SQL Server Data Tools

Answer: BE

Explanation:
Before installing DQS, make sure that your computer meets the minimum system requirements. Data Quality Client requirement:
.NET Framework 4.0 (installed during the Data Quality Client installation, if not already installed) Internet Explorer 6.0 SP1 or later

NEW QUESTION 8
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 has the following requirements:
Every night, a very large amount of data is imported into the staging database. Package processing time must be minimized.
The package must run on its own dedicated server when it is deployed to production. Transaction log activity when data is imported must be minimized.
You need to design the package to meet the requirements. Which destination component should you use?

  • A. Raw File
  • B. ODBC
  • C. Bulk Insert
  • D. OLE DB

Answer: D

NEW QUESTION 9
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 hours.
Most queries are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level.
You need to partition the table to maximize the performance of queries. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

  • A. Partition the fact table by month, and compress each partition.
  • B. Partition the fact table by week.
  • C. Partition the fact table by year.
  • D. Partition the fact table by day, and compress each partitio

Answer: D

NEW QUESTION 10
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 reports that combine the custom log messages with the system-generated log messages. What should you do?

  • A. Use an event handler for OnError for the package.
  • B. Use an event handler for OnError for each data flow task.
  • C. Use an event handler for OnTaskFailed for the package.
  • D. View the job history for the SQL Server Agent job.
  • E. View the All Messages subsection of the All Executions report for the package.
  • F. Store the System::SourceID variable in the custom log table.
  • G. Store the System::ServerExecutionID variable in the custom log table.
  • H. Store the System::ExecutionInstanceGUID variable in the custom log table.
  • I. Enable the SSIS log provider for SQL Server for OnError in the package control flow.
  • J. Enable the SSIS log provider for SQL Server for OnTaskFailed in the package control flow,
  • K. Deploy the project by using dtutil.exe with the /COPY DTS option.
  • L. Deploy the project by using dtutil.exe with the /COPY SQL option.
  • M. Deploy the .ispac file by using the Integration Services Deployment Wizard.
  • N. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_project stored procedure.
  • O. Create a SQL Server Agent job to execute the SSISDB.catalog.validate_package stored procedure.
  • P. Create a SQL Server Agent job to execute theSSISDB.catalog.create_execution and SSISDB.catalog.start_execution stored procedures.
  • Q. Create a table to store error informatio
  • R. Create an error output on each data flow destination that writes OnError event text to the table.
  • S. Create a table to store error informatio
  • T. Create an error output on each data flow destination that writes OnTaskFailed event text to the table.

Answer: G

NEW QUESTION 11
DRAG DROP
You administer a Microsoft SQL Server database. Service accounts for SQL Agents are configured to use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a SQL Server Agent job. The SSIS package accesses a network share when exporting data from a SQL Server database.
When you execute the SQL Server Agent job, it fails due to a permissions failure on a share on a remote server. You need to ensure that the SQL Server Agent job can execute the SSIS package. Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms175834.aspx http://msdn.microsoft.com/en-us/library/ms189522.aspx http://msdn.microsoft.com/en-us/library/ms190703.aspx http://msdn.microsoft.com/en-us/library/ms161950.aspx

NEW QUESTION 12
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 the sales manager responsible for each product.
You need to create an attribute in the Product entity that prevents users from entering invalid sales manager values.
Which type of attribute should you create?

  • A. Recursive
  • B. Explicit
  • C. Domain-based
  • D. User-defined
  • E. Derived
  • F. Parent

Answer: C

Explanation:
References:
http://msdn.microsoft.com/en-us/library/bb190163.aspx http://msdn.microsoft.com/en-us/library/ee633737.aspx http://msdn.microsoft.com/en-us/library/ee633759.aspx http://msdn.microsoft.com/en-us/library/ee633745.aspx http://msdn.microsoft.com/en-us/library/ee633724.aspx http://msdn.microsoft.com/en-us/library/ee633733.aspx http://msdn.microsoft.com/en-us/library/ff487058.aspx

NEW QUESTION 13
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 solution that gives the application access to the product data with the least amount of development effort.
What should you do?

  • A. Use sp_addlinkedserver to add a linked server to access the MDS database tables directly.
  • B. Create a Subscription View in MDS.
  • C. Use transactional replication for data synchronization.
  • D. Create an OLE DB connection string that sets the Provider property to MD

Answer: B

Explanation:
You create a subscription view to export Master Data Services data to a subscribing system such as SQL Server. You use the subscribing system to view the data in the Master Data Services database. References:
https://docs.microsoft.com/en-us/sql/master-data-services/overview-exporting-data-master-dataservices? view=sql-server-2017

NEW QUESTION 14
HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server
2012 database.
The package is allowed to connect to only one database. An Environment variable contains the name of the database.
The OLE DB project connection manager has been parameterized.
You need to configure the connection manager property to accept the value of the Environment variable.
Which property should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.)
70-463 dumps exhibit
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
70-463 dumps exhibit

NEW QUESTION 15
DRAG DROP
A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project includes a project Connection Manager to connect to the data warehouse.
The SSIS catalog includes two Environments:
Test
Production
Each Environment defines a single Environment Variable named ConnectionString of type string. The value of each variable consists of the connection string to the test or production data warehouses. You need to execute deployed packages by using either of the defined Environments.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
We need to add references to the Test and Production environments to the project. Then we can map the variables in the project to the environment variables defined in the environments.
When you execute a package in a project that references multiple environments (Test and Production in this case), we can select which environment the package runs under.

NEW QUESTION 16
You are developing a SQL Server Integration Services (SSIS) package. You create a script task in the package.
You need to dynamically set the file name of a connection object named File1 by using the script task Which line of code should you add to the script task?

  • A. Me.Dts.Connections(“File1”).AcquireConnection(“C:\temp\temp.txt”)
  • B. Me.Dts.Connections(“File1”).Variables.Item[“FileName”].value = “C:\temp\temp.txt”
  • C. Me.Dts.Connections(“File1”).Properties.Item[“FileName”].Setvalue = “C:\temp\temp.txt”
  • D. Me.Dts.Connections(“File1”).ConnectionString = “C:\temp\temp.txt”

Answer: B

Explanation:
References:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/faeb29c7-6879-4d51-b94e- 09404de02339/how-to-pass-the-existing-filename-into-a-variable-in-ssis-scripttask? forum=sqlintegrationservices

NEW QUESTION 17
DRAG DROP
You are designing a SQL Server Integration Services (SSIS) package. The package moves order-related
data to a staging table named Order. Every night the staging data is truncated and then all the recent orders from the online store database are inserted into the staging table.
Your package must meet the following requirements:
• If the truncate operation fails, the package execution must stop and report an error.
• If the Data Flow task that moves the data to the staging table fails, the entire refresh operation must be rolled back.
• For auditing purposes, a log entry must be entered in a SQL log table after each execution of the Data Flow task.
The TransactionOption property for the package is set to Required. You need to design the package to meet the requirements.
How should you design the control flow for the package? (To answer, drag the appropriate setting from the list of settings to the correct location or locations in the answer area.)
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms137690.aspx http://msdn.microsoft.com/en-us/library/ms141144.aspx

NEW QUESTION 18
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 changes with every package execution. Common language runtime (CLR) integration cannot be enabled on the SQL Server database where the reference table is located.
You need to configure the Fuzzy Lookup transformation in the most efficient manner. What should you do?

  • A. Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.
  • B. Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
  • C. Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.
  • D. Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Edito

Answer: B

NEW QUESTION 19
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 text files found in a folder. The package must be deployed to a single server by using the Project Deployment model.
Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule.
Each job passes a different folder path to the package.
You need to configure the package to accept the folder path from each job. Which package configuration should you use?

  • A. Parent Package Variable
  • B. XML Configuration File
  • C. Environment Variable
  • D. .dtsConfig file
  • E. Registry Entry

Answer: C

NEW QUESTION 20
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 enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables. What should you do?

  • A. Join the two fact tables.
  • B. Merge the fact tables.
  • C. Create a time dimension that can join to both fact tables at their respective granularity.
  • D. Create a surrogate key for the time dimension.

Answer: C

Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms174537.aspx http://technet.microsoft.com/en-us/library/ms174832.aspx http://msdn.microsoft.com/en-us/library/ms174884.aspx
http://decipherinfosys.wordpress.com/2007/02/01/surrogate-keys-vs-natural-keys-for-primary-key/ http://www.agiledata.org/essays/keys.html http://www.databasejournal.com/features/mssql/article.php/3922066/SQL-Server-Natural-Key-
Verses-Surrogate-Key.htm http://www.jamesserra.com/archive/2012/01/surrogate-keys/

NEW QUESTION 21
HOTSPOT
You are developing a data flow to load sales data into a fact table. In the data flow, you configure a Lookup Transformation in full cache mode to look up the product data for the sale.
The lookup source for the product data is contained in two tables.
You need to set the data source for the lookup to be a query that combines the two tables. Which page of the Lookup Transformation Editor should you select to configure the query? To answer, select the appropriate page in the answer area.
70-463 dumps exhibit

  • A. Mastered
  • B. Not Mastered

Answer: A

Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms141821.aspx http://msdn.microsoft.com/en-us/library/ms189697.aspx

NEW QUESTION 22
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 Environment to the project. Which stored procedure should you use?

  • A. catalog.create_environment_variable
  • B. catalog.create_environment_reference
  • C. catalog.set_execution_parameter_value
  • D. catalog.set_environment_variable_value

Answer: B

Explanation:
Environments (Test, Production etc) are associated with projects by creating references to the environments in the projects.

NEW QUESTION 23
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 enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables. What should you do?

  • A. Create a time mapping table.
  • B. Change the level of granularity in both fact tables to be the same.
  • C. Merge the fact tables.
  • D. Create a view on the sales tabl

Answer: B

NEW QUESTION 24
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 Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the source system.
You need to add a data flow transformation to redirect rows for separate processing of insert, update, and delete operations.
Which data flow transformation should you use?

  • A. Audit
  • B. Merge Join
  • C. Merge
  • D. CDC Splitter

Answer: D

Explanation:
The CDC splitter splits a single flow of change rows from a CDC source data flow into different data flows for Insert, Update and Delete operations
Ref: http://msdn.microsoft.com/en-us/library/hh758656.aspx

NEW QUESTION 25
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 dimension tables and up to five facts at one time.
• Maximize performance of queries that aggregate measures by using any of the 10 dimensions.
• Support billions of rows.
• Use the most efficient design strategy.
You need to design the fact table to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

  • A. Design a fact table with 5 dimensional key columns and 10 measure column
  • B. Place the columnstore index on the dimensional key columns.
  • C. Design a fact table with 5 dimensional key columns and 10 measure column
  • D. Place the columnstore index on the measure columns.
  • E. Design a fact table with 10 dimensional key columns and 5 measure column
  • F. Place the columnstore index on the dimensional key columns and the measure columns.
  • G. Design a fact table with 10 dimensional key columns and 5 measure column
  • H. Place the columnstore index on only the measure columns.

Answer: C

NEW QUESTION 26
You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012.
Quality Assurance (QA) testers in the company must have permission to perform the following tasks on specific projects:
View and validate projects and packages
View Environments and Environment variables Execute packages
You need to grant the minimum possible privileges to the QA testers.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

  • A. In the SSISDB database, add QA Tester logons to the ssis_admin role.
  • B. In the msdb database, add QA Tester logons to the db_ssisoperator role.
  • C. Grant Modify permission in the projects to the QA Tester logons.
  • D. Grant Read permission in the SSIS catalog folder, the projects, and the Environments to the QA Tester logons.
  • E. Grant Execute permission in the projects to the QA Tester logons.
  • F. In the msdb database, add QA Tester logons to the db_ssisItduser rol

Answer: BD

NEW QUESTION 27
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 each hour. The fact table has approximately 4 billion rows and is dimensioned by product, sales date, and sales time of day.
70-463 dumps exhibit
The database administrator is concerned about the rapid growth of the database and users experience poor reporting performance against this database. Reporting requirements have recently changed and the only remaining report that uses this fact table reports sales by product name, sale month, and sale year. No other reports will be created against this table.
You need to reduce the report processing time and minimize the growth of the database. What should you do?

  • A. Create an indexed view over the fact table to sum orderTotal by month.
  • B. Create a view over the fact table to sum orderTotal by month.
  • C. Change the granularity of the fact table to month.
  • D. Partition the fact table by productKe

Answer: C

NEW QUESTION 28
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 should you do?

  • A. Run the Data Quality Server Installer.
  • B. Install the data providers that are used for data refresh.
  • C. Run the dbimpexp.exe command.
  • D. Install the Analysis Services OLE DB Provide

Answer: A

NEW QUESTION 29
......

Thanks for reading the newest 70-463 exam dumps! We recommend you to try the PREMIUM 2passeasy 70-463 dumps in VCE and PDF here: https://www.2passeasy.com/dumps/70-463/ (270 Q&As Dumps)