Download 70-463 Braindumps 2021

Exam Code: 70-463 (70 463 dumps), Exam Name: Implementing a Data Warehouse with Microsoft SQL Server 2012, Certification Provider: Microsoft Certifitcation, Free Today! Guaranteed Training- Pass 70-463 Exam.

Online Microsoft 70-463 free dumps demo Below:

NEW QUESTION 1
Some of the data your company processes is sent in from partners via email.
How would you configure an SMTP connection manager to extract files from email messages?

  • A. In the SMTP connection manager, configure the OperationMode setting to Send And Receive.
  • B. It is not possible to use the SMTP connection manager in this way, because it can only be used by SSIS to send email messages.
  • C. The SMTP connection manager supports sending and receiving email messages by default, so no additional configuration is necessary.
  • D. It is not possible to use the SMTP connection manager for this; use the IMAP (Internet MessageAccess Protocol) connection manager instea

Answer: B

Explanation: References:
https://docs.microsoft.com/en-us/sql/integration-services/connection-manager/smtp-connectionmanager

NEW QUESTION 2
You need to extract data from delimited text files. What connection manager type would you choose?

  • A. A Flat File connection manager
  • B. An OLE DB connection manager
  • C. An ADO.NET connection manager
  • D. A File connection manager

Answer: A

Explanation: References:
http://smallbusiness.chron.com/import-csv-ssis-46849.html

NEW QUESTION 3
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. Change the similarity threshold to 0.55.
  • C. Change the similarity threshold to 0.40.
  • D. Increase the maximum number of matches per looku

Answer: B

Explanation: http://msdn.microsoft.com/en-us/library/ms137786.aspx

