70-470 Exam
Jan 2021 updated: Exambible Microsoft 70-470 pdf exam 111-120
Your success in Microsoft 70-470 is our sole target and we develop all our 70-470 braindumps in a way that facilitates the attainment of this target. Not only is our 70-470 study material the best you can find, it is also the most detailed and the most updated. 70-470 Practice Exams for Microsoft 70-470 are written to the highest standards of technical accuracy.
Q111. - (Topic 9)
You have a SQL Server Reporting Services (SSRS) 2008 instance integrated with an Internet-facing Microsoft SharePoint 2010 farm. PerformancePoint Services and Excel Services are installed and configured.
You need to upgrade to SSRS 2012 with the minimum downtime and hardware requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Migrate SSRS content to a separate instance of SSRS 2012 on the same server.
B. Perform an in-place upgrade of the SSRS environment.
C. Migrate SSRS content to new servers that run SSRS 2012.
D. Install SSRS 2012 on a new SharePoint farm and migrate content to the new farm.
Answer: C
Q112. - (Topic 4)
You need to develop a BISM that meets the business requirements for ad-hoc and daily operational analysis. You must minimize development effort.
Which development approach and mode should you use?
A. Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to DirectQuery.
B. Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to In-Memory with DirectQuery.
C. Develop a multidimensional project and configure the model with the DirectQuery mode setting off.
D. Develop a multidimensional project and configure the cube to use hybrid OLAP (HOLAP) storage mode.
Answer: C
Explanation:
/ After the upgrade users must be able to perform the following tasks:
/ Ad-hoc analysis of data in the SSAS databases by using the Microsoft Excel PivotTable
client (which uses MDX).
/ Daily operational analysis by executing a custom application that uses ADOMD.NET and
existing Multidimensional Expressions (MDX) queries.
/ Deploy a data model to allow the ad-hoc analysis of data. The data model must be
cached and source data from an OData feed.
We cannot use DirectQuery mode so C is the only answer that will provide the required
caching.
When a model is in DirectQuery mode, it can only be queried by using DAX. You cannot
use MDX to create queries. This means that you cannot use the Excel Pivot Client,
because Excel uses MDX.
Q113. HOTSPOT - (Topic 9)
You are developing a SQL Server Reporting Services (SSRS) solution.
You plan to create reports based on a SQL Server Analysis Services (SSAS) tabular
database configured in DirectQuery mode.
You need to configure a shared data source.
Which data source type should you use?
To answer, select the appropriate type from the drop-down list in the answer area.
Answer:
Q114. HOTSPOT - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube.
You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of
the previous year. (Line numbers are included for reference only.)
You need to complete the MDX statement.
Which MDX function should you use in line 03? To answer, select the appropriate MDX function in the functions list.
Answer:
Q115. - (Topic 10)
You are designing a SQL Server Analysis Services (SSAS) cube based on a Windows Azure SQL Database data warehouse.
You need to implement a degenerate dimension.
What should you do?
A. Use the fact table as the data source for the dimension.
B. Create a junk dimension table based on the fact table in the data source.
C. Create snowflake dimension tables based on normalized views of the fact table in the data source.
D. Add a surrogate key to the fact table and use it as the degenerate dimension key.
Answer: A
Q116. - (Topic 9)
Your network contains the following components:
...
Microsoft SharePoint Server 2010 SQL Server 2008 Service Pack 2 (SP2) SQL Server 2008 Service Pack 1 (SP1) in Reporting Services Native Mode
You need to recommend a solution to upgrade the network to SQL Server 2014. The solution must meet the following requirements:
..
Minimize the amount of time that SharePoint services are unavailable. Deploy the upgraded Reporting Services instance in Reporting Services SharePoint Integrated Mode.
You upgrade the Database Engine to SQL Server 2014.
Which three actions should you recommend performing next? Each correct answer presents part of the solution.
A. Install a SQL Server 2014 Reporting Services add-in for SharePoint on all of the front-end Web servers that have SharePoint Server installed.
B. Perform an in-place upgrade to SQL Server Reporting Services (SSRS) 2014.
C. Perform a SharePoint 2013 side-by-side upgrade.
D. Perform a SharePoint 2013 in-place upgrade.
E. Migrate legacy reports and application data.
F. Install a new instance of SQL Server Reporting Services (SSRS) 2014.
Answer: A,E,F
Q117. - (Topic 10)
You are managing a SQL Server Reporting Services (SSRS) instance.
A website must pass credentials to the local security authority for Reporting Services.
You need to configure Reporting Services to issue a challenge/response when a
connection is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?
A. RSWindowsKerberos and RSWindowsNegotiate
B. RSWindowsKerberos only
C. RSWindowsKerberos and RSWindowsNTLM
D. RSWindowsBasic
Answer: A
Q118. - (Topic 9)
A company runs SQL Server Database Engine and SQL Server Reporting Services (SSRS) in native mode. Reports are based on data that is cached in multiple shared datasets. Source data is purged each day at midnight for regulatory compliance purposes. The shared datasets may continue to cache data that should not be used in reports. Shared report schedules are often paused during nightly server maintenance windows.
Reports must not return purged data.
You need to create a fully automated solution to ensure that reports do not deliver purged data.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a shared schedule. Configure the datasets to expire on the shared schedule.
B. Write a script that calls the flushcache method to clear individual items from the SSRS cache. Create a SQL Server Agent job that runs rs.exe with the script as an input file, and schedule the job to run every day after the purge process completes.
C. Create a SQL Server Agent job that uses a Transact-SQL (T-SQL) step to delete the data from the dbo.ExecutionCache table in the ReportServerTempDB database. Schedule the job to run every day after the purge process completes.
D. Republish the cached datasets by using SQL Server Data Tools.
Answer: B
Q119. - (Topic 10)
You are designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?
A. Use role playing dimensions.
B. Use the Business Intelligence Wizard to define dimension intelligence.
C. Add a measure that uses the Count aggregate function to an existing measure group.
D. Add a measure that uses the DistinctCount aggregate function to an existing measure group.
E. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
F. Add a measure group that has one measure that uses the DistinctCount aggregate function.
G. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
H. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
I. Create several dimensions. Add each dimension to the cube.
J. Create a dimension. Then add a cube dimension and link it several times to the measure group.
K. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
L. Create a dimension with one attribute hierarchy. Set the IsAggregatable prooerty to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
M. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
N. Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
O. Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
Answer: F
Q120. - (Topic 10)
You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a SQL Azure database.
The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the report displays only a user selected map region.
Which source of spatial data should you use for the map?
A. SQL Server spatial query
B. Bing Maps layer
C. ESRI shape file
D. Map gallery
Answer: A