70-768 무료 덤프문제 온라인 액세스

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
A company has an e-commerce website. When a customer places an order, information about the transaction is inserted into tables in a Microsoft SQL Server relational database named OLTP1. The company has a SQL Server Analysis Services (SSAS) instance that is configured to use Tabular mode. SSAS uses data from OLTP1 to populate a data model.
Sales analysts build reports based on the SSAS model. Reports must be able to access data as soon as it is available in the relational database.
You need to configure and deploy an Analysis Services project to the Analysis Services instance that allows near real-time data source access.
Solution: In the Deployment Option property for the report, you set the Query Mode to InMemory.
Does the solution meet the goal?

• A.Yes
• B.No

How can you enhance the model to support analysis by date?

• A.Create a date table in a new SQL Server database, and import it into the model by using the Table Import Wizard.
• B.Create a calculated table using the CALENDARAUTO function and add calculated columns to the calculated table to derive year, quarter, and month from the InvoiceDate columns.
• C.Create a calculated column in the Internet Sales and Direct Sales tables using the CALENDAR function on the InvoiceDate column.
• D.Create calculated columns in the Internet Sales and Direct Sales tables to derive year, quarter, and month from the InvoiceDate columns.

You are creating a SQL Server Analysis Services (SSAS) cube.
You need to create a time dimension. It must be linked to a measure group named Sales at the day granularity level.
It must also be linked to a measure group named Salary at the month granularity level.
What should you do?

• A.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.
• B.Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• C.Add a measure group that has one measure that uses the DistinctCount aggregate function
• D.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.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a travel agency that specializes in vacation packages. Vacation bookings and packages are stored in a SQL Server database. You use the model as the basis for customer emails that highlight vacation packages that are currently underbooked, or projected to be underbooked.
The company plans to incorporate cruise ship vacation packages. Cruise ship vacation packages include new features such as region availability and cruise line specialties that require changes to the tabular model.
You must ensure that the tabular model reflects the new vacation packages.
You need to configure the tabular data model.
What should you do?

• A.Ensure that the Transactional Deployment property is set to True.
• B.Ensure that DirectQuery is enabled for the model.
• C.Process the model in Process Full mode.
• D.Ensure that DirectQuery is disabled for the model.
• E.Ensure that the Transactional Deployment property is set to False.
• F.Process the model in Process Data mode.
• G.Process the model in Process Defrag mode.

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have a Microsoft SQL Server Analysis Services (SSAS) instance that is configured to use multidimensional mode. You create the following cube:

Users need to be able to analyze sales by product and color.
You need to create the dimension.
Which relationship type should you use between the InternetSales table and the new dimension?

• A.data mining
• B.referenced
• C.regular
• D.many-to-many
• E.fact
• F.no relationship