NEW QUESTION 4
DRAG DROP
You are building a fact table in a data warehouse.
The table must have a columnstore index. The table cannot be partitioned. You need to design the fact table and load it with data.
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

    Answer:

    Explanation: 70-463 dumps exhibit

    NEW QUESTION 5
    DRAG DROP
    You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing. Issues concerning addresses are discovered in the data warehouse that you manage. Validation must separate the addresses into three categories:
    Valid addresses Autocorrected addresses Invalid addresses
    You need to enhance the SSIS packages to perform address validation by using an external service. Which transformation should you use? (To answer, drag the appropriate transformation from the list of options to the correct location or locations in the answer area.)
    70-463 dumps exhibit

      Answer:

      Explanation: 70-463 dumps exhibit

      NEW QUESTION 6
      HOTSPOT
      You are designing a SQL Server Integration Services (SSIS) package configuration strategy. The package configuration must meet the following requirements:
      Include multiple properties in a configuration.
      Force packages to load all settings in the configuration. Support Encrypting File System (EFS) formats.
      You need to select the appropriate configuration. Which configuration type should you use?
      To answer, select the appropriate option from the drop-down list in the dialog box.
      70-463 dumps exhibit

        Answer:

        Explanation: 70-463 dumps exhibit

        NEW QUESTION 7
        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 development effort.
        What should you use?

        • A. Expression task
        • B. Data Cleansing transformation
        • C. Fuzzy Lookup transformation
        • D. Term Lookup transformation
        • E. Data Profiling task

        Answer: A

        NEW QUESTION 8
        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.
        70-463 dumps exhibit
        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 mont

        Answer: C

        NEW QUESTION 9
        If you want to switch content from a nonpartitioned table to a partition of a partitioned table, what conditions must the nonpartitioned table meet? (Choose all that apply.)

        • A. It must have the same constraints as the partitioned table.
        • B. It must have the same compression as the partitioned table.
        • C. It must be in a special PartitionedTables schema.
        • D. It must have a check constraint on the partitioning column that guarantees that all of the data goes toexactly one partition of the partitioned table.
        • E. It must have the same indexes as the partitioned table.

        Answer: ABDE

        Explanation: References:
        https://technet.microsoft.com/en-us/library/ms191160(v=sql.105).aspx

        NEW QUESTION 10
        Your company has several line-of-business applications. The applications use a server that has SQL Server installed and contains several databases.
        You need that the business applications can access curated and validated data from the databases. Which features should you deploy to the server?

        • A. Data Quality Services (DQS)
        • B. SQL Server Analysis Services (SSAS) dimension hierarchies.
        • C. SQL Server Integration Services (SSIS)
        • D. Master Data Services (MDS) subscription

        Answer: C

        NEW QUESTION 11
        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

          Answer:

          Explanation: 70-463 dumps exhibit

          NEW QUESTION 12
          You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database.
          The package contains a data flow task that has seven source-to-destination execution trees. Only three of the source-to-destination execution trees are running in parallel.
          You need to ensure that all the execution trees run in parallel. What should you do?

          • A. Set the EngineThreads property of the data flow task to 7.
          • B. Set the MaxConcurrentExcecutables property of the package to 7.
          • C. Create seven data flow tasks that contain one source-to-destination execution tree each.
          • D. Place the data flow task in a For Loop container that is configured to execute seven time

          Answer: A

          NEW QUESTION 13
          CORRECT TEXT
          You are designing a package control flow. The package moves sales order data from a SQL Azure transactional database to an on-premise reporting database. The package will run several times a day, while new sales orders are being added to the transactional database. The current design of the package control flow is shown in the answer area. (Click the Exhibit button.)
          70-463 dumps exhibit
          The Insert New Orders Data Flow task must meet the following requirements:
          • Usage of the tempdb database should not be impacted.
          • Concurrency should be maximized, while only reading committed transactions.
          • If the task fails, only that task needs to be rolled back.
          You need to configure the Insert New Orders Data Flow task to meet the requirements.
          How should you configure the transaction properties? (To answer, select the appropriate setting or settings in the answer area.)
          70-463 dumps exhibit

            Answer:

            Explanation: IsolationLevel = ReadCommited.
            TransactionOption = Required
            References:
            http://msdn.microsoft.com/en-us/library/ms137690.aspx http://msdn.microsoft.com/en-us/library/ms137749.aspx http://msdn.microsoft.com/enus/ library/microsoft.sqlserver.dts.runtime.dtscontainer.isolationlevel.aspx http://msdn.microsoft.com/en-us/library/ms173763.aspx

            NEW QUESTION 14
            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 15
            You are designing a SQL Server Integration Services (SSIS) package that will load data from a source system to a data mart.
            You need to combine conditionally the value of two project parameters to a package variable. What should you do?

            • A. Configure an event handler.
            • B. Set the data type property of the variable.
            • C. Set the Expression property of the variable.
            • D. Modify the namespace of the variable.

            Answer: C

            Explanation: The Expression property of a variable specifies the expression that is assigned to the variable. References:
            https://docs.microsoft.com/en-us/sql/integration-services/integration-services-ssis-variables

            NEW QUESTION 16
            You develop a SQL Server Integration Services (SSIS) package in a project by using the Project Deployment Model. It is regularly executed within a multi-step SQL Server Agent job.
            You make changes to the package that should improve performance.
            You need to establish if there is a trend in the durations of the next 10 successful executions of the package. You need to use the least amount of administrative effort to achieve this goal.
            What should you do?

            • A. Enable logging to an XML file in the package control flow for the Onlnformation even
            • B. After 10 executions, view the XML file.
            • C. After 10 executions, view the job history for the SQL Server Agent job.
            • D. After 10 executions, in SQL Server Management Studio, view the Execution Performance subsection of the All Executions report for the package.
            • E. Enable logging to an XML file in the package control flow for the OnPostExecute even
            • F. After 10 executions, view the XML file.

            Answer: C

            NEW QUESTION 17
            You are preparing to install SQL Server 2012 Master Data Services (MDS). You need to ensure that the database requirements are met.
            What should you install?

            • A. Microsoft SharePoint Foundation 2010 SP1
            • B. SQL Server 2012 Enterprise (64-bit) x64 on the database server
            • C. SQL Server 2012 Data Center (64-bit) x64 on the database server
            • D. SQL Server 2008 Enterprise (64-bit) x64 on the database server

            Answer: B

            Explanation: * Master Data Services is a new feature introduced in SQL Server 2008 R2 and further enhanced in SQL Server 2012.
            * SQL Server 2012 Enterprise features include Master Data Services:
            70-463 dumps exhibit
            Note:
            * Microsoft SQL Server Master Data Services is a Master Data Management (MDM) product from Microsoft, which will ship as a part of the Microsoft SQL Server database.Originally code-named Bulldog, Master Data Services is the rebranding of the Stratature MDM product titled +EDM, which Microsoft acquired in June 2007. Master Data Services is architecturally similar to +EDM, with increased integration with other Microsoft applications as well as some new features. Master Data Services first shipped with Microsoft SQL Server 2008 R2.

            NEW QUESTION 18
            DRAG DROP
            You are maintaining a SQL Server Integration Services (SSIS) package. The package uses custom functionality that is implemented in Microsoft Visual C#.
            The implementation of the custom functionality changes overtime. The design of the package allows you to deploy new releases of the custom functionality without redeploying the entire package.
            You need to implement and deploy an update to the custom functionality without requiring package redeployment.
            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

              Answer:

              Explanation: 70-463 dumps exhibit

              P.S. Certleader now are offering 100% pass ensure 70-463 dumps! All 70-463 exam questions have been updated with correct answers: https://www.certleader.com/70-463-dumps.html (270 New Questions)