we provide Precise Microsoft 70-470 free draindumps which are the best for clearing 70-470 test, and to get certified by Microsoft Recertification for MCSE: Business Intelligence. The 70-470 Questions & Answers covers all the knowledge points of the real 70-470 exam. Crack your Microsoft 70-470 Exam with latest dumps, guaranteed!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Microsoft 70-470 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 70-470 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/70-470-exam-dumps.html
Q101. - (Topic 9)
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 the same connection managers and variables.
You have the following requirements:
. Ensure that the deployment model supports changing the content of connection strings by using parameters at execution time. . Ensure that the deployment model automatically starts from calls to the
catalog.start_execution stored procedure in the SSISDB database.
. Maximize performance at execution time.
. Minimize development effort.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use a package deployment model. Use a SQL Server package configuration with a common filter. Change the contents of the SSIS Configurations table at runtime.
B. Use a project deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.
C. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.
D. Use a project deployment model. Modify connection manager properties to use project parameters. Ensure that the SSISDB database is created.
Answer: D
Q102. DRAG DROP - (Topic 9)
You have a business intelligence (BI) solution that uses SQL Server Integration Services (SSIS). The BI solution includes an extract transformation, and load (ETL) system.
You are designing a logging and auditing strategy for the ETL system.
You need to ensure that an ETL administrator can view the row counts of any data flow
path for each package execution.
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:
Q103. - (Topic 9)
An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements:
. Implement drill-down browsing. . Reduce the number of attribute hierarchies but ensure that the information contained within them is available to users on demand. . Optimize performance.
You need to redesign the cube dimension to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. set the AggregateFunction property to Sum on all measures. Use the SCOPE statement in a Multidimensional Expressions (MDX) calculation to tune the aggregation types.
B. Set the AttributeHierarchyOptimizedState property to FullyOptimized on the attribute hierarchies.
C. Create user-defined hierarchies. For the attributes sourced by the levels of the user-defined hierarchies, set the RelationshipType property to Rigid. Run incremental processing.
D. Remove as many attribute hierarchies as possible from the dimension. Reintroduce the information in the attribute hierarchies as properties. Implement natural hierarchies and set the AttributeHierarchyVisible property to False for attributes used as levels in the natural
hierarchies.
Answer: D
Q104. HOTSPOT - (Topic 9)
You are configuring the partition storage settings for a SQL Server Analysis Services (SSAS) cube.
The partition storage must meet the following requirements:
Optimize the storage of source data and aggregations in the cube.
Use proactive caching.
Drop cached data that is more than 30 minutes old.
Update the cache when data changes, with a silence interval of 10 seconds.
You need to select the partition storage setting.
Which setting should you select?
To answer, select the appropriate setting in the answer area.
....
Answer:
Q105. DRAG DROP - (Topic 9)
You are designing a dataset for a SQL Server Reporting Services (SSRS) report. The report includes the report items displayed in the following graphic.
The dataset is sourced from a commonly used stored procedure in an inventory data mart hosted in a SQL Azure database.
It returns the status for all products across all storage sites. The report must display data for the storage site that is selected by the Site report parameter. You cannot change the stored procedure code.
You need to filter the dataset to use only data specific to the selected site.
How should you configure the filter?
To answer, drag the appropriate expression or expressions to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Answer:
Q106. - (Topic 4)
You need to use SQL Server Management Studio (SSMS) to make the SSAS databases available for application testing.
What should you do?
A. Restore the SSAS databases from the latest backup to SSAS01.
B. Script the databases as a Create script to a new window and then execute the script on SSAS01.
C. Detach the SSAS databases from the SSASCluster, and then attach them to SSAS01.
D. Use the Import/Export Wizard to copy the databases from the production server to the development server.
Answer: A
Q107. DRAG DROP - (Topic 9)
You develop a SQL Server Integration Services (SSIS) project named Project1 by using
SQL Server Data Tools (SSDT). Project1 contains a package named Package1.
You add a project parameter named EnvironmentText to Project1.
In SQL Server Management Studio (SSMS), you create the SSIS catalog.
You have the following requirements:
. Configure Package1 so it can run within either a development environment or a test environment.
. Pass the value of an SSIS environment variable to the EnvironmentText project parameter.
. The value of the environment variable must be different for each SSIS environment.
You need to deploy the SSIS project and configure the SSIS environment.
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:
Q108. - (Topic 4)
You need to design the recovery strategy for SSRS01.
What should the strategy include? (Each correct answer presents part of the solution. Choose all that apply.)
A. Re-create the SQL Server Agent jobs that are used to trigger schedules.
B. Restore the ReportServer and ReportServerTempDB databases with recovery.
C. Restore the ReportServer and ReportServerTempDB databases with no recovery.
D. Restore the msdb database.
E. Restore the Report Server encryption key.
F. Restore the database encryption key.
Answer: A,B,E
39. - (Topic 4)
You need to re-establish subscriptions on SSRS01.
What should you do?
A. Start the SQL Server Agent on SSRS01.
B. Restore the ReportServer database.
C. Restore the ReportServerTempDB database.
D. Use the SQL Server Configuration Manager to reset the SQL Service account credentials.
Answer: A
Q109. DRAG DROP - (Topic 3)
You need to complete the following UPDATE statement to initialize the budget sales values for 2012.
Which MDX weight value expression should you use?
To answer, drag the appropriate weight value expression to the answer area.
Answer:
Q110. DRAG DROP - (Topic 4)
You need to upgrade the SSASCluster.
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:
45. - (Topic 4)
You need to configure SSRS to send the required notification messages.
Which configuration settings should you use? (Each correct answer presents a partial solution. Choose all that apply.)
A. <SendUsing>2</SendUsing>
B. <SendUsing>contoso.com</SendUsing>
C. <SMTPServer>SMTP01/SMTPServer>
D. <SMTPServerPort>110</SMTPServerPort>
E. <SMTPServer>SSRS01/SMTPServer>
F. <From>reports@contoso.com</From>
G. <PermittedHosts>contoso.com</PermittedHosts>
Answer: A,C,F,G
Explanation:
A:
*
In the configuration file, the delivery method is set through the SendUsing configuration setting.
*
SendUsing specifies a method for sending messages. You can choose between a network SMTP service or a local SMTP service pickup directory. To use a remote SMTP service, this value must be set to 2 in the RSReportServer.config file.
C, F:
*
From scenario: Email notification for SSRS01 has not been previously configured. Email notification must be configured to use the SMTP server SMTP01 with a From address of reports@contoso.com.
*
SMTPServer specifies the remote SMTP server or forwarder. This value is a required value if you are using a remote SMTP server or forwarder.
G:
* From scenario: Report distribution must be secured by using SSL and must be limited to the contoso.com domain.
Note:
Configuration Options for Remote SMTP Service
The connection between the report server and an SMTP server or forwarder is determined by the following configuration settings:
*
SendUsing specifies a method for sending messages. You can choose between a network SMTP service or a local SMTP service pickup directory. To use a remote SMTP service, this value must be set to 2 in the RSReportServer.config file.
*
SMTPServer specifies the remote SMTP server or forwarder. This value is a required value if you are using a remote SMTP server or forwarder.
*
From sets the value that appears in the From: line of an e-mail message. This value is a required value if you are using a remote SMTP server or forwarder.
Other values that are used for remote SMTP service include the following (note that you do not need to specify these values unless you want to override the default values).
*
SMTPServerPort is configured for port 25.
*
SMTPAuthenticate specifies how the report server connects to the remote SMTP server.
Reference: Configure a Report Server for E-Mail Delivery (Reporting Services), Configuration Options for Remote SMTP Service
