[Free] 2018(June) Dumps4cert Microsoft 70-463 Dumps with VCE and PDF Download 1-10

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 May Microsoft Official New Released 70-463
100% Free Download! 100% Pass Guaranteed!

Implementing a Data Warehouse with Microsoft SQL Server 2012

Question No: 1 – (Topic 1)

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 classified into subcategories and categories. Each software title is included in only a single software subcategory, and each subcategory is included in only a single category. The data warehouse will be a data source for an Analysis Services cube.

The data warehouse contains two fact tables:

->factSales, used to record daily sales by software title

->factTarget, used to record the monthly sales targets by software category

Reports must be developed against the warehouse that reports sales by software title, category and subcategory, and sales targets.

You need to design the software title dimension. The solution should use as few tables as possible while supporting all the requirements.

What should you do?

  1. Create three software tables, dimSoftware, dimSoftwareCategory, and dimSoftwareSubcategory and a fourth bridge table that joins software titles to their appropriate category and subcategory table records with foreign key constraints. Direct the cube developer to use key granularity attributes.

  2. Create three software tables, dimSoftware, dimSoftwareCategory, and dimSoftwareSubcategory. Connect factSales to all three tables and connect factTarget to dimSoftwareCategory with foreign key constraints. Direct the cube developer to use key granularity attributes.

  3. Create one table, dimSoftware, which contains Software Detail, Category, and Subcategory columns. Connect factSales to dimSoftware with a foreign key constraint. Direct the cube developer to use a non-key granularity attribute for factTarget.

  4. Create two tables, dimSoftware and dimSoftwareCategory. Connect factSales to dimSoftware and factTarget to dimSoftwareCategory with foreign key constraints. Direct the cube developer to use key granularity attributes.

Answer: C

Question No: 2 DRAG DROP – (Topic 1)

You are developing a SQL Server Integration Services (SSIS) package.

The package uses custom functionality that accesses a SQL Server database. The custom functionality must be implemented by using Language Integrated Query (LINQ).

You need to ensure that the LINQ code can be debugged at design time.

What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in the answer area.)

Answer:

Dumps4Cert 2018 PDF and VCE

Question No: 3 – (Topic 1)

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 a simple INSERT statement. The task has the following requirements:

鈥he INSERT statement must use the value of a string package variable. The variable name is StringVar.

鈥he Execute SQL task must use an OLE DB Connection Manager.

In the Parameter Mapping tab of the Execute SQL task, StringVar has been added as the only parameter.

You must configure the SQLStatement property of the Execute SQL task. Which SQL statement should you use?

  1. INSERT INTO dbo.Table (variablevalue) VALUES ($StringVar)

  2. INSERT INTO dbo.Table (variablevalue) VALUES (0)

  3. INSERT INTO dbo.Table (variablevalue) VALUES (@0)

  4. INSERT INTO dbo.Table (variablevalue) VALUES (?)

Answer: D

Explanation: References: http://msdn.microsoft.com/en-us/library/ms141003.aspx http://msdn.microsoft.com/en-us/library/ms140355.aspx http://msdn.microsoft.com/en-us/library/cc280502.aspx

Question No: 4 – (Topic 1)

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 named Projects. The table has change data capture enabled on all columns.

You need to process only the most recent values from rows that have been inserted or updated since the previous execution of the package.

Which query should you use as the data source?

Dumps4Cert 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: D

Reference: http://msdn.microsoft.com/en-us/library/bb522511.aspx Reference: http://msdn.microsoft.com/en-us/library/bb510627.aspx Reference: http://msdn.microsoft.com/en-us/library/cc645937.aspx

Question No: 5 – (Topic 1)

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 allows you to implement the SCD logic.

What should you use?

  1. a Script component

  2. an SCD component

  3. an Aggregate component

  4. a Merge component

    Answer: D

    Question No: 6 DRAG DROP – (Topic 1)

    You are building a SQL Server Integration Services (SSIS) package to load data from all files that are automatically copied to a directory each night through an external FTP process.

    You need to load data from all copied files to a destination table in SQL Server.

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

    Dumps4Cert 2018 PDF and VCE

    Answer:

    Dumps4Cert 2018 PDF and VCE

    Explanation:

    Dumps4Cert 2018 PDF and VCE

    References:

    http://msdn.microsoft.com/en-us/library/ms141724.aspx http://msdn.microsoft.com/en-us/library/ms137728.aspx

    Question No: 7 – (Topic 1)

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

    Dumps4Cert 2018 PDF and VCE

    You need to establish the correct order for loading each table to maximize parallel processing.

    Which order should you use?

    A.

    1. DimCurrency, DimScenario, DimAccount in parallel

    2. DimOrganization

    3. FactFinance

B.

C. DimCurrency, DimOrganization in parallel

  1. DimScenario, DimAccount in parallel

  2. FactFinance

D.

  1. DimCurrency, FactFinance in parallel

  2. DimOrganization, DimScenario, DimAccount in parallel

E.

  1. FactFinance

  2. DimOrganization, DimScenario, DimAccount in parallel

  3. DimCurrency

F.

  1. DimCurrency

  2. DimOrganization

  3. DimScenario, DimAccount in parallel

  4. FactFinance

    Answer: A

    Explanation: References: http://msdn.microsoft.com/en-us/library/ms139892.aspx http://msdn.microsoft.com/en-us/library/ms141261.aspx

    Question No: 8 – (Topic 1)

    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. This project is deployed to SQL Server on a test server.

    You need to ensure that the project is deployed to the SSIS catalog on the production server.

    What should you do?

    1. Open a command prompt and run the dtexec /dumperror /conn command.

    2. Create a reusable custom logging component and use it in the SSIS project.

    3. Open a command prompt and run the gacutil command.

    4. Add an OnError event handler to the SSIS project.

    5. Open a command prompt and execute the package by using the SQL Log provider and running the dtexecui.exe utility.

    6. Open a command prompt and run the dtexec /rep /conn command.

    7. Open a command prompt and run the dtutil /copy command.

    8. Use an msi file to deploy the package on the server.

    9. Configure the SSIS solution to use the Project Deployment Model.

    10. Configure the output of a component in the package data flow to use a data tap.

    11. Run the dtutil command to deploy the package to the SSIS catalog and store the configuration in SQL Server.

Answer: I

Explanation: References: http://msdn.microsoft.com/en-us/library/hh231102.aspx http://msdn.microsoft.com/en-us/library/hh213290.aspx http://msdn.microsoft.com/en-us/library/hh213373.aspx

Question No: 9 – (Topic 1)

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

You need to create a hierarchy representing the organizational structure of the company. Which hierarchy type should you use?

  1. Organizational

  2. Recursive

  3. Non-Mandatory Explicit

  4. Many-to-Many

Answer: B

Question No: 10 – (Topic 1)

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 project and deploy it to the server by using the Project Deployment model.

Operations Log records that are outside the configured retention period must be cleaned automatically.

You need to create the SSIS catalog on the production server.

What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

  1. Enable XP Command Shell.

  2. Enable CLR Integration.

  3. Enable OLE Automation.

  4. Start the SQL Server Browser service.

  5. Enable Cross Database Ownership Chaining

  6. Start the SQL Server Agent service

  7. Enable Ad Hoc Remote Queries.

Answer: B,F

Explanation: Ref: http://msdn.microsoft.com/en-us/library/gg471509(v=sql.110).aspx

100% Dumps4cert Free Download!
Download Free Demo:70-463 Demo PDF
100% Dumps4cert Pass Guaranteed!
70-463 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *