시험에 불합격하면 응시료를 다시 지불해야 하므로 한 번의 합격이 무엇보다 중요합니다. Fast2test의 070-768 모의고사 70문항으로 실전 감각을 미리 익혀 재응시 비용 부담을 줄여 보시기 바랍니다. 2026년에도 꾸준히 업데이트되는 자료입니다.

Microsoft 070-768 시험 개요:

Microsoft 070-768 시험 요강 주제:

070-768 시험에 대해 궁금한 점을 모았습니다

최신 MCSA 070-768 무료샘플문제

문제 #1

You are developing a tabular Business Intelligence Semantic Model (BISM) database based on a SQL Server database.
In the data source, the FactInternetSales table is partitioned by month. Data from the current month has been updated and new data has been inserted in the FactInternetSales table, in the DimProduct table, and in the DimCustomer table.
In the model, the FactInternetSales table is also partitioned by month. You need to ensure that the model has the most recent data while minimizing the processing time.
What should you do?

A. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Defrag processing option.
B. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Defrag processing option. Then process the database with the Process Recalc processing option.
C. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Recalc processing option.
D. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Full processing option.
E. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Data processing option.

문제 #2

You manage your department's SQL Server Analysis Services (SSAS) projects. The sales department uses a tabular model to analyze sales data. Users report excessive wait times when updating the model.
You need to improve the performance of the model. What should you do?

A. Partition the table.
B. Define relationships.
C. Define a hierarchy.
D. Create a perspective.

문제 #3

Which of the following object types do you add to the cube?

A. Calculated member set
B. Dynamic named set
C. Calculated measure
D. Static named set

문제 #4

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model defines a measure named Profit and includes a table named Date.
The table includes year, semester, quarter, month, and date columns.
The Date column is of data type Date.
The table contains a set of contiguous dates.
You need to create a measure to report on year-over-year growth of profit.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

A. Use the Business Intelligence Wizard and then use the Define time intelligence enhancement.
B. Define the following calculation. Year Over Year Profit Growth:=[Profit] - CALCULATE([Profit], PARALLELPERIOD('Date'[Date], -12, MONTH))
C. Define the following calculation. Year Over Year Profit Growth:=CALCULATE([Profit], DATEADD('Date'[Date], 1, YEAR))
D. Define the following calculation. Year Over Year Profit Growth:=[Profit] - CALCULATE([Profit], SAMEPERIODLASTYEAR('Date'[Date]))

문제 #5

You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, queries must be resolved only by using cache.
You need to configure the appropriate query mode.
Which query mode should you select?

A. In-Memory
B. In-Memory with DirectQuery
C. DirectQuery
D. DirectQuery with In-Memory

질문과 대답: