70-463 Exam Questions - Online Test

70-463 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Our pass rate is high to 98.9% and the similarity percentage between our 70 463 training kit pdf study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the Microsoft 70 463 pdf exam in just one try? I am currently studying for the Microsoft exam 70 463 exam. Latest Microsoft 70 463 pdf Test exam practice questions and answers, Try Microsoft 70 463 dumps Brain Dumps First.

Q51. You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server 2012 database. 

The name of the target instance is passed to the package via an Environment variable. The Environment variable provides the server name to the Project parameter named ServerName. 

The OLE DB Project Connection Manager has been parameterized. 

You need to configure the Connection Manager property to accept the parameter. 

Which property and parameter should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.) 

Answer: 

Q52. 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 has approximately 1 billion rows and is dimensioned by product, sales date, and sales time of day. 

The database administrator is concerned about the growth of the database. Users report 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. Partition the table by product type. 

B. Create a view over the fact table to aggregate sales by month. 

C. Change the granularity of the fact table to month. 

D. Create an indexed view over the fact table to aggregate sales by month. 

Answer: C 

Q53. 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 the appropriate permissions are granted. 

DQS users are experiencing issues connecting to the new Data Quality Server. 

You need to enable users to connect to the new server. 

Which Surface Area Configuration property should you enable? 

A. AdHocRemoteQueriesEnabled 

B. SoapEndpointsEnabled 

C. ClrIntegrationEnabled 

D. RemoteDacEnabled 

E. OleAutomationEnabled 

F. XpCmdShellEnabled 

Answer: C 

Q54. 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 application should you use? 

A. Data Quality Client with administrative credentials 

B. SQL Server Configuration Manager with local administrative credentials 

C. SQL Server Data Tools with local administrative permissions 

D. SQL Server Management Studio with administrative credentials 

Answer: D 

Q55. You are the data steward at your company. 

Duplicate customers exist in a Microsoft Excel workbook. You create a Data Quality Services (DQS) knowledge base and matching policy to identify these duplicate customers. 

You need to identify the duplicate customers. 

Which option should you use? (To answer, select the appropriate option in the answer area.) 

Answer: 

Q56. 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) integration in SQL Server must not be enabled. 

. The Connection Managers used in the package must be configurable without editing the package. 

. The deployment procedure must be automated as much as possible. 

You need to set up a deployment strategy that meets the requirements. 

What should you do? 

A. Use the gacutil command. 

B. Use the dtutil /copy command. 

C. Use the Project Deployment Wizard. 

D. Create an OnError event handler. 

E. Create a reusable custom logging component. 

F. Run the package by using the dtexec /rep /conn command. 

G. Run the package by using the dtexec /dumperror /conn command. 

H. Run the package by using the dtexecui.exe utility and the SQL Log provider. 

I. Add a data tap on the output of a component in the package data flow. 

J. Deploy the package by using an msi file. 

K. Deploy the package to the Integration Services catalog by using dtutil and use SQL Server to store the configuration. 

Answer: B 

Q57. 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 that accesses a Microsoft Excel file. Additional packages in the project must also access this file. 

You need to define and reuse the Excel file connection in all project packages. 

What should you do? 

A. Copy the package Connection Manager and paste it in the second package. 

B. Set the RetainSameConnection property of the package Connection Manager to True. 

C. Convert the package Connection Manager in the first package to a project Connection Manager. 

D. Convert the project to the Package Deployment model. 

Answer: B 

Q58. You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive property. 

You need to create a project parameter and configure it so that its value is encrypted when it is deployed to the SSIS catalog. 

Which three steps 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.) 

Answer: 

Q59. A Data Flow task in a SQL Server Integration Services (SSIS) package produces run-time errors. 

You need to edit the package to log specific error messages. 

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.) 

Answer: 

Q60. 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 columns. Place the columnstore index on the dimensional key columns. 

B. Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the measure columns. 

C. Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on the dimensional key columns and the measure columns. 

D. Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on only the measure columns. 

Answer: C